HomeMy WebLinkAboutQ3 2016 Financial ReportOverview
Agenda Subject: 3rd Quarter 2016 Financial Report Date: November 18, 2016 Department: Finance Attachments: Quarterly Financial Report Budget Impact: $0 Administrative Recommendation:
For discussion only. Background Summary: The quarterly financial report summarizes the general state of Citywide financial affairs and highlights significant items or trends that the
City Council should be aware of. The attachment provides the third quarter 2016 status report based on financial data available as of October 28, 2016 for the period ending September
30, 2016 and sales tax information representing business activity that occurred through July 2016. Staff: Coleman Meeting Date: November 28, 2016 Item Number: 1
General Fund Summary Property TaxesSales TaxesOther TaxesIntergovernmental(Grants, etc.)DevelopmentService FeesCulture &RecreationOther Fees& ChargesOtherRevenuesPersonnelSupplies& ServicesIntergovernmentalOther
ExpendituresRevenuesExpenditures$0$5$10$15$20$25$30MillionsYTDBudgetYTDActuals(Favorable)YTDActuals(Unfavorable)Year-To-DateGeneral Fund Revenues and Expenditures(Through Q3-2016)$41.7$50.0$45.0$46.8TotalRevenuesTotalExpenditures$0$10$20$30$40$50$60MillionsCouncil&
MayorAdministrativeServicesCommunity &Human ServicesMunicipal Court& ProbationHumanResourcesFinanceCity AttorneyCommunityDevelopmentJail -SCOREPolicePublic WorksParks, Arts& RecreationStreetsNon-Departmental$0$5$10$15$20MillionsYTDBudgetYTDActuals(Favorable)YTDActuals(Unfavorable)Year-To-DateGeneral
Fund Expenditures by Department(Through Q3-2016) 2
September 2016 Financial ReportGeneral Fund2015Summary of Sources and UsesAnnualBudgetYTD BudgetYTD ActualYTD ActualAmountOperating RevenuesProperty Tax517,733,500$ 9,763,600$ 9,920,666$
9,500,023$ 157,066$ 1.6 %Sales Tax614,572,000 10,793,100 11,036,028 10,850,092 242,928 2.3 %Sales Tax -Annexation Credit1,912,000 1,411,100 1,500,373 1,469,642 89,273 6.3 %Criminal Justice
Sales Tax1,747,000 1,288,300 1,454,287 1,341,552 165,987 12.9 %Brokered Natural Gas Tax282,000 226,500 177,005 195,126 (49,495) (21.9)%City Utilities Tax83,521,200 2,618,300 2,901,188
2,712,038 282,888 10.8 %Admissions Tax333,600 257,800 269,321 278,210 11,521 4.5 %Electric Tax83,297,700 2,511,200 2,733,513 2,393,107 222,313 8.9 %Natural Gas Tax8852,000 754,800 833,093
878,683 78,293 10.4 %Cable TV Franchise Fee9906,700 678,500 728,136 689,428 49,636 7.3 %Cable TV Franchise Fee -Capital64,000 48,000 49,877 53,921 1,877 3.9 %Telephone Tax81,620,000
1,233,600 1,144,823 1,271,170 (88,777) (7.2)%Garbage Tax (external)8106,000 79,470 92,985 84,177 13,515 17.0 %Leasehold Excise Tax33,000 23,200 191,475 45,968 168,275 725.3 %Gambling
Excise Tax334,400 276,800 403,771 147,986 126,971 45.9 %Taxes sub-total47,315,100$ 31,964,270$ 33,436,540$ 31,911,123$ 1,472,270$ 4.6 %Business License Fees11221,000$ 127,700$ 106,657$
154,096$ (21,044)$ (16.5)%Building Permits101,190,000 938,800 1,432,215 977,631 493,415 52.6 %Other Licenses & Permits533,600 382,200 582,773 434,921 200,573 52.5 %Intergovernmental
(Grants, etc.)125,627,893 4,073,903 4,179,792 3,929,887 105,889 2.6 %Charges for Services:General Government Services1367,200 49,300 61,991 60,462 12,691 25.7 %Public Safety13520,300
395,678 453,345 396,978 57,666 14.6 %Development Services Fees14680,600 501,600 794,082 933,627 292,482 58.3 %Culture and Recreation152,105,080 1,810,600 2,076,505 2,030,266 265,905
14.7 %Fines and Forfeits16796,180 613,000 696,072 711,380 83,072 13.6 %Fees/Charges/Fines sub-total11,741,853$ 8,892,781$ 10,383,431$ 9,629,247$ 1,490,650$ 16.8 %Interest and Other Earnings1735,200$
26,000$ 81,161$ 32,834$ 55,161$ 212.2 %Rents, Leases and Concessions17630,600 508,600 645,327 574,287 136,727 26.9 %Contributions and Donations1732,000 25,100 26,883 31,947 1,783 7.1
%Other Miscellaneous17157,800 117,900 228,553 159,007 110,653 93.9 %Transfers In220,926 139,000 139,112 76,000 112 0.1 %Insurance Recoveries -Capital & Operating25,000 18,743 58,094
131,404 39,352 210.0 %Other Revenues sub-total1,101,526$ 835,343$ 1,179,131$ 1,005,479$ 343,789$ 41.2 %Total Operating Revenues60,158,479$ 41,692,393$ 44,999,102$ 42,545,850$ 3,306,709$
7.9 %Operating ExpendituresCouncil & Mayor1,085,833$ 810,500$ 802,274$ 662,611$ 8,226$ 1.0 %Administration 1,350,722 1,013,400 831,249 746,156 182,151 18.0 %Community & Human Services1,329,547
819,200 577,608 644,041 241,592 29.5 %Municipal Court & Probation2,355,889 1,974,000 1,892,377 1,888,511 81,623 4.1 %Human Resources1,406,554 1,016,200 930,960 793,308 85,240 8.4 %Finance1,300,773
1,029,500 898,832 975,764 130,668 12.7 %City Attorney2,194,830 1,568,500 1,410,070 1,370,421 158,430 10.1 %Community Development4,731,841 3,507,500 3,014,962 2,868,071 492,538 14.0 %Jail
-SCORE5,583,542 3,485,746 3,014,605 2,744,147 471,141 13.5 %Police23,794,252 17,687,100 17,490,649 16,388,842 196,451 1.1 %Public Works2,809,335 2,090,900 2,262,105 1,975,023 (171,205)
(8.2)%Parks, Arts & Recreation11,584,205 8,768,200 8,627,328 8,320,497 140,872 1.6 %Streets3,466,563 2,389,100 2,256,727 2,044,555 132,373 5.5 %Non-Departmental5,539,627 3,862,413 2,783,240
4,145,992 1,079,173 27.9 %Total Operating Expenditures68,533,514$ 50,022,259$ 46,792,985$ 45,567,941$ 3,229,273$ 6.5 %PageRef20162016 YTD Budget vs. ActualFavorable (Unfavorable)Percentage
3
Executive Summary This Executive Summary provides an overview of the City’s overall financial position for the fiscal period ending September 30, 2016, reflecting financial data available
as of October 28, 2016. Through September 2016, General Fund revenues totaled $45.0 million compared to a budget of $41.7 million, and were $2.5 million higher than the revenues collected
during the same period in 2015. Some notable variances to budget year-to-date include: • Property tax collections through Q3-2016 totaled $9.9 million, which is 1.6% or $157,000 above
budget expectations and exceed collections in the same period last year by $421,000, or 4.4%. The majority of property tax revenues are collected during the months of April and October,
coinciding with the due dates for the County property tax billings. [page 5] • General Fund retail sales tax revenues totaled $11.0 million, exceeding budget by 2.3% or $243,000, and
exceeding 2015 collections by $186,000. The primary area of significant increase in sales activity compared to 2015 was the services category. [page 6] Collections in criminal justice
sales tax revenues exceeded budget by $166,000, or 12.9%. • The Other Taxes category performed better than budget through Q3-2016. City utility tax revenues exceeded budget by $283,000
or 10.8%, predominately due to higher than budgeted capital system development revenues collected in the Water, Sewer and Storm funds. Electric and natural gas tax revenues collected
through September exceeded budget by $222,000 and $78,000, respectively. These revenues were somewhat offset by an unfavorable variance in telephone tax collections of $89,000. [page
8] Year-to-date collections of leasehold excise taxes were $168,000 favorable to budget due to an unbudgeted payment for the Emerald Downs property which is tribally owned. Gambling
excise tax revenues exceeded budget by $127,000 primarily due to the timing of payments: the City’s main remitter of card game taxes paid 6 months worth of taxes from 2015 in the current
year. • Building permit revenue through Q3-2016 exceeded budget by $493,000, and already exceeds year-end budget expectations. This was predominately due to a higher than anticipated
volume of building permits as well as multiple large commercial building permits issued. [page 10] • Other licenses and permit revenues exceeded budget expectations by $201,000 primarily
due to higher than anticipated revenue collected for plumbing permits. This increase in revenues was a result of increased construction activity within the City. One project in particular
that contributed to this influx of revenue is the permitting for the Promenade Apartment Project on 312th Street. • Development services fees revenues collected year-to-date exceeded
budget expectations by $292,000, or 58.3%. This is predominately due to higher than anticipated revenues collected for plan check services related to multiple single family and commercial
construction projects within the City. [page 14] 4
• Culture and recreation revenues exceeded year-to-date budget by $266,000, and exceeded revenues collected the same period in 2015 by $46,000, or 2.3%. Revenue sources that were significantly
above budget include golf course and special events revenues. [page 15] • Year-to-date rents, leases and concession revenues were $137,000 or 26.9% above budget, and were $71,000 more
than collected the same period in 2015. This favorable variance is attributed to higher than anticipated revenues collected for City owned facility rentals and parking lot fees. [page
17] General Fund expenditures through the third quarter of 2016 totaled $46.8 million compared to a budget of $50.0 million, representing a 6.5% favorable variance to budget. All departments
operated within their allocated budget through Q3-2016 with the exception of the Public Works department. This department is running over budget YTD through September by $171,000, or
8.2%. The variance to budget is seen in salary and benefit expenditures, as project engineers are charging more of their time to general fund projects versus transportation and utility
projects. Year-to-date through September General Fund expenditures are $1.2 million, or 2.7%, higher than the same period last year. Salary and benefit costs increased by $1.4 million,
or 5.7% compared to the same period in 2015. This year-over-year increase is due primarily to an increase in Council approved FTEs (Full Time Equivalents) and increased costs associated
with healthcare and pension benefits. In addition, charges for services paid to Valley Communications for 911 services have increased year-over-year by $406,000, or 20.0%. These increased
expenditures were somewhat offset by a reduction in intergovernmental expenditures by $915,000 as compared to the same period in 2015. $41.7 M $50.0 M $45.0 M $46.8 M $0.0$10.0$20.0$30.0$40.0$50.0$60.0RevenuesExpenditures$
MillionsGeneral Fund 2016 Revenues vs. Expenditures2016 YTD Actual2016 YTD Budget 5
Revenues The combined total of property, sales/use, utility, gambling, and admissions taxes provides approximately 80% of all resources supporting general governmental activities. The
following section provides additional information on these sources. Property Tax collections through Q3-2016 totaled $9,921,000, which is 1.6% or $157,000 above budget expectations.
Property tax collections through Q3-2016 exceeded collections for the same period last year by $421,000, or 4.4%. The majority of property tax revenues are collected during the months
of April and October, coinciding with the due dates for the County property tax billings. $0.0$2.0$4.0$6.0$8.0$10.0$12.0$14.0$16.0$18.0$20.0JanFebMarAprMayJunJulAugSepOctNovDecMillionsProperty
Taxes2016 Budget2016 YTD Actual2015 Actual 6
Sales tax collections year-to-date totaled $12.7 million, of which $11.0 million was distributed to the General Fund and $1.7 million was distributed to the Local Street Fund (SOS) program.*
Through September 2016, total sales tax revenue distributions to the General Fund exceeded budget expectations by $243,000, or 2.3%. * Beginning in 2013, Local Street Fund (Fund 103)
street repairs have been funded from sales taxes on construction. The total amount transferred year-to-date through Q3-2016 was $1,651,379. The graphic above presents sales taxes under
the current policy. $0.0$2.0$4.0$6.0$8.0$10.0$12.0$14.0$16.0JanFebMarAprMayJunJulAugSepOctNovDecMillionsSales & Use Tax(Net of Revenue from Construction)2016 Budget2016 YTD Actual2015
Actual 7
The following table breaks out the City’s base sales tax, excluding Criminal Justice, Annexation Credit and Streamlined Sales Tax Mitigation, by major business sector. Total sales tax
revenue collected through Q3-2016 exceeded prior year collections by $223,000, or 1.8%. The business sectors showing the largest increase in revenues compared to last year were the service
and construction industries. Sales tax revenue on construction, which is transferred to the Local Street Fund (Fund 103) for local street repair and maintenance, totaled $1,651,000,
which is $48,000 higher than the same period in 2015. Year-to-date sales tax on construction revenue exceeded budget expectations by $498,000 or 43.1%. 20152016Component GroupActualActualAmountConstruction1,602,935$
1,651,379$ 48,443$ 3.0 %Manufacturing666,248602,662(63,586)(9.5)%Transportation & Warehousing46,93165,96219,03140.5 %Wholesale Trade934,506930,697(3,808)(0.4)%Automotive2,772,6802,746,266(26,415)(1.0)%Retail
Trade3,719,0223,636,892(82,130)(2.2)%Services2,651,5613,018,436366,87513.8 %Miscellaneous51,22515,603(35,622)(69.5)%YTD Total12,445,109$ 12,667,897$ 222,788$ 1.8 %Change from 2015September
2016Comparison of Sales Tax Collections by SIC GroupPercentage$0.0$0.2$0.4$0.6$0.8$1.0$1.2$1.4$1.6$1.8$2.0$2.2$2.4JanFebMarAprMayJunJulAugSepOctNovDecMillionsSales Tax on Construction
Transfer 2016 Budget2016 YTD Actual2015 Actual 8
Utility Taxes consist of interfund taxes on City utilities (Water, Sewer, Storm and Solid Waste) and taxes on external utilities (Electric, Natural Gas, Telephone and Solid Waste). Utility
taxes collected through Q3-2016 totaled $7.7 million and exceeded year-to-date budget by $508,000, or 7.1%. Favorable variances in City interfund utility tax, electric tax, natural gas
tax and solid waste tax revenues more than offset lower than expected collections from the telecommunication industry. City interfund utility tax revenue was $283,000 or 10.8% higher
than the year-to-date budget. A significant portion of this favorability to budget is predominately due to higher than budgeted capital system development revenues collected in the Water,
Sewer and Storm funds. $0.0$2.0$4.0$6.0$8.0$10.0$12.0JanFebMarAprMayJunJulAugSepOctNovDecMillionsUtility Tax2016 Budget2016 YTD Actual2015 Actual201520162016Utility Tax TypeYTD ActualYTD
BudgetYTD ActualAmountAmountCity Interfund Utility Taxes2,712,038$ 2,618,300$ 2,901,188$ $ 189,150 7.0 % $ 282,888 10.8 %Electric 2,393,1072,511,2002,733,513340,406 14.2 %222,313 8.9
%Natural Gas878,683754,800833,093(45,590)(5.2)%78,293 10.4 %Telephone1,271,1701,233,6001,144,823(126,347)(9.9)%(88,777)(7.2)%Solid Waste (external)84,17779,47092,9858,808 10.5 %13,515
17.0 %YTD Total7,339,175$ 7,197,370$ 7,705,602$ $ 366,427 5.0 % $ 508,232 7.1 %September 2016Utility Tax by Type2016 vs. 2015 Actual2016 vs. BudgetPercentagePercentage 9
Cable TV Franchise Fees, which are collected quarterly, totaled $728,000 for Q3-2016. Year-to-date revenues exceeded budget of $679,000 by $50,000, or 7.3%. $0$100$200$300$400$500$600$700$800$900$1,0001st
Quarter2nd Quarter3rd Quarter4th QuarterThousandsCable TV Franchise Fee2016 Budget2016 YTD Actual2015 Actual 10
Licenses and Permits include business licenses, building permits, plumbing, electric and other licenses and permit fees. Building permit fees and business licenses make up about 70%
of the annual budgeted revenue in this category. Building permit revenues collected through September total $1.4 million and compare to a year-to-date budget of $939,000. Building permits
issued through September totaled 660, and compare to 594 issued during the same period in 2015. Major projects contributing to revenues this quarter include building permits for the
Promenade Apartment Project, Lakeland Storage and the Green River College Student Affairs building, as well as other projects and numerous housing developments within the City – most
notably Lakeland Hills Estates and Calla Crest. $0.0$0.2$0.4$0.6$0.8$1.0$1.2$1.4$1.6JanFebMarAprMayJunJulAugSepOctNovDecMillionsBuilding Permits2016 Budget2016 YTD Actual2015 Actual
11
Business license revenues collected through September total $107,000 and compare to budget of $128,000; these revenues were below budget by $21,000 largely due to the timing of collections.
The graphic below reflects the timing of payments by business owners, where the majority of business license payments are typically collected during the first two months of the year
and the last month of the year. $0$20$40$60$80$100$120$140$160$180$200$220$240$260$280$300JanFebMarAprMayJunJulAugSepOctNovDecThousandsBusiness Licenses2016 Budget2016 YTD Actual2015
Actual 12
Intergovernmental revenues include grants (direct and indirect Federal, state and local), compact revenue from the Muckleshoot Indian Tribe (MIT), intergovernmental, and state shared
revenues. Collections to date total $4.2 million and were $106,000, or 2.6% higher than budget. Favorable variances in Criminal Justice High Crime revenues and Motor Vehicle Fuel Tax
revenues offset the reduced revenues received in Federal and State grant monies. Year-to-date, grant revenues collected are under budget although this is primarily due to the timing
of when grant reimbursement is requested. Effective during the state’s 2016-2017 fiscal year budget cycle, the City of Auburn qualified for the Criminal Justice High Crime revenue distribution
monies (distributions are made quarterly between July 1, 2016 through June 30, 2017). The eligibility requirements are based upon the City’s crime rate statistics – those Cities whose
crime rate exceeds 125% of the statewide average qualify for the distribution. The first distribution was received in July and totaled $143,000. 201520162016RevenueYTD ActualYTD BudgetYTD
ActualAmountAmountFederal Grants148,202$ 228,600$ 181,274$ $ 33,073 22.3 % $ (47,326)(20.7)%State Grants192,790152,000120,966(71,824)(37.3)%(31,034)(20.4)%Interlocal Grants9,70713,40028,97319,267
0.0 %15,573 116.2%Muckleshoot Casino Emerg.449,301472,500496,52447,223 10.5 %24,024 5.1%Intergovernmental Service14,42310,19517,3042,882 20.0 %7,109 69.7%State Shared Revenues: Streamlined
Sales Tax1,468,0821,500,0001,443,924(24,158)(1.6)%(56,076)(3.7)% Motor Vehicle Fuel Tax784,333788,100823,04438,712 4.9 %34,944 4.4% Criminal Justice -High Crime96,50948,000142,62846,118
47.8 %94,628 197.1% Criminal Justice -Population14,84313,50015,480637 4.3 %1,980 14.7% Criminal Justice -Special Prog.54,43350,80056,4942,061 3.8 %5,694 11.2% Marijuana Enforcement4,88114,62519,58914,708
301.3 %4,964 33.9% State DUI8,32810,1008,843515 6.2 %(1,257)(12.4)% Fire Insurance Tax75,70270,00076,569867 1.1 %6,569 9.4% Liquor Excise117,851226,958259,959142,107 120.6 %33,001 14.5%
Liquor Profit490,501475,125488,220(2,282)(0.5)%13,095 2.8% Total State Shared:3,115,4653,197,2083,334,750219,2847.0 %137,542 4.3%YTD Total3,929,887$ 4,073,903$ 4,179,792$ 249,905$ 6.4
%105,889$ 2.6%September 2016Intergovernmental2016 vs. 2015 Actual2016 vs. Budget% Change% Change 13
Charges for Services consist of general governmental services, public safety, development service fees and cultural & recreation fees. Overall, charges for services collected through
Q3-2016 totaled $3.4 million and compare to a year-to-date budget of $2.8 million; they were 1.0% or $35,000 less than revenues collected the during the same period in 2015. General
governmental revenues through Q3-2016 totaled $62,000 compared to a budget of $49,000. Budget expectations for these revenues were revised from the prior year due to the fact that the
City no longer provides services to the City of Algona; therefore, the City does not receive reimbursement for services. The majority of the favorable variance was due to increased sales
related to passport services, which are running $14,000 higher than year-to-date budget and $8,000 higher than collections the same period in 2015. Public safety revenues consist of
revenues generated for Police Officer extra duty overtime, where officers are contracted for services and reimbursement is made by the hiring contractor. Effective June 2014, public
safety revenue also includes reimbursement from the Muckleshoot Indian Tribe (MIT) for a full-time dedicated Police Officer and associated expenditures. Public safety revenues collected
year-to-date totaled $453,000, compared to budget of $396,000. Year-over-year revenues collected increased by $56,000 – which was a result of a 14.3% increase in billable hours for extra
duty overtime, compared to the same period in 2015. 201520162016RevenueYTD ActualYTD BudgetYTD ActualAmountAmountGeneral Government60,462$ 49,300$ 61,991$ $ 1,529 2.5 % $ 12,691 25.7
%Public Safety396,978395,678453,34556,367 14.2 %57,666 14.6 %Development Services933,627501,600794,082(139,545)(14.9)%292,482 58.3 %Culture & Recreation2,030,2661,810,6002,076,50546,239
2.3 %265,905 14.7 %YTD Total3,421,332$ 2,757,178$ 3,385,923$ (35,409)$ (1.0)% $628,745 22.8 %September 2016Charges for Services by Type2016 vs. 2015 Actual2016 vs. BudgetPercentagePercentage
14
Development services fee collections, which primarily consist of plan check fees, totaled $794,000 and already exceed annual budget expectations by $113,000. Year to date plan check
revenues, the largest component of development services fees, totaled $587,000 as compared with an annual budget of $550,000 and a year-to-date budget of $405,000. Revenues collected
through Q3-2016 are from numerous commercial and residential projects including the Multicare remodel project, Lakeland Storage, improvements at Boeing as well as plans for Lakeland
Hills Estates, Edgeview and Mountain View North housing developments. $0.0$0.2$0.4$0.6$0.8$1.0$1.2$1.4$1.6JanFebMarAprMayJunJulAugSepOctNovDecMillionsDevelopment Service Fees2016 Budget2016
YTD Actual2015 Actual 15
Culture and recreation revenues totaled $2.1 million, exceeding year-to-date budget by $266,000 and exceeding revenues collected the same period the year prior by $46,000, or 2.3%. Revenue
sources with significant increases compared to 2015 include Special Events revenue and revenue generated from the Cultural Arts Program. $0.0$0.2$0.4$0.6$0.8$1.0$1.2$1.4$1.6$1.8$2.0$2.2$2.4$2.6JanFebMarAprMayJunJulAugSepOctNovDecMillionsCulture
& Recreation2016 Budget2016 YTD Actual2015 Actual 16
Fines & Penalties include traffic and parking infraction penalties, criminal fines (including criminal traffic, criminal non traffic and other criminal offenses) as well as non-court
fines such as false alarm fines. Total revenues collected through Q3-2016 totaled $696,000, and compare to a budget of $613,000. Significant sources of revenue increases compared to
year-to-date budget expectations include increase in false alarm fines and parking infractions. 201520162016MonthYTD ActualYTD BudgetYTD ActualAmountAmountCivil Penalties8,823$ 11,900$
21,179$ $ 12,355 140.0 % $ 9,279 78.0 %Civil Infraction Penalties384,758349,800358,003(26,756)(7.0)%8,203 2.3 %Redflex Photo Enforcement1,859013,55011,691 628.9 %13,550 N/A%Parking Infractions105,87783,500100,942(4,936)(4.7)%17,442
20.9 %Criminal Traffic Misdemeanor41,56837,60038,984(2,584)(6.2)%1,384 3.7 %Criminal Non-Traffic Fines36,89536,30034,146(2,750)(7.5)%(2,154)(5.9)%Criminal Costs42,70633,50046,0443,338
7.8 %12,544 37.4 %Non-Court Fines & Penalties88,89260,40083,226(5,666)(6.4)%22,826 37.8 %YTD Total711,380$ 613,000$ 696,072$ $ (15,308)(2.2)% $ 83,072 13.6 %September 2016Fines & Forfeits
by Type2016 vs. 2015 Actual2016 vs. BudgetPercentagePercentage$0.0$0.1$0.2$0.3$0.4$0.5$0.6$0.7$0.8$0.9$1.0JanFebMarAprMayJunJulAugSepOctNovDecMillionsFines & Penalties2016 Budget2016
YTD Actual2015 Actual 17
Miscellaneous revenues primarily consist of investment earnings, income from facility rentals, contributions & donations, and other miscellaneous income, which includes the quarterly
purchasing card (P-card) rebate monies. Total revenues collected in this category through Q3-2016 totaled $982,000 and exceeded budget expectations by $304,000, or 44.9%. Primary contributors
to this favorable variance to budget include higher than anticipated revenues from facilities rentals and golf cart rentals. In addition, P-card rebate revenues collected to date were
$67,000 higher than anticipated. 201520162016MonthYTD ActualYTD BudgetYTD ActualAmountAmountInterest & Investments32,834$ 26,000$ 81,161$ 48,327$ 147.2 %55,161$ 212.2 %Rents & Leases574,287508,600645,32771,04012.4
%136,72726.9 %Contributions & Donations31,94725,10026,883(5,064)(15.9)%1,7837.1 %Other Miscellaneous Revenue159,007117,900228,55369,54643.7 %110,65393.9 %YTD Total798,076$ 677,600$ 981,925$
183,849$ 23.0 %304,325$ 44.9 %Miscellaneous Revenues by TypeSeptember 20162016 vs. 20152016 vs. BudgetPercentagePercentage 18
Real Estate Excise Tax (REET) revenue is receipted into the Capital Improvement Projects Fund and is used for governmental capital projects. REET revenues collected through Q3-2016 totaled
$3.5 million and exceeded year-to-date budget by $1.2 million, or 56.2%. Year-to-date revenues collected were $235,000 lower than the same period in 2015, which included the sale of
several large businesses in the City such as the Outlet Collection – Seattle and the Lakeland Town Center. Real estate sales in the City of Auburn in Q3-2016 represent the sale of both
commercial and single family residences including the sale of numerous multifamily apartment complexes, several warehouses and multiple large acre vacant lots. 201520162016MonthActualBudgetActualAmountAmountJan125,089$
97,400$ 339,594$ 214,505$ 171.5%242,194$ 248.7%Feb115,287128,700286,943171,656148.9%158,243123.0%Mar1,394,226601,900293,361(1,100,865)(79.0)%(308,539)(51.3)%Apr423,394244,000574,925151,53135.8%330,925135.6%May345,489234,300255,078(90,410)(26.2)%20,7788.9%Jun436,101267,400329,081(107,020)(24.5)%61,68123.1%Jul348,745260,200360,85712,1123.5%100,65738.7%Aug269,454212,100673,012403,557149.8%460,912217.3%Sep228,140163,500338,340110,20048.3%174,840106.9%OctNovDecYTD
Total3,685,925$ 2,209,500$ 3,451,191$ (234,734)$ (6.4)%1,241,691$ 56.2%2016 vs. 20152016 vs. BudgetPercentageReal Estate Excise Tax RevenuesSeptember 2016Percentage$0.0$0.5$1.0$1.5$2.0$2.5$3.0$3.5$4.0$4.5$5.0JanFebMarAprMayJunJulAugSepOctNovDecMillionsReal
Estate Excise Tax2016 Budget2016 YTD Actual2015 Actual 19
Pet Licensing Year-to-date, 3,616 pet licenses were sold, resulting in $99,925 in revenue. For the same period in 2015, 3,956 licenses were sold, resulting in $113,335 in revenue. 05001,0001,5002,0002,500$0$2$4$6$8$10$12$14$16$18JanFebMarAprMayJunJulAugSepOctNovDecNumber
of Licenses IssuedLicense Revenue( thousands )Pet Licensing Revenues vs Licenses Sold2016 vs 20152015 License Revenue2016 License Revenue2015 Licenses Issued2016 Licenses Issued01,0002,0003,0004,0005,0006,000$0$20$40$60$80$100$120$140JanFebMarAprMayJunJulAugSepOctNovDecNumber
of Licenses IssuedLicense Revenue( thousands )Cumulative Pet Licensing Revenue & Licenses Issued2016 vs 20152016 License Revenue2016 Licenses Issued2015 Licenses Issued 20
Street Funds This section provides financial overview of the City’s three street funds for the fiscal period ending September 30, 2016. The City’s three street funds are: the Arterial
Street Fund (Fund 102), the Local Street Fund (Fund 103), and the Arterial Street Preservation Fund (Fund 105). Capital project expenditures are budgeted primarily based on the collection/disbursement
average for the same period of the prior two years. Fund 102 – Arterial Street Fund The Arterial Street Fund is a Special Revenue Fund that is funded by transportation grants, traffic
impact fees, a portion of the City’s gas tax receipts, Public Works Trust Fund loans, developer contributions, and other sources. There are over 40 separate street projects budgeted
in this fund in 2016. Some of these projects include the South 272nd /South 277th Street Corridor Improvement Project, the West Main Street Multimodal Corridor and ITS Improvement Project,
and the AWS Corridor Safety Improvement Project (Muckleshoot Plaza to Dogwood). Through September 2016, revenues collected totaled $2.3 million and compare to collections of $2.4 million
for the same period in 2015. Expenditures through September totaled $3.0 million and compare to $3.9 million spent the same period last year. Expenditures for the projects South 272nd/South
277th Street Corridor Improvements and West Main Street Multimodal Corridor and ITS Improvements, which constitute nearly 60% of budgeted capital expenditures, are below budget due to
delays in project start times and timing lag between work performance and the City’s reimbursement of costs incurred. Fund 102 -Arterial Street2015Summary of Sources and UsesAnnualReport
Period: September 2016BudgetYTD BudgetYTD ActualYTD ActualAmountRevenuesFederal Grants7,270,016$ 3,185,116$ 493,143$ 975,716$ (2,691,973)$ (84.5)%State Grants4,292,973 1,912,095 198,554
319,214 (1,713,541) (89.6)%Motor Vehicle Fuel and Multimodal Taxes530,000 397,500 432,411 363,669 34,911 8.8 %Developer Contributions1,601,145 -188,781 -188,781 Miscellaneous Revenue373,805
280,354 64,862 82,953 (215,492) (76.9)%Other Governmental Agencies---61,520 -Public Works Trust Fund Loans-----Operating Transfer In3,882,586 -943,207 553,723 943,207 Investment Income2,000
1,500 5,478 2,159 3,978 265.2 %Total Revenues17,952,525$ 5,776,564$ 2,326,435$ 2,358,953$ (3,450,129)$ (59.7)%ExpendituresSalary and Benefits839,323$ 609,574$ 355,490$ 299,722$ 254,084$
41.7 %Capital Outlay17,428,903 9,460,179 2,216,277 3,178,951 7,243,903 76.6 %Subtotal -Capital Project Expenditures18,268,226 10,069,753 2,571,766 3,478,673 7,497,987 74.5 %Services
and Charges245,000 183,750 187,898 146,492 (4,148) (2.3)%Interfund Payments for Services74,550 55,913 55,917 53,361 (5) (0.0)%Debt Service Principal and Interest217,862 -210,205 218,761
(210,205) Operating Transfer Out-----Total Expenditures18,805,638$ 10,309,416$ 3,025,786$ 3,897,287$ 7,283,630$ 70.7 %Net Change in Fund Balance(853,113)$ (4,532,852)$ (699,351)$ (1,538,334)$
3,833,501$ (84.6)%Beg. Fund Balance, September 20162,405,821$ Net Change in Fund Balance, September 2016(699,351)Ending Fund Balance, September 20161,706,470$ 2016 Budgeted Ending Fund
Balance1,552,709$ 20162016 YTD Budget vs. ActualFavorable (Unfavorable)Percentage 21
This table presents the status of the projects with the most significant impact on this fund: Notes: • S 277th St. Corridor Improvements: Environmental requirements causing delays. Roughly
70% of project ($4.2 million) is scheduled for completion in 2017. • W. Main St. Multimodal: Roughly 80% of project ($3.5 million) is projected to be completed during 2017. • AWS Corridor
Safety Improvements: Project slowed during ROW acquisition. Balance of $2.4 million will be completed in 2017. $0.0$2.0$4.0$6.0$8.0$10.0$12.0$14.0$16.0$18.0JanFebMarAprMayJunJulAugSepOctNovDecMillionsFund
102 -Capital Project Expenditures2016 YTD Budget2016 YTD Actual2015 YTD Actual2016 YE Budget $18.3M2015 YE Actual$6.4M2016 YTD Actual$2.6M2015 YTD Actual$3.5M*Data consists of capital
outlays, salaries and benefits.NameAnnual BudgetYTD ActualVarianceS. 277th St Corridor Improvements$ 5.99 M$1.10 M$ 4.89 MW. Main St Multimodal Corridor & ITS Imp$ 4.38 M$0.37 M$ 4.01
MAWS Corridor Safety Imp. --Muckleshoot Pl.$ 2.58 M$0.18 M$ 2.40 MAll Other Projects$ 5.32 M$0.92 M$ 4.40 MTotal$18.27 M$2.57 M$15.70 MFund 102 -Arterial StreetCapital Projects Status
22
Fund 103 – Local Street Fund The Local Street Fund is a Special Revenue Fund where the revenues from sales taxes on construction are used for local street repairs. Through September
2016 the revenues in this fund exceeded budget expectations by $504,000, or 38.6%, due to higher than anticipated sales tax revenues from local construction projects. Expenditures through
September totaled $1.1 million and compare to a year to date budget of $1.2 million. The majority of expenditures from the Fund’s largest project, 2016 Local Street Pavement Reconstruction
Project, are anticipated to occur in Q4-2016. Fund 103 -Local Street Fund2015Summary of Sources and UsesAnnualReport Period: September 2016BudgetYTD BudgetYTD ActualYTD ActualAmountRevenuesSales
Tax on Construction1,610,000$ 1,153,700$ 1,651,379$ 1,602,935$ 497,679$ 43.1 %Operating Transfer In150,000 150,000 150,000 150,000 --Interest Earnings2,500 1,875 8,501 2,667 6,626 353.4
%Total Revenues1,762,500$ 1,305,575$ 1,809,880$ 1,755,602$ 504,305$ 38.6 %ExpendituresSalary and Benefits175,090$ 131,317$ 89,919$ 78,943$ 41,398$ 31.5 %Services and Charges300 225 532
416 (307) (136.5)%Capital Outlay2,676,768 1,041,860 953,978 1,107,349 87,882 8.4 %Interfund Payments for Services12,240 9,180 9,180 9,360 --Operating Transfer Out------Total Expenditures2,864,398$
1,182,582$ 1,053,610$ 1,196,068$ 128,973$ 10.9 %Net Change in Fund Balance(1,101,898)$ 122,993$ 756,270$ 559,534$ 633,278$ 514.9 %Beg. Fund Balance, September 20162,080,690$ Net Change
in Fund Balance, September 2016756,270Ending Fund Balance, September 20162,836,960$ 2016 Budgeted Ending Fund Balance978,792$ 20162016 YTD Budget vs. ActualFavorable (Unfavorable)Percentage
23
This table presents the status of the projects with the most significant impact on this fund: Notes: • 2016 Local Street Pavement Reconstruction: Scheduled for substantial completion
November 2016. • 2017 Local Street Reconstruction & Preservation: Still in design phase, to be carried forward to 2017. $0.0$0.5$1.0$1.5$2.0$2.5JanFebMarAprMayJunJulAugSepOctNovDecMillionsFund
103 -Capital Outlay2016 YTD Budget2016 YTD Actual2015 YTD Actual2016 Projected Actual2016 YE Budget $2.7M2016 YE ProjectedActual$2.1M2016 YTDActual$0.95M2015 YEActual$2.3MNameAnnual
BudgetYTD ActualVariance2016 Local Street Pavement Reconst.$2.36 M$0.93 M$1.42 M2017 Local St. Reconst. & Preservation$0.30 M$0.00 M$0.30 MAll Other Projects$0.02 M$0.02 M$0.00 MTotal$2.68
M$0.95 M$1.72 MFund 103 -Local StreetCapital Projects Status 24
Fund 105 – Arterial Street Preservation Fund The Arterial Street Preservation Fund is a Special Revenue Fund which is primarily funded by a 1.0% utility tax that was adopted by Council
in 2008. These utility tax revenues are restricted for arterial street repair and preservation projects. Some projects budgeted within the Arterial Street Preservation Fund in 2016 include
Pavement Patching and Overlay, the Annual Arterial and Collector Crack Seal Project, the Auburn Way North Preservation Project and the B Street NW Reconstruction Project. Through September
2016 revenues totaled $1.6 million and compare to a budget of $2.1 million. The difference is mostly due to the Auburn Way North Preservation project being pushed back to 2017, resulting
in $880,000 in budgeted federal grant funding being delayed. Expenditures through September totaled $862,000, which is approximately 63% of budgeted expenditures for the period. Actuals
are lower than budget primarily due to the Fund’s main project, Auburn Way North Preservation, being repackaged and sent to bid a second time after the first round of bidding produced
higher-than-expected costs. This project is anticipated to be rebid in February 2017, affecting the Fund’s 2016 year-end projection significantly. In addition, the Fund’s next-largest
project, B Street NW Reconstruction, remains in the design phase due to prioritizing grant-funded projects on the verge of expiration. Construction on this project is anticipated to
start in March 2017. Fund 105 -Arterial St. Presv. 2015Summary of Sources and UsesAnnualReport Period: September 2016BudgetYTD BudgetYTD ActualYTD ActualAmountRevenuesCity Utility Tax
589,000$ 437,900$ 483,531$ 452,006$ 45,631$ 10.4 %Electric Utility Tax660,500 502,900 546,703 478,621 43,803 8.7 %Natural Gas Utility Tax170,400 151,500 166,619 175,737 15,119 10.0 %Cable
TV Tax181,300 135,700 147,046 139,192 11,346 8.4 %Telephone Utility Tax324,000 251,000 228,965 254,234 (22,035) (8.8)%Garbage Utility Tax (External Haulers)17,700 13,275 15,498 14,030
2,223 16.7 %Grants1,053,626 517,881 843 35,301 (517,038) (99.8)%Developer Mitigation Fees------Operating Transfer In150,000 112,500 30,932 612,340 (81,568) -Interest Earnings1,500 1,125
6,673 2,719 5,548 493.2 %Total Revenues3,148,026$ 2,123,781$ 1,626,809$ 2,164,180$ (496,972)$ (23.4)%ExpendituresSalary and Benefits124,095$ 93,072$ 206,327$ 162,060$ (113,256)$ (121.7)%Capital
Outlay4,258,226 2,093,016 448,274 2,850,174 1,644,742 78.6 %Subtotal -Capital Project Expenditures4,382,321 2,186,088 654,601 3,012,234 1,531,486 70.1 %Supplies------Services and Charges212,500
159,375 37,525 -121,850 76.5 %Operating Transfer Out401,750 301,313 170,276 8,411 131,037 43.5 %Total Expenditures4,996,571$ 2,646,775$ 862,402$ 3,020,645$ 1,784,373$ 67.4 %Net Change
in Fund Balance(1,848,545)$ (522,994)$ 764,407$ (856,465)$ 1,287,401$ (246.2)%Beg. Fund Balance, September 20161,943,865$ Net Change in Fund Balance, Sept. 2016764,407Ending Fund Balance,
September 20162,708,272$ 2016 Budgeted Ending Fund Balance95,319$ 20162016 YTD Budget vs. ActualFavorable (Unfavorable)Percentage 25
This table presents the status of the projects with the most significant impact on the fund: Notes: • Auburn Way N Preservation: This project to be re-bid in Spring 2017 after unsatisfactory
2016 bids. • B Street NW Reconstruction: Project still in design due to prioritizing grant-funded projects that were expiring. $0.0$0.5$1.0$1.5$2.0$2.5$3.0$3.5$4.0$4.5$5.0JanFebMarAprMayJunJulAugSepOctNovDecMillionsFund
105 -Capital Projects Expenditures2016 YTD Budget2016 YTD Actual2015 YTD Actual2016 Projected Actual2016 YE Budget $4.4M2015 YE Actual$4.0M2016YTD Actual$0.65M2016 YEProjected Actual$0.79M*Data
consists of capital outlays, salaries and benefits.NameAnnual BudgetYTD ActualVarianceAuburn Way North Preservation$1.81 M$0.08 M$1.73 MB Street NW Reconstruction$1.43 M$0.05 M$1.38
MAll Other Projects$1.14 M$0.53 M$0.62 MTotal$4.38 M$0.66 M$3.73 MCapital Projects StatusFund 105 -Arterial Street Preservation 26
Fund 124 – Mitigation Fees The Mitigation Fees Fund is a Special Revenue Fund funded from revenue from new development, which is assessed at the time applications are received for development
activity. These funds are used to mitigate costs associated with City growth. Through Q3-2016, revenues were significantly above budget expectations, at 255.1% of the annual budgeted
amount. This is due to higher-than-expected transportation, parks and fire impact fee revenues in the month of July, driven by the construction of The Promenade, a 298-unit apartment
complex in Lea Hill. Another revenue spike is anticipated in Q4-2016 due to the construction of a 600-unit mixed-use senior and multifamily housing development comprising The Villas
and The Reserve. Expenditures year-to-date are well below budget due to delays in construction projects funded by these revenues. Fund 124 -Mitigation FeesSummary of Sources and UsesReport
Period Through:EndingEndingSeptember 2016Fund BalanceFund BalanceTransportation Impact Fees1,695,367$ 767,294$ 4,610,158$ 800,000$ 3,006,075$ 1,476,010$ Transportation Migitation Fees-$
4,020$ 253,690$ -$ 173,144$ 84,566$ Fire Impact Fees160,728$ -$ 474,948$ 100,000$ 50,000$ 364,220$ Fire Mitigation Fees-$ -$ 82$ -$ -$ 82$ Parks Impact Fees1,544,598$ 70,661$ 2,597,150$
75,000$ 300,000$ 898,213$ Parks Mitigation Fees-$ -$ 330,319$ -$ -$ 330,319$ School Impact Admin Fees16,744$ 40,112$ 54,747$ 15,000$ 61,626$ 31,489$ Wetland Mitigation Fees-$ -$ 68,626$
-$ -$ 68,626$ Interest and Investment Income21,849$ -$ 21,849$ 4,890$ -$ 4,890$ Fees in Lieu of Improvements122,525$ -$ 122,525$ -$ -$ -$ Operating Transfers-$ -$ -$ 400,000$ -$ 400,000$
Total3,561,810$ 882,087$ 8,534,092$ 1,394,890$ 3,590,845$ 3,658,415$ Beginning Fund Balance, September 20165,854,370$ Net Change in Fund Balance, September 20162,679,722$ Ending Fund
Balance, September 20168,534,092$ 2016 Budgeted Ending Fund Balance3,658,415$ YTD ACTUALSBUDGETRevenuesExpendituresRevenuesExpenditures 27
Proprietary Funds Detailed income and expense statements for Enterprise and Internal Service funds can be found in the Appendices at the end of this report. The format changed in Q1-2016
and, in lieu of a working capital statement, there are now operating and capital fund reports for most of these funds showing budget, actual and variance. The operating fund houses all
the operating costs along with debt service and financing obligations. The capital fund shows costs associated with capital acquisition and construction. Both the operating fund and
the capital fund have a working capital balance. This approach isolates those funds available for capital and cash flow needs for daily operations, and project managers will know exactly
how much working capital is available for current and planned projects. Budget Amendment #6, adopted July 2016, moved working capital from the operating funds to the capital funds along
with all the other beginning fund balance adjustments. System development revenues previously credited to the operating funds are now directed to the corresponding capital funds. At
the end of the third quarter, the Water Utility had operating income of $3.3 million as compared with operating income of $3.2 million for the same period in 2015. Water sales through
Q3-2016 totaled 2.71 million hundred cubic feet (ccf), compared to 2.66 million ccf during the same period in 2015, representing a 2.1% increase. Year-to-date revenues are 10.0% above
budget but this is expected to come closer to budget in Q4-2016, as the highest revenues are historically generated from August through October. 0100,000200,000300,000400,000500,000600,000700,000800,000900,0001,000,000$0$200$400$600$800$1,000$1,200$1,400$1,600$1,800$2,000JanFebMarAprMayJunJulAugSepOctNovDecCCFThousandsWater
Revenues vs Water Sold2016 vs 20152015 Water Sales ($)2016 Water Sales ($)2015 Water Sold (ccf)2016 Water Sold (ccf) 28
The Sewer Utility ended the quarter with net operating income of $1.5 million, which is $124,000 higher than the same period in 2015. The Sewer-Metro Utility ended the quarter with a
year-to-date net operating income of $236,000, as compared with $59,000 through Q3-2015. $0$100$200$300$400$500$600$700$800$900JanFebMarAprMayJunJulAugSepOctNovDecThousandsSewer2016
BudgetRevenue2016 ActualRevenue2016 ActualExpenses2015 ActualRevenue2016 Budget vs. ActualMonthly Revenues and Expenditures 29
The Stormwater Utility ended Q3-2016 with $2.1 million in operating income, which is about $1.3 million below the same period in 2015. This is due in large part to the receipt of grant
revenues from the Department of Ecology in Q2 and Q3-2015. $0$200$400$600$800$1,000$1,200$1,400$1,600$1,800$2,000JanFebMarAprMayJunJulAugSepOctNovDecThousandsStorm Drainage2016 BudgetRevenue2016
ActualRevenue2016 ActualExpenses2015 ActualRevenue2016 Budget vs. ActualMonthly Revenues and ExpendituresDept. of Ecology Revenues 30
The Cemetery Fund ended the second quarter with a year-to-date operating income of $167,000 as compared with operating income of $102,000 for the same period in 2015. Operating expenditures
totaled $857,000 in through Q3-2016, compared to $838,000 in the same period last year. The increase is mainly a result of higher cost of supplies due to increased inventory costs associated
with higher demand. Internal Service Funds Operating expenditures within the Insurance Fund represent the premium cost pool that will be allocated monthly to other City funds over the
course of 2016. As a result, this balance will gradually diminish each month throughout the year. No significant variances are reported in the Worker’s Compensation, Facilities, Innovation
& Technology, or Equipment Rental Funds. Contact Information This report is prepared by the Finance Department. Additional financial information can also be viewed at our website: http://www.auburnwa.gov/.
For any questions about this report please contact Shelley Coleman at scoleman@auburnwa.gov. $0$200$400$600$800$1,000$1,200$1,400JanFebMarAprMayJunJulAugSepOctNovDecThousandsCemetery2016
YTD BudgetRevenue2016 YTD ActualRevenue2015 YTD ActualRevenue2016 YTD ActualExpensesCumulative Revenues and Expenditures2016 Budget vs. Actual 31
InvestmentPurchasePurchaseMaturityYield toTypeDatePriceDateMaturityState Investment PoolVarious113,513,552$ Various0.52%KeyBank Money MarketVarious5,263,806Various0.02%FNMA3/11/2016998,8442/22/20191.20%LAKUTL9/25/2013235,91911/1/20171.90%
Total Cash & Investments120,012,120$ 0.503%Investment Mix% of TotalState Investment Pool94.6%Current 6-month treasury rate0.47%KeyBank Money Market4.4%Current State Pool rate0.52%US
Treasury0.0%KeyBank Money Market0.02%FNMA0.8%LAKUTL0.2%100.0%City of AuburnInvestment Portfolio SummarySeptember 30, 2016Summary 32
SALES TAX SUMMARYSEPTEMBER 2016 SALES TAX DISTRIBUTIONS (FOR JULY 2016 RETAIL ACTIVITY)2015 Annual Total2015 YTD2016 YTDYTD2015 Annual Total2015 YTD2016 YTDYTDNAICSCONSTRUCTION (Nov
'14-Oct '15)(Nov '14-Jul '15)(Nov '15-Jul '16)% DiffNAICSAUTOMOTIVE(Nov '14-Oct '15)(Nov '14-Jul '15)(Nov '15-Jul '16)% Diff236Construction of Buildings1,229,166863,806798,884-7.5%441Motor
Vehicle and Parts Dealer3,465,1992,587,1362,563,887-0.9%237Heavy and Civil Construction252,280164,662229,62139.4%447Gasoline Stations241,336185,544182,379-1.7%238Specialty Trade Contractors815,416574,468622,8748.4%TOTAL
AUTOMOTIVE3,706,5352,772,6802,746,266-1.0%TOTAL CONSTRUCTION 2,296,8631,602,9351,651,3793.0%Overall Change from Previous Year-26,415Overall Change from Previous Year48,4432015 Annual
Total2015 YTD2016 YTDYTD2015 Annual Total2015 YTD2016 YTDYTDNAICSRETAIL TRADE(Nov '14-Oct '15)(Nov '14-Jul '15)(Nov '15-Jul '16)% DiffNAICSMANUFACTURING(Nov '14-Oct '15)(Nov '14-Jul
'15)(Nov '15-Jul '16)% Diff442Furniture and Home Furnishings253,871189,327135,870-28.2%311Food Manufacturing3,9732,1812,48513.9%443Electronics and Appliances295,127217,286175,342-19.3%312Beverage
and Tobacco Products9,3237,0807,1531.0%444Building Material and Garden589,676439,564434,761-1.1%313Textile Mills372247219-11.2%445Food and Beverage Stores368,411274,668298,973d8.8%314Textile
Product Mills3,0392,0292,1576.3%446Health and Personal Care Store220,603166,104202,42621.9%315Apparel Manufacturing11610514638.9%448Clothing and Accessories1,079,933793,985835,8335.3%316Leather
and Allied Products82321650.0%451Sporting Goods, Hobby, Books220,168164,796189,12314.8%321Wood Product Manufacturing65,03952,04045,860-11.9%452General Merchandise Stores988,004742,535c770,8973.8%322Paper
Manufacturing7,7624,5475,47520.4%453Miscellaneous Store Retailers578,836451,623356,739-21.0%323Printing and Related Support59,75045,61440,523-11.2%454Nonstore Retailers394,268279,134236,928-15.1%324Petroleum
and Coal Products5,3944,1871,902-54.6%TOTAL RETAIL TRADE4,988,8983,719,0223,636,892-2.2%325Chemical Manufacturing5,5084,1786,03444.4%Overall Change from Previous Year-82,130326Plastics
and Rubber Products9,0817,0836,439-9.1%327Nonmetallic Mineral Products14,5148,42912,75051.3%331Primary Metal Manufacturing1,6921,430295-79.4%2015 Annual Total2015 YTD2016 YTDYTD332Fabricated
Metal Product Manuf37,81922,55323,4153.8%NAICSSERVICES(Nov '14-Oct '15)(Nov '14-Jul '15)(Nov '15-Jul '16)% Diff333Machinery Manufacturing21,69318,01012,686-29.6%51*Information526,003380,736b461,33821.2%334Computer
and Electronic Product8,3886,3528,50833.9%52*Finance and Insurance95,47171,02783,16517.1%335Electric Equipment, Appliances827466350-24.8%53*Real Estate, Rental, Leasing334,095245,591269,9269.9%336Transportation
Equipment Man536,513427,859381,562-10.8%541Professional, Scientific, Tech195,478146,216175,61220.1%337Furniture and Related Products20,38914,39713,358-7.2%551Company Management9,2309,225307-96.7%339Miscellaneous
Manufacturing50,35837,45831,315-16.4%56*Admin. Supp., Remed Svcs373,781252,765256,1061.3%TOTAL MANUFACTURING861,555666,248602,662-9.5%611Educational Services60,18943,751a36,214-17.2%Overall
Change from Previous Year-63,58662*Health Care Social Assistance81,68463,86975,01517.5%71*Arts and Entertainment207,717131,423133,2811.4%72*Accommodation and Food Svcs1,159,033852,841895,8315.0%2015
Annual Total2015 YTD2016 YTDYTD81*Other Services475,505354,970519,02846.2%NAICSTRANSPORTATION AND WAREHOUSING(Nov '14-Oct '15)(Nov '14-Jul '15)(Nov '15-Jul '16)% Diff92*Public Administration127,36499,148112,61413.6%481Air
Transportation001N/ATOTAL SERVICES3,645,5512,651,5613,018,43613.8%482Rail Transportation10,4577,2119,67934.2%Overall Change from Previous Year366,875484Truck Transportation7,5905,9002,756-53.3%485Transit
and Ground Passengers20915567-56.7%488Transportation Support36,66925,60641,86163.5%2015 Annual Total2015 YTD2016 YTDYTD491Postal Service2591961960.1%NAICSMISCELLANEOUS(Nov '14-Oct '15)(Nov
'14-Jul '15)(Nov '15-Jul '16)% Diff492Couriers and Messengers1119216179.7%000Unknown000N/A493Warehousing and Storage10,4877,86111,21042.6%111-115Agriculture, Forestry, Fishing4,5103,1034,27737.8%TOTAL
TRANSPORTATION65,67146,93165,96240.5%211-221Mining & Utilities27,45620,22821,4245.9%Overall Change from Previous Year19,031999Unclassifiable Establishments39,58127,894-10,098e-136.2%TOTAL
SERVICES71,54851,22515,603-69.5%Overall Change from Previous Year-35,6222015 Annual Total2015 YTD2016 YTDYTDNAICSWHOLESALE TRADE(Nov '14-Oct '15)(Nov '14-Jul '15)(Nov '15-Jul '16)% Diff423Wholesale
Trade, Durable Goods1,010,730777,233718,538-7.6%GRAND TOTAL16,865,54012,445,10912,667,897424Wholesale Trade, Nondurable216,303155,789210,48535.1%Overall Change from Previous Year222,7881.8%425Wholesale
Electronic Markets1,8851,4841,67512.8%TOTAL WHOLESALE1,228,919934,506930,697-0.4%Overall Change from Previous Year-3,808Includes Adjustments in excess of +/-$10,000.a.WA State Dept of
Revenue audit adjustment to sales tax returns for period of February 2015 (adjustment: $11,845).b.WA State Dept of Revenue audit adjustment to sales tax returns for period of March 2015
(adjustment: -$17,839).c.WA State Dept of Revenue audit adjustment to sales tax returns for period of April 2015 (adjustment: -$43,875).d.WA State Dept of Revenue audit adjustment to
sales tax returns for period of November 2015 (adjustment: $10,572).e.WA State Dept of Revenue audit adjustment to sales tax returns for period of April 2016 (adjustment: -$52,898).10/03/16Prepared
by Auburn Finance Department 33
BudgetYTDActualVarianceBudgetYTDActualVarianceBudgetYTDActualVarianceBudgetYTDActualVariance430 430 431 431 433 433 432 432 OPERATING FUND:460460461461462462OPERATING REVENUESCharges
For Service13,698,782 10,713,435 (2,985,347) 7,847,883 6,238,777 (1,609,106) 16,332,687 12,557,592 (3,775,095) 9,151,487 7,129,978 (2,021,509) Grants---50,000 -(50,000) Interest Earnings7,735
31,342 23,607 10,697 42,122 31,425 700 3,434 2,734 13,865 45,862 31,997 Interfund Charges For Service----Sewer Metro Service Revenue----Operating Transfers---Rents, Leases, Concessions,
& Other206,854 430,744 223,890 70,128 46,417 (23,711) ---58,674 60,175 1,501 TOTAL OPERATING REVENUES13,913,371 11,175,521 (2,737,850) 7,928,708 6,327,317 (1,601,391) 16,333,387 12,561,026
(3,772,361) 9,274,026 7,236,015 (2,038,011) OPERATING EXPENSESSalaries & Wages2,587,276 1,878,687 708,589 1,758,478 1,249,369 509,109 ---2,397,119 1,911,568 485,551 Benefits1,251,312
860,576 390,736 871,146 572,282 298,865 ---1,224,350 867,463 356,888 Supplies321,994 207,146 114,848 130,500 70,650 59,850 ---94,300 56,657 37,643 Other Service Charges5,185,175 3,259,070
1,926,105 2,723,275 1,848,723 874,552 ---1,670,215 954,776 715,439 Capital-739 (739) ---------Intergovernmental Services133,960 74,335 59,625 172,008 99,870 72,138 415,980 313,682 102,298
Waste Management Payments Sewer Metro Services16,317,200 12,325,136 3,992,064 Debt Service Interest1,006,253 461,036 545,217 277,082 149,443 127,639 ---360,525 186,317 174,208 Interfund
Loan Repayment---Interfund Operating Rentals & Supplies1,276,967 957,760 319,207 952,338 714,543 237,795 ---1,312,518 985,939 326,579 TOTAL OPERATING EXPENSES11,762,936 7,699,349 4,063,586
6,884,827 4,704,879 2,179,948 16,317,200 12,325,136 3,992,064 7,475,007 5,276,402 2,198,605 OPERATING REVNUES LESS EXPENSESBEFORE DEPRECIATION (*)2,150,435 3,476,172 1,325,737 1,043,881
1,622,438 578,557 16,187 235,889 219,702 1,799,019 1,959,613 160,594 BEGINNING WORKING CAPITAL -January 1, 20162,488,639 2,488,639 -4,262,859 4,262,859 -2,358,518 2,358,518 -2,691,382
2,691,382 -ENDING WORKING CAPITAL -September 30, 20164,639,074 5,964,811 1,325,737 5,306,740 5,885,297 578,557 2,374,705 2,594,407 219,702 4,490,401 4,650,995 160,594 NET CHANGE IN WORKING
CAPITAL (see Note)2,150,435 3,476,172 1,325,737 1,043,881 1,622,438 578,557 16,187 235,889 219,702 1,799,019 1,959,613 160,594 CAPITAL FUND:CAPITAL REVENUESInterest Revenue1,265 -(1,265)
2,303 -(2,303) 2,135 -(2,135) Grants300,000 -Contributions------7,806 -(7,806) Other Non-Operating Revenue---------Gain (Loss) On Sale Of Fixed Assets---------Increase In Contributions
-System Development350,000 1,160,029 810,029 240,000 1,002,061 762,061 350,000 541,018 191,018 Increase In Contributions -Area Assessments---------Increase In Contributions -Other---------Increase
In Contributions -FAA---------Proceeds of Debt Activity4,070,037 820,037 (3,250,000) ------Operating Transfers In---------Other Sources-------142,511 142,511 TOTAL CAPITAL REVENUES4,421,302
1,980,066 (2,441,236) 242,303 1,002,061 759,758 659,941 683,529 323,588 CAPITAL EXPENSESOther Non-Operating Expense---------Net Change In Restricted Net Assets---Increase In Fixed Assets
-Salaries245,725 180,734 64,991 230,786 65,226 165,560 294,980 65,690 229,290 Increase In Fixed Assets -Benefits81,637 73,861 7,775 76,412 28,440 47,972 97,969 27,254 70,715 Increase
In Fixed Assets -Services-224 (224) -142 (142) -161 (161) Increase In Fixed Assets -Site Improvements-29,785 (29,785) -----Increase In Fixed Assets -Land----Increase In Fixed Assets
-Equipment---Increase In Fixed Assets -Construction9,160,179 4,661,505 4,498,674 3,831,262 462,921 3,368,340 4,390,563 443,245 3,947,318 Increase In Fixed Assets -Other---161 (161) Debt
Service Principal1,702,563 572,855 1,129,708 541,127 288,262 252,865 ---413,162 -413,162 Operating Transfers Out---------TOTAL CAPITAL EXPENSES11,190,103 5,518,965 5,671,139 4,679,587
844,992 3,834,595 5,196,674 536,510 4,660,164 BEGINNING WORKING CAPITAL -January 1, 20166,772,562 6,772,562 -8,600,000 8,600,000 -11,900,000 11,900,000 -ENDING WORKING CAPITAL -September
30, 20163,761 3,233,664 3,229,903 4,162,716 8,757,069 4,594,353 7,363,267 12,047,019 4,683,752 NET CHANGE IN WORKING CAPITAL (see Note)(6,768,801) (3,538,899) 3,229,903 (4,437,284) 157,069
4,594,353 (4,536,733) 147,019 4,683,752 Total Change in Working Capital(4,618,366) (62,727) 4,555,640 (3,393,403) 1,779,507 5,172,910 16,187 235,889 219,702 (2,737,714) 2,106,632 4,844,346
(*) Depreciation2,726,100 2,263,137 2,104,200 1,644,112 --1,688,400 1,452,624 Note: Working Capital = Current Assetsminus Current LiabilitiesENTERPRISE FUNDSOPERATING & CAPITAL FUNDSWATERSEWERSEWER
METROSTORMthrough September 2016 34 11/21/2016 3:13 PM
OPERATING FUND:OPERATING REVENUESCharges For ServiceGrantsInterest EarningsInterfund Charges For ServiceSewer Metro Service RevenueOperating TransfersRents, Leases, Concessions, & OtherTOTAL
OPERATING REVENUESOPERATING EXPENSESSalaries & WagesBenefitsSuppliesOther Service ChargesCapitalIntergovernmental ServicesWaste Management Payments Sewer Metro ServicesDebt Service InterestInterfund
Loan RepaymentInterfund Operating Rentals & SuppliesTOTAL OPERATING EXPENSES OPERATING REVNUES LESS EXPENSESBEFORE DEPRECIATION (*)BEGINNING WORKING CAPITAL -January 1, 2016ENDING WORKING
CAPITAL -September 30, 2016NET CHANGE IN WORKING CAPITAL (see Note)CAPITAL FUND:CAPITAL REVENUESInterest RevenueGrantsContributionsOther Non-Operating RevenueGain (Loss) On Sale Of Fixed
AssetsIncrease In Contributions -System DevelopmentIncrease In Contributions -Area AssessmentsIncrease In Contributions -OtherIncrease In Contributions -FAAProceeds of Debt ActivityOperating
Transfers InOther SourcesTOTAL CAPITAL REVENUESCAPITAL EXPENSESOther Non-Operating ExpenseNet Change In Restricted Net AssetsIncrease In Fixed Assets -SalariesIncrease In Fixed Assets
-BenefitsIncrease In Fixed Assets -ServicesIncrease In Fixed Assets -Site ImprovementsIncrease In Fixed Assets -LandIncrease In Fixed Assets -EquipmentIncrease In Fixed Assets -ConstructionIncrease
In Fixed Assets -OtherDebt Service PrincipalOperating Transfers OutTOTAL CAPITAL EXPENSESBEGINNING WORKING CAPITAL -January 1, 2016ENDING WORKING CAPITAL -September 30, 2016NET CHANGE
IN WORKING CAPITAL (see Note)Total Change in Working Capital(*) Depreciation Note: Working Capital = Current Assetsminus Current LiabilitiesOPERATING & CAPITAL FUNDSthrough September
2016BudgetYTDActualVarianceBudgetYTDActualVarianceBudgetYTDActualVarianceBudgetYTDActualVariance434 434 435 435 436 436 501 501 464464465465466466-13,467,100 10,450,311 (3,016,789) 747,400
615,184 (132,216) 878,000 1,022,806 144,806 ---109,000 15,375 (93,625) -----1,300 10,685 9,385 969 2,617 1,648 300 1,669 1,369 1,000 2,644 1,644 --------300,000 --320 320 500 (1,370)
(1,870) -20 20 -13,577,400 10,476,692 (3,100,708) 748,869 616,431 (132,438) 1,178,300 1,024,495 146,195 1,000 2,644 1,644 406,645 306,935 99,711 25,723 20,590 5,133 453,837 356,166 97,671
---206,181 139,203 66,977 10,496 7,010 3,486 258,783 182,759 76,023 215,000 112,132 102,868 34,200 7,248 26,952 2,000 1,523 477 191,300 192,732 (1,432) ---1,387,775 909,439 478,336 463,050
335,903 127,147 151,700 87,051 64,649 3,900 269,004 (265,104) ----420,600 181,206 239,394 ---------10,645,300 7,228,668 3,416,632 ---35,693 675 35,018 ------39,947 43,081 (3,134) --104,209
78,147 26,062 ---50,740 38,052 12,688 ---13,204,910 8,850,846 4,354,063 576,908 408,783 168,126 1,106,360 856,761 249,599 218,900 381,136 (162,236) 372,490 1,625,845 1,253,355 171,961
207,649 35,688 71,940 167,734 95,794 (217,900) (378,492) (160,592) 3,477,387 3,477,387 -166,604 166,604 -105,646 105,646 -1,530,589 1,530,589 -3,849,877 5,103,232 1,253,355 338,565 374,253
35,688 177,586 273,380 95,794 1,312,689 1,152,096 (160,592) 372,490 1,625,845 1,253,355 171,961 207,649 35,688 71,940 167,734 95,794 (217,900) (378,492) (160,592) 31 -(31) ---14,456
7,107 (7,349) ---------------------------------263,834 108,146 (155,688) ---------------------278,321 115,253 (163,068) ------------------------------12,699 14,541 (1,842) --------469,911
162,608 307,303 --------150,000 -150,000 ------------619,911 162,608 457,303 12,699 14,541 (1,842) 350,000 350,000 -270,000 270,000 -8,410 302,645 294,235 257,301 255,459 (1,842) (341,590)
(47,355) 294,235 (12,699) (14,541) (1,842) 372,490 1,625,845 (169,629) 160,294 329,923 59,241 153,193 93,952 (217,900) (378,492) (160,592) 20,000 14,114 426,100 341,007 58,300 37,887
--INTERNAL SERVICE FUNDSENTERPRISE FUNDSSOLID WASTEAIRPORTCEMETERYINSURANCE 35 11/21/2016 3:13 PM
OPERATING FUND:OPERATING REVENUESCharges For ServiceGrantsInterest EarningsInterfund Charges For ServiceSewer Metro Service RevenueOperating TransfersRents, Leases, Concessions, & OtherTOTAL
OPERATING REVENUESOPERATING EXPENSESSalaries & WagesBenefitsSuppliesOther Service ChargesCapitalIntergovernmental ServicesWaste Management Payments Sewer Metro ServicesDebt Service InterestInterfund
Loan RepaymentInterfund Operating Rentals & SuppliesTOTAL OPERATING EXPENSES OPERATING REVNUES LESS EXPENSESBEFORE DEPRECIATION (*)BEGINNING WORKING CAPITAL -January 1, 2016ENDING WORKING
CAPITAL -September 30, 2016NET CHANGE IN WORKING CAPITAL (see Note)CAPITAL FUND:CAPITAL REVENUESInterest RevenueGrantsContributionsOther Non-Operating RevenueGain (Loss) On Sale Of Fixed
AssetsIncrease In Contributions -System DevelopmentIncrease In Contributions -Area AssessmentsIncrease In Contributions -OtherIncrease In Contributions -FAAProceeds of Debt ActivityOperating
Transfers InOther SourcesTOTAL CAPITAL REVENUESCAPITAL EXPENSESOther Non-Operating ExpenseNet Change In Restricted Net AssetsIncrease In Fixed Assets -SalariesIncrease In Fixed Assets
-BenefitsIncrease In Fixed Assets -ServicesIncrease In Fixed Assets -Site ImprovementsIncrease In Fixed Assets -LandIncrease In Fixed Assets -EquipmentIncrease In Fixed Assets -ConstructionIncrease
In Fixed Assets -OtherDebt Service PrincipalOperating Transfers OutTOTAL CAPITAL EXPENSESBEGINNING WORKING CAPITAL -January 1, 2016ENDING WORKING CAPITAL -September 30, 2016NET CHANGE
IN WORKING CAPITAL (see Note)Total Change in Working Capital(*) Depreciation Note: Working Capital = Current Assetsminus Current LiabilitiesOPERATING & CAPITAL FUNDSthrough September
2016BudgetYTDActualVarianceBudgetYTDActualVarianceBudgetYTDActualVarianceBudgetYTDActualVariance503 503 505 505 518 518 550 550 --568568560560743,000 641,188 (101,812) 3,495,900 2,570,056
(925,844) 5,531,965 4,095,083 (1,436,883) 3,371,780 2,478,749 (893,031) ------100 2,685 2,585 2,500 7,880 5,380 3,088 10,665 7,577 4,048 17,534 13,486 --------137,950 4,342 203,997 99,997
120,000 30,431 (89,569) -----26,282 26,282 863,100 674,304 (188,796) 3,498,400 2,577,936 (920,464) 5,673,003 4,110,090 (1,429,305) 3,579,825 2,622,562 (853,263) 84,590 53,712 30,878
707,569 498,500 209,069 1,711,060 1,232,183 478,877 593,881 423,176 170,705 367,005 138,287 228,718 390,621 258,557 132,064 708,330 499,323 209,008 314,545 212,913 101,632 ---128,200
131,320 (3,120) 431,480 310,567 120,913 1,341,600 538,615 802,985 402,715 248,535 154,180 2,350,990 1,491,309 859,682 2,737,121 1,937,361 799,760 377,500 229,034 148,466 -----------890,827
-890,827 ---626,392 616,790 9,602 ---------5,033 3,885 1,148 -------110,841 83,133 27,708 160,790 120,591 40,199 212,390 159,397 52,993 854,310 440,535 413,776 4,579,048 2,462,818 2,116,230
5,748,782 4,100,025 1,648,757 3,471,341 2,183,810 1,287,531 8,790233,769 224,979 (1,080,648) 115,119 1,195,767 (75,779) 10,065 85,844 108,484 438,752 330,268 778,233 778,233 -2,410,754
2,410,754 -2,305,195 2,305,195 -2,974,119 2,974,119 -787,022 1,012,002 224,979 1,330,105 2,525,872 1,195,767 2,229,416 2,315,260 85,844 3,082,603 3,412,871 330,268 8,790 233,769 224,979
(1,080,648) 115,119 1,195,767 (75,779) 10,065 85,844 108,484 438,752 330,268 412 -(412) 1,652 -(1,652) ------------------------------------------------442,150 326,651 (115,499) 1,118,926
965,101 (153,825) ------442,562 326,651 (115,911) 1,120,578 965,101 (155,477) --------------------------------1,579,579 655,552 924,027 2,907,063 1,718,014 1,189,049 -723,002 55,241
667,761 -9,740 ---------39,107 19,480 19,627 ------1,579,579 655,552 924,027 3,669,172 1,802,476 1,876,436 1,400,000 1,400,000 -3,100,001 3,100,001 -262,983 1,071,099 808,116 551,406
2,262,625 1,711,220 (1,137,017) (328,901) 808,116 (2,548,595) (837,375) 1,711,220 8,790 233,769 224,979 (1,080,648) 115,119 1,195,767 (1,212,796) (318,836) 893,959 (2,440,111) (398,623)
2,041,488 ----546,400 525,631 822,500 790,556 WORKER'S COMPENSATIONFACILITIESINNOVATION & TECHNOLOGYEQUIPMENT RENTALINTERNAL SERVICE FUNDS 36 11/21/2016 3:13 PM
Agenda Subject: 3rd Quarter 2016 Financial Report Date: November 18, 2016
Department: Finance
Attachments: Quarterly Financial
Report
Budget Impact: $0
Administrative Recommendation: For discussion only.
Background Summary:
The quarterly financial report summarizes the general state of Citywide financial affairs and highlights
significant items or trends that the City Council should be aware of. The attachment provides the third
quarter 2016 status report based on financial data available as of October 28, 2016 for the period ending
September 30, 2016 and sales tax information representing business activit y that occurred through July
2016.
Staff: Coleman
Meeting Date: November 28, 2016 Item Number:
1
General Fund Summary
Property TaxesSales TaxesOther TaxesIntergovernmental(Grants, etc.)DevelopmentService FeesCulture &RecreationOther Fees& ChargesOtherRevenuesPersonnelSupplies& ServicesIntergovernmentalOther ExpendituresRevenues Expenditures
$0
$5
$10
$15
$20
$25
$30
MillionsYTD
Budget
YTD
Actuals
(Favorable)
YTD
Actuals
(Unfavorable)
Year-To-Date General Fund Revenues and Expenditures
(Through Q3-2016)$41.7
$50.0$45.0 $46.8
Total
Revenues
Total
Expenditures
$0
$10
$20
$30
$40
$50
$60
MillionsCouncil& MayorAdministrativeServicesCommunity &Human ServicesMunicipal Court& ProbationHumanResourcesFinanceCity AttorneyCommunityDevelopmentJail - SCOREPolicePublic WorksParks, Arts& RecreationStreetsNon-Departmental$0
$5
$10
$15
$20
MillionsYTD
Budget
YTD
Actuals
(Favorable)
YTD
Actuals
(Unfavorable)
Year-To-Date General Fund Expenditures by Department(Through Q3-2016)
2
September 2016 Financial Report
General Fund 2015
Summary of Sources and Uses Annual
Budget YTD Budget YTD Actual YTD Actual Amount
Operating Revenues
Property Tax 5 17,733,500$ 9,763,600$ 9,920,666$ 9,500,023$ 157,066$ 1.6 %
Sales Tax 6 14,572,000 10,793,100 11,036,028 10,850,092 242,928 2.3 %
Sales Tax - Annexation Credit 1,912,000 1,411,100 1,500,373 1,469,642 89,273 6.3 %
Criminal Justice Sales Tax 1,747,000 1,288,300 1,454,287 1,341,552 165,987 12.9 %
Brokered Natural Gas Tax 282,000 226,500 177,005 195,126 (49,495) (21.9)%
City Utilities Tax 8 3,521,200 2,618,300 2,901,188 2,712,038 282,888 10.8 %
Admissions Tax 333,600 257,800 269,321 278,210 11,521 4.5 %
Electric Tax 8 3,297,700 2,511,200 2,733,513 2,393,107 222,313 8.9 %
Natural Gas Tax 8 852,000 754,800 833,093 878,683 78,293 10.4 %
Cable TV Franchise Fee 9 906,700 678,500 728,136 689,428 49,636 7.3 %
Cable TV Franchise Fee - Capital 64,000 48,000 49,877 53,921 1,877 3.9 %
Telephone Tax 8 1,620,000 1,233,600 1,144,823 1,271,170 (88,777) (7.2)%
Garbage Tax (external)8 106,000 79,470 92,985 84,177 13,515 17.0 %
Leasehold Excise Tax 33,000 23,200 191,475 45,968 168,275 725.3 %
Gambling Excise Tax 334,400 276,800 403,771 147,986 126,971 45.9 %
Taxes sub-total 47,315,100$ 31,964,270$ 33,436,540$ 31,911,123$ 1,472,270$ 4.6 %
Business License Fees 11 221,000$ 127,700$ 106,657$ 154,096$ (21,044)$ (16.5)%
Building Permits 10 1,190,000 938,800 1,432,215 977,631 493,415 52.6 %
Other Licenses & Permits 533,600 382,200 582,773 434,921 200,573 52.5 %
Intergovernmental (Grants, etc.)12 5,627,893 4,073,903 4,179,792 3,929,887 105,889 2.6 %
Charges for Services:
General Government Services 13 67,200 49,300 61,991 60,462 12,691 25.7 %
Public Safety 13 520,300 395,678 453,345 396,978 57,666 14.6 %
Development Services Fees 14 680,600 501,600 794,082 933,627 292,482 58.3 %
Culture and Recreation 15 2,105,080 1,810,600 2,076,505 2,030,266 265,905 14.7 %
Fines and Forfeits 16 796,180 613,000 696,072 711,380 83,072 13.6 %
Fees/Charges/Fines sub-total 11,741,853$ 8,892,781$ 10,383,431$ 9,629,247$ 1,490,650$ 16.8 %
Interest and Other Earnings 17 35,200$ 26,000$ 81,161$ 32,834$ 55,161$ 212.2 %
Rents, Leases and Concessions 17 630,600 508,600 645,327 574,287 136,727 26.9 %
Contributions and Donations 17 32,000 25,100 26,883 31,947 1,783 7.1 %
Other Miscellaneous 17 157,800 117,900 228,553 159,007 110,653 93.9 %
Transfers In 220,926 139,000 139,112 76,000 112 0.1 %
Insurance Recoveries - Capital & Operating 25,000 18,743 58,094 131,404 39,352 210.0 %
Other Revenues sub-total 1,101,526$ 835,343$ 1,179,131$ 1,005,479$ 343,789$ 41.2 %
Total Operating Revenues 60,158,479$ 41,692,393$ 44,999,102$ 42,545,850$ 3,306,709$ 7.9 %
Operating Expenditures
Council & Mayor 1,085,833$ 810,500$ 802,274$ 662,611$ 8,226$ 1.0 %
Administration 1,350,722 1,013,400 831,249 746,156 182,151 18.0 %
Community & Human Services 1,329,547 819,200 577,608 644,041 241,592 29.5 %
Municipal Court & Probation 2,355,889 1,974,000 1,892,377 1,888,511 81,623 4.1 %
Human Resources 1,406,554 1,016,200 930,960 793,308 85,240 8.4 %
Finance 1,300,773 1,029,500 898,832 975,764 130,668 12.7 %
City Attorney 2,194,830 1,568,500 1,410,070 1,370,421 158,430 10.1 %
Community Development 4,731,841 3,507,500 3,014,962 2,868,071 492,538 14.0 %
Jail - SCORE 5,583,542 3,485,746 3,014,605 2,744,147 471,141 13.5 %
Police 23,794,252 17,687,100 17,490,649 16,388,842 196,451 1.1 %
Public Works 2,809,335 2,090,900 2,262,105 1,975,023 (171,205) (8.2)%
Parks, Arts & Recreation 11,584,205 8,768,200 8,627,328 8,320,497 140,872 1.6 %
Streets 3,466,563 2,389,100 2,256,727 2,044,555 132,373 5.5 %
Non-Departmental 5,539,627 3,862,413 2,783,240 4,145,992 1,079,173 27.9 %
Total Operating Expenditures 68,533,514$ 50,022,259$ 46,792,985$ 45,567,941$ 3,229,273$ 6.5 %
Page
Ref
2016 2016 YTD Budget vs. Actual
Favorable (Unfavorable)
Percentage
3
Executive Summary
This Executive Summary provides an overview of the City’s overall financial position for the
fiscal period ending September 30, 2016, reflecting financial data available as of October 28,
2016.
Through September 2016, General Fund revenues totaled $45.0 million compared to a budget
of $41.7 million, and were $2.5 million higher than the revenues collected during the same
period in 2015. Some notable variances to budget year-to-date include:
• Property tax collections through Q3-2016 totaled $9.9 million, which is 1.6% or
$157,000 above budget expectations and exceed collections in the same period last
year by $421,000, or 4.4%. The majority of property tax revenues are collected
during the months of April and October, coinciding with the due dates for the County
property tax billings. [page 5]
• General Fund retail sales tax revenues totaled $11.0 million, exceeding budget by
2.3% or $243,000, and exceeding 2015 collections by $186,000. The primary area
of significant increase in sales activity compared to 2015 was the services category.
[page 6] Collections in criminal justice sales tax revenues exceeded budget by
$166,000, or 12.9%.
• The Other Taxes category performed better than budget through Q3-2016. City
utility tax revenues exceeded budget by $283,000 or 10.8%, predominately due to
higher than budgeted capital system development revenues collected in the Water,
Sewer and Storm funds. Electric and natural gas tax revenues collected through
September exceeded budget by $222,000 and $78,000, respectively. These
revenues were somewhat offset by an unfavorable variance in telephone tax
collections of $89,000. [page 8] Year-to-date collections of leasehold excise taxes
were $168,000 favorable to budget due to an unbudgeted payment for the Emerald
Downs property which is tribally owned. Gambling excise tax revenues exceeded
budget by $127,000 primarily due to the timing of payments: the City’s main remitter
of card game taxes paid 6 months worth of taxes from 2015 in the current year.
• Building permit revenue through Q3-2016 exceeded budget by $493,000, and
already exceeds year-end budget expectations. This was predominately due to a
higher than anticipated volume of building permits as well as multiple large
commercial building permits issued. [page 10]
• Other licenses and permit revenues exceeded budget expectations by $201,000
primarily due to higher than anticipated revenue collected for plumbing permits. This
increase in revenues was a result of increased construction activity within the City.
One project in particular that contributed to this influx of revenue is the permitting for
the Promenade Apartment Project on 312th Street.
• Development services fees revenues collected year-to-date exceeded budget
expectations by $292,000, or 58.3%. This is predominately due to higher than
anticipated revenues collected for plan check services related to multiple single
family and commercial construction projects within the City. [page 14]
4
• Culture and recreation revenues exceeded year-to-date budget by $266,000, and
exceeded revenues collected the same period in 2015 by $46,000, or 2.3%.
Revenue sources that were significantly above budget include golf course and
special events revenues. [page 15]
• Year-to-date rents, leases and concession revenues were $137,000 or 26.9% above
budget, and were $71,000 more than collected the same period in 2015. This
favorable variance is attributed to higher than anticipated revenues collected for City
owned facility rentals and parking lot fees. [page 17]
General Fund expenditures through the third quarter of 2016 totaled $46.8 million compared to
a budget of $50.0 million, representing a 6.5% favorable variance to budget. All departments
operated within their allocated budget through Q3-2016 with the exception of the Public Works
department. This department is running over budget YTD through September by $171,000, or
8.2%. The variance to budget is seen in salary and benefit expenditures, as project engineers
are charging more of their time to general fund projects versus transportation and utility projects.
Year-to-date through September General Fund expenditures are $1.2 million, or 2.7%, higher
than the same period last year. Salary and benefit costs increased by $1.4 million, or 5.7%
compared to the same period in 2015. This year-over-year increase is due primarily to an
increase in Council approved FTEs (Full Time Equivalents) and increased costs associated with
healthcare and pension benefits. In addition, charges for services paid to Valley
Communications for 911 services have increased year-over-year by $406,000, or 20.0%.
These increased expenditures were somewhat offset by a reduction in intergovernmental
expenditures by $915,000 as compared to the same period in 2015.
$41.7 M
$50.0 M
$45.0 M
$46.8 M
$0.0 $10.0 $20.0 $30.0 $40.0 $50.0 $60.0
Revenues
Expenditures
$ Millions
General Fund
2016 Revenues vs. Expenditures 2016 YTD Actual
2016 YTD Budget
5
Revenues
The combined total of property, sales/use, utility, gambling, and admissions taxes provides
approximately 80% of all resources supporting general governmental activities. The following
section provides additional information on these sources.
Property Tax collections through Q3-2016 totaled $9,921,000, which is 1.6% or $157,000
above budget expectations. Property tax collections through Q3-2016 exceeded collections for
the same period last year by $421,000, or 4.4%. The majority of property tax revenues are
collected during the months of April and October, coinciding with the due dates for the County
property tax billings.
$0.0
$2.0
$4.0
$6.0
$8.0
$10.0
$12.0
$14.0
$16.0
$18.0
$20.0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsProperty Taxes
2016 Budget
2016 YTD Actual
2015 Actual
6
Sales tax collections year-to-date totaled $12.7 million, of which $11.0 million was distributed to
the General Fund and $1.7 million was distributed to the Local Street Fund (SOS) program.*
Through September 2016, total sales tax revenue distributions to the General Fund exceeded
budget expectations by $243,000, or 2.3%.
* Beginning in 2013, Local Street Fund (Fund 103) street repairs have been funded from sales taxes on
construction. The total amount transferred year-to-date through Q3-2016 was $1,651,379. The graphic
above presents sales taxes under the current policy.
$0.0
$2.0
$4.0
$6.0
$8.0
$10.0
$12.0
$14.0
$16.0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsSales & Use Tax
(Net of Revenue from Construction)
2016 Budget
2016 YTD Actual
2015 Actual
7
The following table breaks out the City’s base sales tax, excluding Criminal Justice, Annexation
Credit and Streamlined Sales Tax Mitigation, by major business sector.
Total sales tax revenue collected through Q3-2016 exceeded prior year collections by $223,000,
or 1.8%. The business sectors showing the largest increase in revenues compared to last year
were the service and construction industries.
Sales tax revenue on construction, which is transferred to the Local Street Fund (Fund 103) for
local street repair and maintenance, totaled $1,651,000, which is $48,000 higher than the same
period in 2015. Year-to-date sales tax on construction revenue exceeded budget expectations
by $498,000 or 43.1%.
2015 2016
Component Group Actual Actual Amount
Construction 1,602,935$ 1,651,379$ 48,443$ 3.0 %
Manufacturing 666,248 602,662 (63,586)(9.5)%
Transportation & Warehousing 46,931 65,962 19,031 40.5 %
Wholesale Trade 934,506 930,697 (3,808)(0.4)%
Automotive 2,772,680 2,746,266 (26,415)(1.0)%
Retail Trade 3,719,022 3,636,892 (82,130)(2.2)%
Services 2,651,561 3,018,436 366,875 13.8 %
Miscellaneous 51,225 15,603 (35,622)(69.5)%
YTD Total 12,445,109$ 12,667,897$ 222,788$ 1.8 %
Change from 2015
September 2016
Comparison of Sales Tax Collections by SIC Group
Percentage
$0.0
$0.2
$0.4
$0.6
$0.8
$1.0
$1.2
$1.4
$1.6
$1.8
$2.0
$2.2
$2.4
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsSales Tax on Construction Transfer
2016 Budget
2016 YTD Actual
2015 Actual
8
Utility Taxes consist of interfund taxes on City utilities (Water, Sewer, Storm and Solid Waste)
and taxes on external utilities (Electric, Natural Gas, Telephone and Solid Waste). Utility taxes
collected through Q3-2016 totaled $7.7 million and exceeded year-to-date budget by $508,000,
or 7.1%.
Favorable variances in City interfund utility tax, electric tax, natural gas tax and solid waste tax
revenues more than offset lower than expected collections from the telecommunication industry.
City interfund utility tax revenue was $283,000 or 10.8% higher than the year-to-date budget. A
significant portion of this favorability to budget is predominately due to higher than budgeted
capital system development revenues collected in the Water, Sewer and Storm funds.
$0.0
$2.0
$4.0
$6.0
$8.0
$10.0
$12.0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsUtility Tax
2016 Budget
2016 YTD Actual
2015 Actual
2015 2016 2016
Utility Tax Type YTD Actual YTD Budget YTD Actual Amount Amount
City Interfund Utility Taxes 2,712,038$ 2,618,300$ 2,901,188$ $ 189,150 7.0 % $ 282,888 10.8 %
Electric 2,393,107 2,511,200 2,733,513 340,406 14.2 %222,313 8.9 %
Natural Gas 878,683 754,800 833,093 (45,590) (5.2)%78,293 10.4 %
Telephone 1,271,170 1,233,600 1,144,823 (126,347) (9.9)%(88,777) (7.2)%
Solid Waste (external)84,177 79,470 92,985 8,808 10.5 %13,515 17.0 %
YTD Total 7,339,175$ 7,197,370$ 7,705,602$ $ 366,427 5.0 % $ 508,232 7.1 %
September 2016
Utility Tax by Type
2016 vs. 2015 Actual 2016 vs. Budget
Percentage Percentage
9
Cable TV Franchise Fees, which are collected quarterly, totaled $728,000 for Q3-2016. Year-
to-date revenues exceeded budget of $679,000 by $50,000, or 7.3%.
$0
$100
$200
$300
$400
$500
$600
$700
$800
$900
$1,000
1st Quarter 2nd Quarter 3rd Quarter 4th QuarterThousandsCable TV Franchise Fee
2016 Budget
2016 YTD Actual
2015 Actual
10
Licenses and Permits include business licenses, building permits, plumbing, electric and other
licenses and permit fees. Building permit fees and business licenses make up about 70% of the
annual budgeted revenue in this category.
Building permit revenues collected through September total $1.4 million and compare to a year-
to-date budget of $939,000. Building permits issued through September totaled 660, and
compare to 594 issued during the same period in 2015. Major projects contributing to revenues
this quarter include building permits for the Promenade Apartment Project, Lakeland Storage
and the Green River College Student Affairs building, as well as other projects and numerous
housing developments within the City – most notably Lakeland Hills Estates and Calla Crest.
$0.0
$0.2
$0.4
$0.6
$0.8
$1.0
$1.2
$1.4
$1.6
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsBuilding Permits
2016 Budget
2016 YTD Actual
2015 Actual
11
Business license revenues collected through September total $107,000 and compare to budget
of $128,000; these revenues were below budget by $21,000 largely due to the timing of
collections. The graphic below reflects the timing of payments by business owners, where the
majority of business license payments are typically collected during the first two months of the
year and the last month of the year.
$0
$20
$40
$60
$80
$100
$120
$140
$160
$180
$200
$220
$240
$260
$280
$300
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecThousandsBusiness Licenses
2016 Budget
2016 YTD Actual
2015 Actual
12
Intergovernmental revenues include grants (direct and indirect Federal, state and local),
compact revenue from the Muckleshoot Indian Tribe (MIT), intergovernmental, and state shared
revenues. Collections to date total $4.2 million and were $106,000, or 2.6% higher than budget.
Favorable variances in Criminal Justice High Crime revenues and Motor Vehicle Fuel Tax
revenues offset the reduced revenues received in Federal and State grant monies. Year-to-
date, grant revenues collected are under budget although this is primarily due to the timing of
when grant reimbursement is requested. Effective during the state’s 2016-2017 fiscal year
budget cycle, the City of Auburn qualified for the Criminal Justice High Crime revenue
distribution monies (distributions are made quarterly between July 1, 2016 through June 30,
2017). The eligibility requirements are based upon the City’s crime rate statistics – those Cities
whose crime rate exceeds 125% of the statewide average qualify for the distribution. The first
distribution was received in July and totaled $143,000.
2015 2016 2016
Re venue YTD Actual YTD Budget YTD Actual Amount Amount
Federal Grants 148,202$ 228,600$ 181,274$ $ 33,073 22.3 % $ (47,326)(20.7)%
State Grants 192,790 152,000 120,966 (71,824) (37.3)%(31,034) (20.4)%
Interlocal Grants 9,707 13,400 28,973 19,267 0.0 %15,573 116.2 %
Muckleshoot Casino Emerg.449,301 472,500 496,524 47,223 10.5 %24,024 5.1 %
Intergovernmental Service 14,423 10,195 17,304 2,882 20.0 %7,109 69.7 %
State Shared Revenues:
Streamlined Sales Tax 1,468,082 1,500,000 1,443,924 (24,158) (1.6)%(56,076) (3.7)%
Motor Vehicle Fuel Tax 784,333 788,100 823,044 38,712 4.9 %34,944 4.4 %
Criminal Justice - High Crime 96,509 48,000 142,628 46,118 47.8 %94,628 197.1 %
Criminal Justice - Population 14,843 13,500 15,480 637 4.3 %1,980 14.7 %
Criminal Justice - Special Prog.54,433 50,800 56,494 2,061 3.8 %5,694 11.2 %
Marijuana Enforcement 4,881 14,625 19,589 14,708 301.3 %4,964 33.9 %
State DUI 8,328 10,100 8,843 515 6.2 %(1,257) (12.4)%
Fire Insurance Tax 75,702 70,000 76,569 867 1.1 %6,569 9.4 %
Liquor Excise 117,851 226,958 259,959 142,107 120.6 %33,001 14.5 %
Liquor Profit 490,501 475,125 488,220 (2,282) (0.5)%13,095 2.8 %
Total State Shared:3,115,465 3,197,208 3,334,750 219,284 7.0 %137,542 4.3 %
YTD Total 3,929,887$ 4,073,903$ 4,179,792$ 249,905$ 6.4 %105,889$ 2.6 %
September 2016
Intergovernmental
2016 vs. 2015 Actual 2016 vs. Budget
% Change % Change
13
Charges for Services consist of general governmental services, public safety, development
service fees and cultural & recreation fees. Overall, charges for services collected through Q3-
2016 totaled $3.4 million and compare to a year-to-date budget of $2.8 million; they were 1.0%
or $35,000 less than revenues collected the during the same period in 2015.
General governmental revenues through Q3-2016 totaled $62,000 compared to a budget of
$49,000. Budget expectations for these revenues were revised from the prior year due to the
fact that the City no longer provides services to the City of Algona; therefore, the City does not
receive reimbursement for services. The majority of the favorable variance was due to
increased sales related to passport services, which are running $14,000 higher than year-to-
date budget and $8,000 higher than collections the same period in 2015.
Public safety revenues consist of revenues generated for Police Officer extra duty overtime,
where officers are contracted for services and reimbursement is made by the hiring contractor.
Effective June 2014, public safety revenue also includes reimbursement from the Muckleshoot
Indian Tribe (MIT) for a full-time dedicated Police Officer and associated expenditures.
Public safety revenues collected year-to-date totaled $453,000, compared to budget of
$396,000. Year-over-year revenues collected increased by $56,000 – which was a result of a
14.3% increase in billable hours for extra duty overtime, compared to the same period in 2015.
2015 2016 2016
Revenue YTD Actual YTD Budget YTD Actual Amount Amount
General Government 60,462$ 49,300$ 61,991$ $ 1,529 2.5 % $ 12,691 25.7 %
Public Safety 396,978 395,678 453,345 56,367 14.2 %57,666 14.6 %
Development Services 933,627 501,600 794,082 (139,545) (14.9)%292,482 58.3 %
Culture & Recreation 2,030,266 1,810,600 2,076,505 46,239 2.3 %265,905 14.7 %
YTD Total 3,421,332$ 2,757,178$ 3,385,923$ (35,409)$ (1.0)% $628,745 22.8 %
September 2016
Charges for Services by Type
2016 vs. 2015 Actual 2016 vs. Budget
Percentage Percentage
14
Development services fee collections, which primarily consist of plan check fees, totaled
$794,000 and already exceed annual budget expectations by $113,000. Year to date plan
check revenues, the largest component of development services fees, totaled $587,000 as
compared with an annual budget of $550,000 and a year-to-date budget of $405,000.
Revenues collected through Q3-2016 are from numerous commercial and residential projects
including the Multicare remodel project, Lakeland Storage, improvements at Boeing as well as
plans for Lakeland Hills Estates, Edgeview and Mountain View North housing developments.
$0.0
$0.2
$0.4
$0.6
$0.8
$1.0
$1.2
$1.4
$1.6
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsDevelopment Service Fees
2016 Budget
2016 YTD Actual
2015 Actual
15
Culture and recreation revenues totaled $2.1 million, exceeding year-to-date budget by
$266,000 and exceeding revenues collected the same period the year prior by $46,000, or
2.3%. Revenue sources with significant increases compared to 2015 include Special Events
revenue and revenue generated from the Cultural Arts Program.
$0.0
$0.2
$0.4
$0.6
$0.8
$1.0
$1.2
$1.4
$1.6
$1.8
$2.0
$2.2
$2.4
$2.6
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsCulture & Recreation
2016 Budget
2016 YTD Actual
2015 Actual
16
Fines & Penalties include traffic and parking infraction penalties, criminal fines (including
criminal traffic, criminal non traffic and other criminal offenses) as well as non-court fines such
as false alarm fines. Total revenues collected through Q3-2016 totaled $696,000, and compare
to a budget of $613,000. Significant sources of revenue increases compared to year-to-date
budget expectations include increase in false alarm fines and parking infractions.
2015 2016 2016
Month YTD Actual YTD Budget YTD Actual Amount Amount
Civil Penalties 8,823$ 11,900$ 21,179$ $ 12,355 140.0 % $ 9,279 78.0 %
Civil Infraction Penalties 384,758 349,800 358,003 (26,756) (7.0)%8,203 2.3 %
Redflex Photo Enforcement 1,859 0 13,550 11,691 628.9 %13,550 N/A %
Parking Infractions 105,877 83,500 100,942 (4,936) (4.7)%17,442 20.9 %
Criminal Traffic Misdemeanor 41,568 37,600 38,984 (2,584) (6.2)%1,384 3.7 %
Criminal Non-Traffic Fines 36,895 36,300 34,146 (2,750) (7.5)%(2,154) (5.9)%
Criminal Costs 42,706 33,500 46,044 3,338 7.8 %12,544 37.4 %
Non-Court Fines & Penalties 88,892 60,400 83,226 (5,666) (6.4)%22,826 37.8 %
YTD Total 711,380$ 613,000$ 696,072$ $ (15,308)(2.2)% $ 83,072 13.6 %
September 2016
Fines & Forfeits by Type
2016 vs. 2015 Actual 2016 vs. Budget
Percentage Percentage
$0.0
$0.1
$0.2
$0.3
$0.4
$0.5
$0.6
$0.7
$0.8
$0.9
$1.0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsFines & Penalties
2016 Budget
2016 YTD Actual
2015 Actual
17
Miscellaneous revenues primarily consist of investment earnings, income from facility rentals,
contributions & donations, and other miscellaneous income, which includes the quarterly
purchasing card (P-card) rebate monies. Total revenues collected in this category through Q3-
2016 totaled $982,000 and exceeded budget expectations by $304,000, or 44.9%. Primary
contributors to this favorable variance to budget include higher than anticipated revenues from
facilities rentals and golf cart rentals. In addition, P-card rebate revenues collected to date were
$67,000 higher than anticipated.
2015 2016 2016
Month YTD Actual YTD Budget YTD Actual Amount Amount
Interest & Investments 32,834$ 26,000$ 81,161$ 48,327$ 147.2 %55,161$ 212.2 %
Rents & Leases 574,287 508,600 645,327 71,040 12.4 %136,727 26.9 %
Contributions & Donations 31,947 25,100 26,883 (5,064)(15.9)%1,783 7.1 %
Other Miscellaneous Revenue 159,007 117,900 228,553 69,546 43.7 %110,653 93.9 %
YTD Total 798,076$ 677,600$ 981,925$ 183,849$ 23.0 %304,325$ 44.9 %
Miscellaneous Revenues by Type
September 2016
2016 vs. 2015 2016 vs. Budget
Percentage Percentage
18
Real Estate Excise Tax (REET) revenue is receipted into the Capital Improvement Projects
Fund and is used for governmental capital projects. REET revenues collected through Q3-2016
totaled $3.5 million and exceeded year-to-date budget by $1.2 million, or 56.2%. Year-to-date
revenues collected were $235,000 lower than the same period in 2015, which included the sale
of several large businesses in the City such as the Outlet Collection – Seattle and the Lakeland
Town Center. Real estate sales in the City of Auburn in Q3-2016 represent the sale of both
commercial and single family residences including the sale of numerous multifamily apartment
complexes, several warehouses and multiple large acre vacant lots.
2015 2016 2016
Month Actual Budget Actual Amount Amount
Jan 125,089$ 97,400$ 339,594$ 214,505$ 171.5 %242,194$ 248.7 %
Feb 115,287 128,700 286,943 171,656 148.9 %158,243 123.0 %
Mar 1,394,226 601,900 293,361 (1,100,865) (79.0)%(308,539) (51.3)%
Apr 423,394 244,000 574,925 151,531 35.8 %330,925 135.6 %
May 345,489 234,300 255,078 (90,410) (26.2)%20,778 8.9 %
Jun 436,101 267,400 329,081 (107,020) (24.5)%61,681 23.1 %
Jul 348,745 260,200 360,857 12,112 3.5 %100,657 38.7 %
Aug 269,454 212,100 673,012 403,557 149.8 %460,912 217.3 %
Sep 228,140 163,500 338,340 110,200 48.3 %174,840 106.9 %
Oct
Nov
Dec
YTD Total 3,685,925$ 2,209,500$ 3,451,191$ (234,734)$ (6.4)%1,241,691$ 56.2 %
2016 vs. 2015 2016 vs. Budget
Percentage
Real Estate Excise Tax Revenues
September 2016
Percentage
$0.0
$0.5
$1.0
$1.5
$2.0
$2.5
$3.0
$3.5
$4.0
$4.5
$5.0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsReal Estate Excise Tax
2016 Budget
2016 YTD Actual
2015 Actual
19
Pet Licensing
Year-to-date, 3,616 pet licenses were sold, resulting in $99,925 in revenue. For the same
period in 2015, 3,956 licenses were sold, resulting in $113,335 in revenue.
0
500
1,000
1,500
2,000
2,500
$0
$2
$4
$6
$8
$10
$12
$14
$16
$18
JanFebMarAprMayJunJulAugSepOctNovDecNumber of Licenses IssuedLicense Revenue( thousands )Pet Licensing Revenues vs Licenses Sold
2016 vs 2015
2015 License Revenue
2016 License Revenue
2015 Licenses Issued
2016 Licenses Issued
0
1,000
2,000
3,000
4,000
5,000
6,000
$0
$20
$40
$60
$80
$100
$120
$140
JanFebMarAprMayJunJulAugSepOctNovDecNumber of Licenses IssuedLicense Revenue( thousands )Cumulative Pet Licensing Revenue & Licenses Issued
2016 vs 2015
2016 License Revenue
2016 Licenses Issued
2015 Licenses Issued
20
Street Funds
This section provides financial overview of the City’s three street funds for the fiscal period
ending September 30, 2016. The City’s three street funds are: the Arterial Street Fund (Fund
102), the Local Street Fund (Fund 103), and the Arterial Street Preservation Fund (Fund 105).
Capital project expenditures are budgeted primarily based on the collection/disbursement
average for the same period of the prior two years.
Fund 102 – Arterial Street Fund
The Arterial Street Fund is a Special Revenue Fund that is funded by transportation grants,
traffic impact fees, a portion of the City’s gas tax receipts, Public Works Trust Fund loans,
developer contributions, and other sources. There are over 40 separate street projects
budgeted in this fund in 2016. Some of these projects include the South 272nd /South 277th
Street Corridor Improvement Project, the West Main Street Multimodal Corridor and ITS
Improvement Project, and the AWS Corridor Safety Improvement Project (Muckleshoot Plaza to
Dogwood).
Through September 2016, revenues collected totaled $2.3 million and compare to collections of
$2.4 million for the same period in 2015. Expenditures through September totaled $3.0 million
and compare to $3.9 million spent the same period last year. Expenditures for the projects
South 272nd/South 277th Street Corridor Improvements and West Main Street Multimodal
Corridor and ITS Improvements, which constitute nearly 60% of budgeted capital expenditures,
are below budget due to delays in project start times and timing lag between work performance
and the City’s reimbursement of costs incurred.
Fund 102 - Arterial Street 2015
Summary of Sources and Uses Annual
Report Period: September 2016 Budget YTD Budget YTD Actual YTD Actual Am ount
Revenues
Federal Grants 7,270,016$ 3,185,116$ 493,143$ 975,716$ (2,691,973)$ (84.5)%
State Grants 4,292,973 1,912,095 198,554 319,214 (1,713,541) (89.6)%
Motor Vehicle Fuel and Multimodal Taxes 530,000 397,500 432,411 363,669 34,911 8.8 %
Developer Contributions 1,601,145 - 188,781 - 188,781
Miscellaneous Revenue 373,805 280,354 64,862 82,953 (215,492) (76.9)%
Other Governmental Agencies - - - 61,520 -
Public Works Trust Fund Loans - - - - -
Operating Transfer In 3,882,586 - 943,207 553,723 943,207
Investment Income 2,000 1,500 5,478 2,159 3,978 265.2 %
Total Revenues 17,952,525$ 5,776,564$ 2,326,435$ 2,358,953$ (3,450,129)$ (59.7)%
Expenditures
Salary and Benefits 839,323$ 609,574$ 355,490$ 299,722$ 254,084$ 41.7 %
Capital Outlay 17,428,903 9,460,179 2,216,277 3,178,951 7,243,903 76.6 %
Subtotal - Capital Project Expenditures 18,268,226 10,069,753 2,571,766 3,478,673 7,497,987 74.5 %
Services and Charges 245,000 183,750 187,898 146,492 (4,148) (2.3)%
Interfund Payments for Services 74,550 55,913 55,917 53,361 (5) (0.0)%
Debt Service Principal and Interest 217,862 - 210,205 218,761 (210,205)
Operating Transfer Out - - - - -
Total Expenditures 18,805,638$ 10,309,416$ 3,025,786$ 3,897,287$ 7,283,630$ 70.7 %
Net Change in Fund Balance (853,113)$ (4,532,852)$ (699,351)$ (1,538,334)$ 3,833,501$ (84.6)%
Beg. Fund Balance, September 2016 2,405,821$
Net Change in Fund Balance, September 2016 (699,351)
Ending Fund Balance, September 2016 1,706,470$
2016 Budgeted Ending Fund Balance 1,552,709$
2016 2016 YTD Budget vs. Actual
Favorable (Unfavorable)
Percentage
21
This table presents the status of the projects with the most significant impact on this fund:
Notes:
• S 277th St. Corridor Improvements: Environmental requirements causing delays. Roughly 70% of project
($4.2 million) is scheduled for completion in 2017.
• W. Main St. Multimodal: Roughly 80% of project ($3.5 million) is projected to be completed during 2017.
• AWS Corridor Safety Improvements: Project slowed during ROW acquisition. Balance of $2.4 million will be
completed in 2017.
$0.0
$2.0
$4.0
$6.0
$8.0
$10.0
$12.0
$14.0
$16.0
$18.0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsFund 102 -Capital Project Expenditures
2016 YTD Budget
2016 YTD Actual
2015 YTD Actual
2016 YE Budget $18.3M
2015 YE Actual
$6.4M
2016 YTD Actual
$2.6M
2015 YTD Actual
$3.5M
*Data consists of capital outlays, salaries and benefits.
Name Annual Budget YTD Actual Variance
S. 277th St Corridor Improvements $ 5.99 M $1.10 M $ 4.89 M
W. Main St Multimodal Corridor & ITS Imp $ 4.38 M $0.37 M $ 4.01 M
AWS Corridor Safety Imp. -- Muckleshoot Pl.$ 2.58 M $0.18 M $ 2.40 M
All Other Projects $ 5.32 M $0.92 M $ 4.40 M
Total $18.27 M $2.57 M $15.70 M
Fund 102 - Arterial Street
Capital Projects Status
22
Fund 103 – Local Street Fund
The Local Street Fund is a Special Revenue Fund where the revenues from sales taxes
on construction are used for local street repairs. Through September 2016 the revenues
in this fund exceeded budget expectations by $504,000, or 38.6%, due to higher than
anticipated sales tax revenues from local construction projects. Expenditures through
September totaled $1.1 million and compare to a year to date budget of $1.2 million.
The majority of expenditures from the Fund’s largest project, 2016 Local Street
Pavement Reconstruction Project, are anticipated to occur in Q4-2016.
Fund 103 - Local Street Fund 2015
Summary of Sources and Uses Annual
Report Period: September 2016 Budget YTD Budget YTD Actual YTD Actual Amount
Revenues
Sales Tax on Construction 1,610,000$ 1,153,700$ 1,651,379$ 1,602,935$ 497,679$ 43.1 %
Operating Transfer In 150,000 150,000 150,000 150,000 - -
Interest Earnings 2,500 1,875 8,501 2,667 6,626 353.4 %
Total Revenues 1,762,500$ 1,305,575$ 1,809,880$ 1,755,602$ 504,305$ 38.6 %
Expenditures
Salary and Benefits 175,090$ 131,317$ 89,919$ 78,943$ 41,398$ 31.5 %
Services and Charges 300 225 532 416 (307) (136.5)%
Capital Outlay 2,676,768 1,041,860 953,978 1,107,349 87,882 8.4 %
Interfund Payments for Services 12,240 9,180 9,180 9,360 - -
Operating Transfer Out - - - - - -
Total Expenditures 2,864,398$ 1,182,582$ 1,053,610$ 1,196,068$ 128,973$ 10.9 %
Net Change in Fund Balance (1,101,898)$ 122,993$ 756,270$ 559,534$ 633,278$ 514.9 %
Beg. Fund Balance, September 2016 2,080,690$
Net Change in Fund Balance, September 2016 756,270
Ending Fund Balance, September 2016 2,836,960$
2016 Budgeted Ending Fund Balance 978,792$
2016 2016 YTD Budget vs. Actual
Favorable (Unfavorable)
Percentage
23
This table presents the status of the projects with the most significant impact on this fund:
Notes:
• 2016 Local Street Pavement Reconstruction: Scheduled for substantial completion November 2016.
• 2017 Local Street Reconstruction & Preservation: Still in design phase, to be carried forward to 2017.
$0.0
$0.5
$1.0
$1.5
$2.0
$2.5
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsFund 103 -Capital Outlay
2016 YTD Budget
2016 YTD Actual
2015 YTD Actual
2016 Projected Actual
2016 YE Budget
$2.7M
2016 YE Projected
Actual
$2.1M
2016 YTD Actual
$0.95M
2015 YE Actual
$2.3M
Name Annual Budget YTD Actual Variance
2016 Local Street Pavement Reconst.$2.36 M $0.93 M $1.42 M
2017 Local St. Reconst. & Preservation $0.30 M $0.00 M $0.30 M
All Other Projects $0.02 M $0.02 M $0.00 M
Total $2.68 M $0.95 M $1.72 M
Fund 103 - Local Street
Capital Projects Status
24
Fund 105 – Arterial Street Preservation Fund
The Arterial Street Preservation Fund is a Special Revenue Fund which is primarily funded by a
1.0% utility tax that was adopted by Council in 2008. These utility tax revenues are restricted
for arterial street repair and preservation projects. Some projects budgeted within the Arterial
Street Preservation Fund in 2016 include Pavement Patching and Overlay, the Annual Arterial
and Collector Crack Seal Project, the Auburn Way North Preservation Project and the B Street
NW Reconstruction Project.
Through September 2016 revenues totaled $1.6 million and compare to a budget of $2.1 million.
The difference is mostly due to the Auburn Way North Preservation project being pushed back
to 2017, resulting in $880,000 in budgeted federal grant funding being delayed.
Expenditures through September totaled $862,000, which is approximately 63% of budgeted
expenditures for the period. Actuals are lower than budget primarily due to the Fund’s main
project, Auburn Way North Preservation, being repackaged and sent to bid a second time after
the first round of bidding produced higher-than-expected costs. This project is anticipated to be
rebid in February 2017, affecting the Fund’s 2016 year-end projection significantly. In addition,
the Fund’s next-largest project, B Street NW Reconstruction, remains in the design phase due
to prioritizing grant-funded projects on the verge of expiration. Construction on this project is
anticipated to start in March 2017.
Fund 105 - Arterial St. Presv. 2015
Summary of Sources and Uses Annual
Report Period: September 2016 Budget YTD Budget YTD Actual YTD Actual Amount
Revenues
City Utility Tax 589,000$ 437,900$ 483,531$ 452,006$ 45,631$ 10.4 %
Electric Utility Tax 660,500 502,900 546,703 478,621 43,803 8.7 %
Natural Gas Utility Tax 170,400 151,500 166,619 175,737 15,119 10.0 %
Cable TV Tax 181,300 135,700 147,046 139,192 11,346 8.4 %
Telephone Utility Tax 324,000 251,000 228,965 254,234 (22,035) (8.8)%
Garbage Utility Tax (External Haulers)17,700 13,275 15,498 14,030 2,223 16.7 %
Grants 1,053,626 517,881 843 35,301 (517,038) (99.8)%
Developer Mitigation Fees - - - - - -
Operating Transfer In 150,000 112,500 30,932 612,340 (81,568) -
Interest Earnings 1,500 1,125 6,673 2,719 5,548 493.2 %
Total Revenues 3,148,026$ 2,123,781$ 1,626,809$ 2,164,180$ (496,972)$ (23.4)%
Expenditures
Salary and Benefits 124,095$ 93,072$ 206,327$ 162,060$ (113,256)$ (121.7)%
Capital Outlay 4,258,226 2,093,016 448,274 2,850,174 1,644,742 78.6 %
Subtotal - Capital Project Expenditures 4,382,321 2,186,088 654,601 3,012,234 1,531,486 70.1 %
Supplies - - - - - -
Services and Charges 212,500 159,375 37,525 - 121,850 76.5 %
Operating Transfer Out 401,750 301,313 170,276 8,411 131,037 43.5 %
Total Expenditures 4,996,571$ 2,646,775$ 862,402$ 3,020,645$ 1,784,373$ 67.4 %
Net Change in Fund Balance (1,848,545)$ (522,994)$ 764,407$ (856,465)$ 1,287,401$ (246.2)%
Beg. Fund Balance, September 2016 1,943,865$
Net Change in Fund Balance, Sept. 2016 764,407
Ending Fund Balance, September 2016 2,708,272$
2016 Budgeted Ending Fund Balance 95,319$
2016 2016 YTD Budget vs. Actual
Favorable (Unfavorable)
Percentage
25
This table presents the status of the projects with the most significant impact on the fund:
Notes:
• Auburn Way N Preservation: This project to be re-bid in Spring 2017 after unsatisfactory 2016 bids.
• B Street NW Reconstruction: Project still in design due to prioritizing grant-funded projects that were
expiring.
$0.0
$0.5
$1.0
$1.5
$2.0
$2.5
$3.0
$3.5
$4.0
$4.5
$5.0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsFund 105 -Capital Projects Expenditures
2016 YTD Budget
2016 YTD Actual
2015 YTD Actual
2016 Projected Actual
2016 YE Budget
$4.4M
2015 YE Actual
$4.0M
2016 YTD Actual
$0.65M 2016 YE Projected Actual
$0.79M
*Data consists of capital outlays, salaries and benefits.
Name Annual Budget YTD Actual Variance
Auburn Way North Preservation $1.81 M $0.08 M $1.73 M
B Street NW Reconstruction $1.43 M $0.05 M $1.38 M
All Other Projects $1.14 M $0.53 M $0.62 M
Total $4.38 M $0.66 M $3.73 M
Capital Projects Status
Fund 105 - Arterial Street Preservation
26
Fund 124 – Mitigation Fees
The Mitigation Fees Fund is a Special Revenue Fund funded from revenue from new
development, which is assessed at the time applications are received for development activity.
These funds are used to mitigate costs associated with City growth. Through Q3-2016,
revenues were significantly above budget expectations, at 255.1% of the annual budgeted
amount. This is due to higher-than-expected transportation, parks and fire impact fee revenues
in the month of July, driven by the construction of The Promenade, a 298-unit apartment
complex in Lea Hill. Another revenue spike is anticipated in Q4-2016 due to the construction of
a 600-unit mixed-use senior and multifamily housing development comprising The Villas and
The Reserve. Expenditures year-to-date are well below budget due to delays in construction
projects funded by these revenues.
Fund 124 - Mitigation Fees
Summary of Sources and Uses
Report Period Through:Ending Ending
September 2016 Fund Balance Fund Balance
Transportation Impact Fees 1,695,367$ 767,294$ 4,610,158$ 800,000$ 3,006,075$ 1,476,010$
Transportation Migitation Fees -$ 4,020$ 253,690$ -$ 173,144$ 84,566$
Fire Impact Fees 160,728$ -$ 474,948$ 100,000$ 50,000$ 364,220$
Fire Mitigation Fees -$ -$ 82$ -$ -$ 82$
Parks Impact Fees 1,544,598$ 70,661$ 2,597,150$ 75,000$ 300,000$ 898,213$
Parks Mitigation Fees -$ -$ 330,319$ -$ -$ 330,319$
School Impact Admin Fees 16,744$ 40,112$ 54,747$ 15,000$ 61,626$ 31,489$
Wetland Mitigation Fees -$ -$ 68,626$ -$ -$ 68,626$
Interest and Investment Income 21,849$ -$ 21,849$ 4,890$ -$ 4,890$
Fees in Lieu of Improvements 122,525$ -$ 122,525$ -$ -$ -$
Operating Transfers -$ -$ -$ 400,000$ -$ 400,000$
Total 3,561,810$ 882,087$ 8,534,092$ 1,394,890$ 3,590,845$ 3,658,415$
Beginning Fund Balance, September 2016 5,854,370$
Net Change in Fund Balance, September 2016 2,679,722$
Ending Fund Balance, September 2016 8,534,092$
2016 Budgeted Ending Fund Balance 3,658,415$
YTD ACTUALS BUDGET
Revenues Expenditures Revenues Expenditures
27
Proprietary Funds
Detailed income and expense statements for Enterprise and Internal Service funds can be
found in the Appendices at the end of this report. The format changed in Q1-2016 and, in lieu of
a working capital statement, there are now operating and capital fund reports for most of these
funds showing budget, actual and variance. The operating fund houses all the operating costs
along with debt service and financing obligations. The capital fund shows costs associated with
capital acquisition and construction. Both the operating fund and the capital fund have a
working capital balance. This approach isolates those funds available for capital and cash flow
needs for daily operations, and project managers will know exactly how much working capital is
available for current and planned projects.
Budget Amendment #6, adopted July 2016, moved working capital from the operating funds to
the capital funds along with all the other beginning fund balance adjustments. System
development revenues previously credited to the operating funds are now directed to the
corresponding capital funds.
At the end of the third quarter, the Water Utility had operating income of $3.3 million as
compared with operating income of $3.2 million for the same period in 2015. Water sales
through Q3-2016 totaled 2.71 million hundred cubic feet (ccf), compared to 2.66 million ccf
during the same period in 2015, representing a 2.1% increase. Year-to-date revenues are
10.0% above budget but this is expected to come closer to budget in Q4-2016, as the highest
revenues are historically generated from August through October.
0
100,000
200,000
300,000
400,000
500,000
600,000
700,000
800,000
900,000
1,000,000
$0
$200
$400
$600
$800
$1,000
$1,200
$1,400
$1,600
$1,800
$2,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec CCFThousandsWater Revenues vs Water Sold
2016 vs 2015
2015 Water Sales ($)
2016 Water Sales ($)
2015 Water Sold (ccf)
2016 Water Sold (ccf)
28
The Sewer Utility ended the quarter with net operating income of $1.5 million, which is
$124,000 higher than the same period in 2015.
The Sewer-Metro Utility ended the quarter with a year-to-date net operating income of
$236,000, as compared with $59,000 through Q3-2015.
$0
$100
$200
$300
$400
$500
$600
$700
$800
$900
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecThousandsSewer
2016 Budget
Revenue
2016 Actual
Revenue
2016 Actual
Expenses
2015 Actual
Revenue
2016 Budget vs. Actual
Monthly Revenues and Expenditures
29
The Stormwater Utility ended Q3-2016 with $2.1 million in operating income, which is about
$1.3 million below the same period in 2015. This is due in large part to the receipt of grant
revenues from the Department of Ecology in Q2 and Q3-2015.
$0
$200
$400
$600
$800
$1,000
$1,200
$1,400
$1,600
$1,800
$2,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecThousandsStorm Drainage
2016 Budget
Revenue
2016 Actual
Revenue
2016 Actual
Expenses
2015 Actual
Revenue
2016 Budget vs. Actual
Monthly Revenues and Expenditures
Dept. of Ecology
Revenues
30
The Cemetery Fund ended the second quarter with a year-to-date operating income of
$167,000 as compared with operating income of $102,000 for the same period in 2015.
Operating expenditures totaled $857,000 in through Q3-2016, compared to $838,000 in the
same period last year. The increase is mainly a result of higher cost of supplies due to
increased inventory costs associated with higher demand.
Internal Service Funds
Operating expenditures within the Insurance Fund represent the premium cost pool that will be
allocated monthly to other City funds over the course of 2016. As a result, this balance will
gradually diminish each month throughout the year.
No significant variances are reported in the Worker’s Compensation, Facilities, Innovation &
Technology, or Equipment Rental Funds.
Contact Information
This report is prepared by the Finance Department. Additional financial information can also be
viewed at our website: http://www.auburnwa.gov/. For any questions about this report please
contact Shelley Coleman at scoleman@auburnwa.gov.
$0
$200
$400
$600
$800
$1,000
$1,200
$1,400
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecThousandsCemetery
2016 YTD Budget
Revenue
2016 YTD Actual
Revenue
2015 YTD Actual
Revenue
2016 YTD Actual
Expenses
Cumulative Revenues and Expenditures
2016 Budget vs. Actual
31
Investment Purchase Purchase Maturity Yield to
Type Date Price Date Maturity
State Investment Pool Various 113,513,552$ Various 0.52%
KeyBank Money Market Various 5,263,806 Various 0.02%
FNMA 3/11/2016 998,844 2/22/2019 1.20%
LAKUTL 9/25/2013 235,919 11/1/2017 1.90%
Total Cash & Investments 120,012,120$ 0.503%
Investment Mix % of Total
State Investment Pool 94.6%Current 6-month treasury rate 0.47%
KeyBank Money Market 4.4%Current State Pool rate 0.52%
US Treasury 0.0%KeyBank Money Market 0.02%
FNMA 0.8%
LAKUTL 0.2%
100.0%
City of Auburn
Investment Portfolio Summary
September 30, 2016
Summary
32
SALES TAX SUMMARY
SEPTEMBER 2016 SALES TAX DISTRIBUTIONS (FOR JULY 2016 RETAIL ACTIVITY)
2015 Annual Total 2015 YTD 2016 YTD YTD 2015 Annual Total 2015 YTD 2016 YTD YTD
NAICS CONSTRUCTION (Nov '14-Oct '15)(Nov '14-Jul '15)(Nov '15-Jul '16)% Diff NAICS AUTOMOTIVE (Nov '14-Oct '15)(Nov '14-Jul '15)(Nov '15-Jul '16)% Diff
236 Construction of Buildings 1,229,166 863,806 798,884 -7.5%441 Motor Vehicle and Parts Dealer 3,465,199 2,587,136 2,563,887 -0.9%
237 Heavy and Civil Construction 252,280 164,662 229,621 39.4%447 Gasoline Stations 241,336 185,544 182,379 -1.7%
238 Specialty Trade Contractors 815,416 574,468 622,874 8.4%TOTAL AUTOMOTIVE 3,706,535 2,772,680 2,746,266 -1.0%
TOTAL CONSTRUCTION 2,296,863 1,602,935 1,651,379 3.0%Overall Change from Previous Year -26,415
Overall Change from Previous Year 48,443
2015 Annual Total 2015 YTD 2016 YTD YTD
2015 Annual Total 2015 YTD 2016 YTD YTD NAICS RETAIL TRADE (Nov '14-Oct '15)(Nov '14-Jul '15)(Nov '15-Jul '16)% Diff
NAICS MANUFACTURING (Nov '14-Oct '15)(Nov '14-Jul '15)(Nov '15-Jul '16)% Diff 442 Furniture and Home Furnishings 253,871 189,327 135,870 -28.2%
311 Food Manufacturing 3,973 2,181 2,485 13.9%443 Electronics and Appliances 295,127 217,286 175,342 -19.3%
312 Beverage and Tobacco Products 9,323 7,080 7,153 1.0%444 Building Material and Garden 589,676 439,564 434,761 -1.1%
313 Textile Mills 372 247 219 -11.2%445 Food and Beverage Stores 368,411 274,668 298,973 d 8.8%
314 Textile Product Mills 3,039 2,029 2,157 6.3%446 Health and Personal Care Store 220,603 166,104 202,426 21.9%
315 Apparel Manufacturing 116 105 146 38.9%448 Clothing and Accessories 1,079,933 793,985 835,833 5.3%
316 Leather and Allied Products 8 2 32 1650.0%451 Sporting Goods, Hobby, Books 220,168 164,796 189,123 14.8%
321 Wood Product Manufacturing 65,039 52,040 45,860 -11.9%452 General Merchandise Stores 988,004 742,535 c 770,897 3.8%
322 Paper Manufacturing 7,762 4,547 5,475 20.4%453 Miscellaneous Store Retailers 578,836 451,623 356,739 -21.0%
323 Printing and Related Support 59,750 45,614 40,523 -11.2%454 Nonstore Retailers 394,268 279,134 236,928 -15.1%
324 Petroleum and Coal Products 5,394 4,187 1,902 -54.6%TOTAL RETAIL TRADE 4,988,898 3,719,022 3,636,892 -2.2%
325 Chemical Manufacturing 5,508 4,178 6,034 44.4%Overall Change from Previous Year -82,130
326 Plastics and Rubber Products 9,081 7,083 6,439 -9.1%
327 Nonmetallic Mineral Products 14,514 8,429 12,750 51.3%
331 Primary Metal Manufacturing 1,692 1,430 295 -79.4%2015 Annual Total 2015 YTD 2016 YTD YTD
332 Fabricated Metal Product Manuf 37,819 22,553 23,415 3.8%NAICS SERVICES (Nov '14-Oct '15)(Nov '14-Jul '15)(Nov '15-Jul '16)% Diff
333 Machinery Manufacturing 21,693 18,010 12,686 -29.6%51*Information 526,003 380,736 b 461,338 21.2%
334 Computer and Electronic Product 8,388 6,352 8,508 33.9%52*Finance and Insurance 95,471 71,027 83,165 17.1%
335 Electric Equipment, Appliances 827 466 350 -24.8%53*Real Estate, Rental, Leasing 334,095 245,591 269,926 9.9%
336 Transportation Equipment Man 536,513 427,859 381,562 -10.8%541 Professional, Scientific, Tech 195,478 146,216 175,612 20.1%
337 Furniture and Related Products 20,389 14,397 13,358 -7.2%551 Company Management 9,230 9,225 307 -96.7%
339 Miscellaneous Manufacturing 50,358 37,458 31,315 -16.4%56*Admin. Supp., Remed Svcs 373,781 252,765 256,106 1.3%
TOTAL MANUFACTURING 861,555 666,248 602,662 -9.5%611 Educational Services 60,189 43,751 a 36,214 -17.2%
Overall Change from Previous Year -63,586 62*Health Care Social Assistance 81,684 63,869 75,015 17.5%
71*Arts and Entertainment 207,717 131,423 133,281 1.4%
72*Accommodation and Food Svcs 1,159,033 852,841 895,831 5.0%
2015 Annual Total 2015 YTD 2016 YTD YTD 81*Other Services 475,505 354,970 519,028 46.2%
NAICS TRANSPORTATION AND WAREHOUSING (Nov '14-Oct '15)(Nov '14-Jul '15)(Nov '15-Jul '16)% Diff 92*Public Administration 127,364 99,148 112,614 13.6%
481 Air Transportation 0 0 1 N/A TOTAL SERVICES 3,645,551 2,651,561 3,018,436 13.8%
482 Rail Transportation 10,457 7,211 9,679 34.2%Overall Change from Previous Year 366,875
484 Truck Transportation 7,590 5,900 2,756 -53.3%
485 Transit and Ground Passengers 209 155 67 -56.7%
488 Transportation Support 36,669 25,606 41,861 63.5%2015 Annual Total 2015 YTD 2016 YTD YTD
491 Postal Service 259 196 196 0.1%NAICS MISCELLANEOUS (Nov '14-Oct '15)(Nov '14-Jul '15)(Nov '15-Jul '16)% Diff
492 Couriers and Messengers 1 1 192 16179.7%000 Unknown 0 0 0 N/A
493 Warehousing and Storage 10,487 7,861 11,210 42.6%111-115 Agriculture, Forestry, Fishing 4,510 3,103 4,277 37.8%
TOTAL TRANSPORTATION 65,671 46,931 65,962 40.5%211-221 Mining & Utilities 27,456 20,228 21,424 5.9%
Overall Change from Previous Year 19,031 999 Unclassifiable Establishments 39,581 27,894 -10,098 e -136.2%
TOTAL SERVICES 71,548 51,225 15,603 -69.5%
Overall Change from Previous Year -35,622
2015 Annual Total 2015 YTD 2016 YTD YTD
NAICS WHOLESALE TRADE (Nov '14-Oct '15)(Nov '14-Jul '15)(Nov '15-Jul '16)% Diff
423 Wholesale Trade, Durable Goods 1,010,730 777,233 718,538 -7.6%GRAND TOTAL 16,865,540 12,445,109 12,667,897
424 Wholesale Trade, Nondurable 216,303 155,789 210,485 35.1%Overall Change from Previous Year 222,788 1.8%
425 Wholesale Electronic Markets 1,885 1,484 1,675 12.8%
TOTAL WHOLESALE 1,228,919 934,506 930,697 -0.4%
Overall Change from Previous Year -3,808
Includes Adjustments in excess of +/- $10,000.
a. WA State Dept of Revenue audit adjustment to sales tax returns for period of February 2015 (adjustment: $11,845).
b. WA State Dept of Revenue audit adjustment to sales tax returns for period of March 2015 (adjustment: -$17,839).
c. WA State Dept of Revenue audit adjustment to sales tax returns for period of April 2015 (adjustment: -$43,875).
d. WA State Dept of Revenue audit adjustment to sales tax returns for period of November 2015 (adjustment: $10,572).
e. WA State Dept of Revenue audit adjustment to sales tax returns for period of April 2016 (adjustment: - $52,898).
10/03/16
Prepared by Auburn Finance Department 33
Budget
YTD
Actual Variance Budget
YTD
Actual Variance Budget
YTD
Actual Variance Budget
YTD
Actual Variance
430 430 431 431 433 433 432 432
OPERATING FUND:460 460 461 461 462 462
OPERATING REVENUES
Charges For Service 13,698,782 10,713,435 (2,985,347) 7,847,883 6,238,777 (1,609,106) 16,332,687 12,557,592 (3,775,095) 9,151,487 7,129,978 (2,021,509)
Grants - - - 50,000 - (50,000)
Interest Earnings 7,735 31,342 23,607 10,697 42,122 31,425 700 3,434 2,734 13,865 45,862 31,997
Interfund Charges For Service - - - -
Sewer Metro Service Revenue - - - -
Operating Transfers - - -
Rents, Leases, Concessions, & Other 206,854 430,744 223,890 70,128 46,417 (23,711) - - - 58,674 60,175 1,501
TOTAL OPERATING REVENUES 13,913,371 11,175,521 (2,737,850) 7,928,708 6,327,317 (1,601,391) 16,333,387 12,561,026 (3,772,361) 9,274,026 7,236,015 (2,038,011)
OPERATING EXPENSES
Salaries & Wages 2,587,276 1,878,687 708,589 1,758,478 1,249,369 509,109 - - - 2,397,119 1,911,568 485,551
Benefits 1,251,312 860,576 390,736 871,146 572,282 298,865 - - - 1,224,350 867,463 356,888
Supplies 321,994 207,146 114,848 130,500 70,650 59,850 - - - 94,300 56,657 37,643
Other Service Charges 5,185,175 3,259,070 1,926,105 2,723,275 1,848,723 874,552 - - - 1,670,215 954,776 715,439
Capital - 739 (739) - - - - - - - - -
Intergovernmental Services 133,960 74,335 59,625 172,008 99,870 72,138 415,980 313,682 102,298
Waste Management Payments
Sewer Metro Services 16,317,200 12,325,136 3,992,064
Debt Service Interest 1,006,253 461,036 545,217 277,082 149,443 127,639 - - - 360,525 186,317 174,208
Interfund Loan Repayment - - -
Interfund Operating Rentals & Supplies 1,276,967 957,760 319,207 952,338 714,543 237,795 - - - 1,312,518 985,939 326,579
TOTAL OPERATING EXPENSES 11,762,936 7,699,349 4,063,586 6,884,827 4,704,879 2,179,948 16,317,200 12,325,136 3,992,064 7,475,007 5,276,402 2,198,605
OPERATING REVNUES LESS EXPENSES
BEFORE DEPRECIATION (*)2,150,435 3,476,172 1,325,737 1,043,881 1,622,438 578,557 16,187 235,889 219,702 1,799,019 1,959,613 160,594
BEGINNING WORKING CAPITAL - January 1, 2016 2,488,639 2,488,639 - 4,262,859 4,262,859 - 2,358,518 2,358,518 - 2,691,382 2,691,382 -
ENDING WORKING CAPITAL - September 30, 2016 4,639,074 5,964,811 1,325,737 5,306,740 5,885,297 578,557 2,374,705 2,594,407 219,702 4,490,401 4,650,995 160,594
NET CHANGE IN WORKING CAPITAL (see Note)2,150,435 3,476,172 1,325,737 1,043,881 1,622,438 578,557 16,187 235,889 219,702 1,799,019 1,959,613 160,594
CAPITAL FUND:
CAPITAL REVENUES
Interest Revenue 1,265 - (1,265) 2,303 - (2,303) 2,135 - (2,135)
Grants 300,000 -
Contributions - - - - - - 7,806 - (7,806)
Other Non-Operating Revenue - - - - - - - - -
Gain (Loss) On Sale Of Fixed Assets - - - - - - - - -
Increase In Contributions - System Development 350,000 1,160,029 810,029 240,000 1,002,061 762,061 350,000 541,018 191,018
Increase In Contributions - Area Assessments - - - - - - - - -
Increase In Contributions - Other - - - - - - - - -
Increase In Contributions - FAA - - - - - - - - -
Proceeds of Debt Activity 4,070,037 820,037 (3,250,000) - - - - - -
Operating Transfers In - - - - - - - - -
Other Sources - - - - - - - 142,511 142,511
TOTAL CAPITAL REVENUES 4,421,302 1,980,066 (2,441,236) 242,303 1,002,061 759,758 659,941 683,529 323,588
CAPITAL EXPENSES
Other Non-Operating Expense - - - - - - - - -
Net Change In Restricted Net Assets - - -
Increase In Fixed Assets - Salaries 245,725 180,734 64,991 230,786 65,226 165,560 294,980 65,690 229,290
Increase In Fixed Assets - Benefits 81,637 73,861 7,775 76,412 28,440 47,972 97,969 27,254 70,715
Increase In Fixed Assets - Services - 224 (224) - 142 (142) - 161 (161)
Increase In Fixed Assets - Site Improvements - 29,785 (29,785) - - - - -
Increase In Fixed Assets - Land - - - -
Increase In Fixed Assets - Equipment - - -
Increase In Fixed Assets - Construction 9,160,179 4,661,505 4,498,674 3,831,262 462,921 3,368,340 4,390,563 443,245 3,947,318
Increase In Fixed Assets - Other - - - 161 (161)
Debt Service Principal 1,702,563 572,855 1,129,708 541,127 288,262 252,865 - - - 413,162 - 413,162
Operating Transfers Out - - - - - - - - -
TOTAL CAPITAL EXPENSES 11,190,103 5,518,965 5,671,139 4,679,587 844,992 3,834,595 5,196,674 536,510 4,660,164
BEGINNING WORKING CAPITAL - January 1, 2016 6,772,562 6,772,562 - 8,600,000 8,600,000 - 11,900,000 11,900,000 -
ENDING WORKING CAPITAL - September 30, 2016 3,761 3,233,664 3,229,903 4,162,716 8,757,069 4,594,353 7,363,267 12,047,019 4,683,752
NET CHANGE IN WORKING CAPITAL (see Note)(6,768,801) (3,538,899) 3,229,903 (4,437,284) 157,069 4,594,353 (4,536,733) 147,019 4,683,752
Total Change in Working Capital (4,618,366) (62,727) 4,555,640 (3,393,403) 1,779,507 5,172,910 16,187 235,889 219,702 (2,737,714) 2,106,632 4,844,346
(*) Depreciation 2,726,100 2,263,137 2,104,200 1,644,112 - - 1,688,400 1,452,624
Note: Working Capital = Current Assets
minus Current Liabilities
ENTERPRISE FUNDSOPERATING & CAPITAL FUNDS
WATER SEWER SEWER METRO STORMthrough September 2016
11/21/2016 3:13 PM34
OPERATING FUND:
OPERATING REVENUES
Charges For Service
Grants
Interest Earnings
Interfund Charges For Service
Sewer Metro Service Revenue
Operating Transfers
Rents, Leases, Concessions, & Other
TOTAL OPERATING REVENUES
OPERATING EXPENSES
Salaries & Wages
Benefits
Supplies
Other Service Charges
Capital
Intergovernmental Services
Waste Management Payments
Sewer Metro Services
Debt Service Interest
Interfund Loan Repayment
Interfund Operating Rentals & Supplies
TOTAL OPERATING EXPENSES
OPERATING REVNUES LESS EXPENSES
BEFORE DEPRECIATION (*)
BEGINNING WORKING CAPITAL - January 1, 2016
ENDING WORKING CAPITAL - September 30, 2016
NET CHANGE IN WORKING CAPITAL (see Note)
CAPITAL FUND:
CAPITAL REVENUES
Interest Revenue
Grants
Contributions
Other Non-Operating Revenue
Gain (Loss) On Sale Of Fixed Assets
Increase In Contributions - System Development
Increase In Contributions - Area Assessments
Increase In Contributions - Other
Increase In Contributions - FAA
Proceeds of Debt Activity
Operating Transfers In
Other Sources
TOTAL CAPITAL REVENUES
CAPITAL EXPENSES
Other Non-Operating Expense
Net Change In Restricted Net Assets
Increase In Fixed Assets - Salaries
Increase In Fixed Assets - Benefits
Increase In Fixed Assets - Services
Increase In Fixed Assets - Site Improvements
Increase In Fixed Assets - Land
Increase In Fixed Assets - Equipment
Increase In Fixed Assets - Construction
Increase In Fixed Assets - Other
Debt Service Principal
Operating Transfers Out
TOTAL CAPITAL EXPENSES
BEGINNING WORKING CAPITAL - January 1, 2016
ENDING WORKING CAPITAL - September 30, 2016
NET CHANGE IN WORKING CAPITAL (see Note)
Total Change in Working Capital
(*) Depreciation
Note: Working Capital = Current Assets
minus Current Liabilities
OPERATING & CAPITAL FUNDS
through September 2016
Budget
YTD
Actual Variance Budget
YTD
Actual Variance Budget
YTD
Actual Variance Budget
YTD
Actual Variance
434 434 435 435 436 436 501 501
464 464 465 465 466 466 -
13,467,100 10,450,311 (3,016,789) 747,400 615,184 (132,216) 878,000 1,022,806 144,806 - - -
109,000 15,375 (93,625) - - - - -
1,300 10,685 9,385 969 2,617 1,648 300 1,669 1,369 1,000 2,644 1,644
- - - -
- - - -
300,000 -
- 320 320 500 (1,370) (1,870) - 20 20 -
13,577,400 10,476,692 (3,100,708) 748,869 616,431 (132,438) 1,178,300 1,024,495 146,195 1,000 2,644 1,644
406,645 306,935 99,711 25,723 20,590 5,133 453,837 356,166 97,671 - - -
206,181 139,203 66,977 10,496 7,010 3,486 258,783 182,759 76,023 215,000 112,132 102,868
34,200 7,248 26,952 2,000 1,523 477 191,300 192,732 (1,432) - - -
1,387,775 909,439 478,336 463,050 335,903 127,147 151,700 87,051 64,649 3,900 269,004 (265,104)
- - - -
420,600 181,206 239,394 - - - - - - - - -
10,645,300 7,228,668 3,416,632
- - - 35,693 675 35,018 - - - - - -
39,947 43,081 (3,134) - -
104,209 78,147 26,062 - - - 50,740 38,052 12,688 - - -
13,204,910 8,850,846 4,354,063 576,908 408,783 168,126 1,106,360 856,761 249,599 218,900 381,136 (162,236)
372,490 1,625,845 1,253,355 171,961 207,649 35,688 71,940 167,734 95,794 (217,900) (378,492) (160,592)
3,477,387 3,477,387 - 166,604 166,604 - 105,646 105,646 - 1,530,589 1,530,589 -
3,849,877 5,103,232 1,253,355 338,565 374,253 35,688 177,586 273,380 95,794 1,312,689 1,152,096 (160,592)
372,490 1,625,845 1,253,355 171,961 207,649 35,688 71,940 167,734 95,794 (217,900) (378,492) (160,592)
31 - (31) - - -
14,456 7,107 (7,349) - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
263,834 108,146 (155,688) - - -
- - - - - -
- - - - - -
- - - - - -
278,321 115,253 (163,068) - - -
- - - - - -
- -
- - - - - -
- - - - - -
- - - - - -
- 12,699 14,541 (1,842)
- - - - - -
- -
469,911 162,608 307,303 - - -
- -
- - - 150,000 - 150,000 - - - - - -
- - - - - -
619,911 162,608 457,303 12,699 14,541 (1,842)
350,000 350,000 - 270,000 270,000 -
8,410 302,645 294,235 257,301 255,459 (1,842)
(341,590) (47,355) 294,235 (12,699) (14,541) (1,842)
372,490 1,625,845 (169,629) 160,294 329,923 59,241 153,193 93,952 (217,900) (378,492) (160,592)
20,000 14,114 426,100 341,007 58,300 37,887 - -
INTERNAL SERVICE FUNDSENTERPRISE FUNDS
SOLID WASTE AIRPORT CEMETERY INSURANCE
11/21/2016 3:13 PM35
OPERATING FUND:
OPERATING REVENUES
Charges For Service
Grants
Interest Earnings
Interfund Charges For Service
Sewer Metro Service Revenue
Operating Transfers
Rents, Leases, Concessions, & Other
TOTAL OPERATING REVENUES
OPERATING EXPENSES
Salaries & Wages
Benefits
Supplies
Other Service Charges
Capital
Intergovernmental Services
Waste Management Payments
Sewer Metro Services
Debt Service Interest
Interfund Loan Repayment
Interfund Operating Rentals & Supplies
TOTAL OPERATING EXPENSES
OPERATING REVNUES LESS EXPENSES
BEFORE DEPRECIATION (*)
BEGINNING WORKING CAPITAL - January 1, 2016
ENDING WORKING CAPITAL - September 30, 2016
NET CHANGE IN WORKING CAPITAL (see Note)
CAPITAL FUND:
CAPITAL REVENUES
Interest Revenue
Grants
Contributions
Other Non-Operating Revenue
Gain (Loss) On Sale Of Fixed Assets
Increase In Contributions - System Development
Increase In Contributions - Area Assessments
Increase In Contributions - Other
Increase In Contributions - FAA
Proceeds of Debt Activity
Operating Transfers In
Other Sources
TOTAL CAPITAL REVENUES
CAPITAL EXPENSES
Other Non-Operating Expense
Net Change In Restricted Net Assets
Increase In Fixed Assets - Salaries
Increase In Fixed Assets - Benefits
Increase In Fixed Assets - Services
Increase In Fixed Assets - Site Improvements
Increase In Fixed Assets - Land
Increase In Fixed Assets - Equipment
Increase In Fixed Assets - Construction
Increase In Fixed Assets - Other
Debt Service Principal
Operating Transfers Out
TOTAL CAPITAL EXPENSES
BEGINNING WORKING CAPITAL - January 1, 2016
ENDING WORKING CAPITAL - September 30, 2016
NET CHANGE IN WORKING CAPITAL (see Note)
Total Change in Working Capital
(*) Depreciation
Note: Working Capital = Current Assets
minus Current Liabilities
OPERATING & CAPITAL FUNDS
through September 2016
Budget
YTD
Actual Variance Budget
YTD
Actual Variance Budget
YTD
Actual Variance Budget
YTD
Actual Variance
503 503 505 505 518 518 550 550
- - 568 568 560 560
743,000 641,188 (101,812) 3,495,900 2,570,056 (925,844) 5,531,965 4,095,083 (1,436,883) 3,371,780 2,478,749 (893,031)
- - - - - -
100 2,685 2,585 2,500 7,880 5,380 3,088 10,665 7,577 4,048 17,534 13,486
- - - -
- - - -
137,950 4,342 203,997 99,997
120,000 30,431 (89,569) - - - - - 26,282 26,282
863,100 674,304 (188,796) 3,498,400 2,577,936 (920,464) 5,673,003 4,110,090 (1,429,305) 3,579,825 2,622,562 (853,263)
84,590 53,712 30,878 707,569 498,500 209,069 1,711,060 1,232,183 478,877 593,881 423,176 170,705
367,005 138,287 228,718 390,621 258,557 132,064 708,330 499,323 209,008 314,545 212,913 101,632
- - - 128,200 131,320 (3,120) 431,480 310,567 120,913 1,341,600 538,615 802,985
402,715 248,535 154,180 2,350,990 1,491,309 859,682 2,737,121 1,937,361 799,760 377,500 229,034 148,466
- - - - - - - -
- - - 890,827 - 890,827 - - - 626,392 616,790 9,602
- - - - - - - - - 5,033 3,885 1,148
- - - -
- - - 110,841 83,133 27,708 160,790 120,591 40,199 212,390 159,397 52,993
854,310 440,535 413,776 4,579,048 2,462,818 2,116,230 5,748,782 4,100,025 1,648,757 3,471,341 2,183,810 1,287,531
8,790 233,769 224,979 (1,080,648) 115,119 1,195,767 (75,779) 10,065 85,844 108,484 438,752 330,268
778,233 778,233 - 2,410,754 2,410,754 - 2,305,195 2,305,195 - 2,974,119 2,974,119 -
787,022 1,012,002 224,979 1,330,105 2,525,872 1,195,767 2,229,416 2,315,260 85,844 3,082,603 3,412,871 330,268
8,790 233,769 224,979 (1,080,648) 115,119 1,195,767 (75,779) 10,065 85,844 108,484 438,752 330,268
412 - (412) 1,652 - (1,652)
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
442,150 326,651 (115,499) 1,118,926 965,101 (153,825)
- - - - - -
442,562 326,651 (115,911) 1,120,578 965,101 (155,477)
- - - - - -
- -
- - - - - -
- - - - - -
- - - - - -
- -
- - - -
1,579,579 655,552 924,027 2,907,063 1,718,014 1,189,049
- 723,002 55,241 667,761
- 9,740
- - - - - - - - - 39,107 19,480 19,627
- - - - - -
1,579,579 655,552 924,027 3,669,172 1,802,476 1,876,436
1,400,000 1,400,000 - 3,100,001 3,100,001 -
262,983 1,071,099 808,116 551,406 2,262,625 1,711,220
(1,137,017) (328,901) 808,116 (2,548,595) (837,375) 1,711,220
8,790 233,769 224,979 (1,080,648) 115,119 1,195,767 (1,212,796) (318,836) 893,959 (2,440,111) (398,623) 2,041,488
- - - - 546,400 525,631 822,500 790,556
WORKER'S COMPENSATION FACILITIES INNOVATION & TECHNOLOGY EQUIPMENT RENTAL
INTERNAL SERVICE FUNDS
11/21/2016 3:13 PM36