HomeMy WebLinkAboutQ2 2018 Financial Report
AGENDA BILL APPROVAL FORM
Agenda Subject: 2nd Quarter 2018 Financial Report Date: September 5, 2018
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 year to
date through June 2018 status report based on financial data available as of July 19, 2018 for the period
ending June 30, 2018 and sales tax information representing business activity that occurred through April
2018.
Staff: Coleman
Meeting Date: October 8, 2018 Item Number:
Quarterly Financial Report Through Q2-2018
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)
General Fund Revenues and Expenditures
(Through Q2-2018) $35.1 $36.8$36.0
$34.0
Total
Revenues
Total
Expenditures
$0
$10
$20
$30
$40
$50
MillionsCouncil& MayorAdministrativeServicesCommunity &Human ServicesMunicipal Court& ProbationHumanResourcesFinanceCity AttorneyCommunityDevelopmentJail - SCOREPolicePublic WorksParks, Arts& RecreationStreetsNon-Departmental$0
$2
$4
$6
$8
$10
$12
$14
$16
$18
MillionsYTD
Budget
YTD
Actuals
(Favorable)
YTD
Actuals
(Unfavorable)
General Fund Expenditures by Department
(Through Q2-2018)
1
Quarterly Financial Report Through Q2-2018 2
General Fund 2017
Summary of Sources and Uses Annual YTD YTD YTD
Budget Budget Actual Actual Amount
Operating Revenues
Property Tax 6 21,281,000$ 11,204,300$ 11,179,408$ 10,964,115$ (24,892)$ (0.2)%
Sales Tax 7-8 14,893,500 7,446,600 7,776,717 7,296,187 330,117 4.4 %
Sales Tax - Pierce County Parks 77,250 37,300 49,563 46,279 12,263 32.9 %
Sales Tax - Annexation Credit 1,250,000 1,250,000 1,056,364 1,006,644 (193,636)(15.5)%
Criminal Justice Sales Tax 1,908,300 916,100 1,072,063 977,844 155,963 17.0 %
Brokered Natural Gas Tax 353,600 232,400 91,424 102,635 (140,976)(60.7)%
City Utilities Tax 9-10 3,991,000 1,878,100 1,849,170 1,855,464 (28,930)(1.5)%
Admissions Tax 317,000 132,800 206,076 193,423 73,276 55.2 %
Electric Tax 9-10 3,577,800 1,939,200 2,048,591 1,998,132 109,391 5.6 %
Natural Gas Tax 9-10 1,006,200 683,500 699,014 727,262 15,514 2.3 %
Cable Franchise Fee 11 986,100 490,800 486,701 502,006 (4,099)(0.8)%
Cable Utility Tax - New in 2017 12 1,000,000 500,000 516,215 262,899 16,215 3.2 %
Cable Franchise Fee - Capital 67,200 33,600 30,406 33,353 (3,194)(9.5)%
Telephone Tax 9-10 1,408,200 724,600 690,962 711,186 (33,638)(4.6)%
Garbage Tax (external)9-10 - - 66,702 63,427 66,702 N/A %
Leasehold Excise Tax 40,000 33,500 177,145 174,508 143,645 428.8 %
Gambling Excise Tax 303,180 151,800 151,190 175,858 (610)(0.4)%
Taxes sub-total 52,460,330$ 27,654,600$ 28,147,711$ 27,091,221$ 493,111$ 1.8 %
Business License Fees 12-13 223,200$ 116,300$ 197,357$ 111,944$ 81,057$ 69.7 %
Building Permits 14 1,653,750 802,800 517,784 713,925 (285,016)(35.5)%
Other Licenses & Permits 543,000 237,000 289,482 282,774 52,482 22.1 %
Intergovernmental (Grants, etc.)15 6,134,150 2,930,638 3,113,230 3,046,274 182,592 6.2 %
Charges for Services:16-18
General Government Services 16 61,300 36,000 41,605 41,494 5,605 15.6 %
Public Safety 16 756,000 356,350 489,924 474,227 133,574 37.5 %
Development Services Fees 17 1,019,100 634,300 351,908 599,939 (282,393)(44.5)%
Culture and Recreation 18 2,366,680 1,251,300 1,368,831 1,229,849 117,531 9.4 %
Fines and Penalties 19-20 885,300 445,900 503,588 443,925 57,688 12.9 %
Fees/Charges/Fines sub-total 13,642,480$ 6,810,588$ 6,873,708$ 6,944,351$ 63,120$ 0.9 %
Interest and Investment Earnings 20-21 68,000$ 29,700$ 176,279$ 96,597$ 146,579$ 493.5 %
Rents and Leases 20-21 816,100 403,000 525,096 447,860 122,096 30.3 %
Contributions and Donations 20-21 35,000 14,100 16,196 20,545 2,096 14.9 %
Other Miscellaneous 20-21 236,800 112,700 150,102 123,142 37,402 33.2 %
Transfers In 144,300 77,500 77,500 76,500 0 0.0 %
Insurance Recoveries - Capital & Operating 105,000 12,500 32,523 20,086 20,023 160.2 %
Other Revenues sub-total 1,405,200$ 649,500$ 977,696$ 784,730$ 328,196$ 50.5 %
Total Operating Revenues 67,508,010$ 35,114,688$ 35,999,115$ 34,820,302$ 884,427$ 2.5 %
Operating Expenditures
Council & Mayor 1,319,943$ 634,400$ 582,102$ 562,892$ 52,298$ 8.2 %
Administration 1,963,814 982,200 767,568 663,014 214,632 21.9 %
Community & Human Services 1,488,828 707,100 509,006 405,631 198,094 28.0 %
Municipal Court & Probation 2,644,145 461,828 355,018 336,192 106,809 23.1 %
Human Resources 1,315,663 646,800 595,394 647,849 51,406 7.9 %
Finance 1,565,731 799,100 735,988 739,290 63,112 7.9 %
City Attorney 2,398,550 1,168,300 1,064,040 972,793 104,260 8.9 %
Community Development 4,870,425 2,404,300 2,041,319 2,087,341 362,981 15.1 %
Jail - SCORE 4,099,465 2,049,733 1,665,696 1,581,197 384,036 18.7 %
Police 27,855,395 13,635,400 13,375,970 12,217,562 259,430 1.9 %
Public Works 3,795,032 1,831,400 1,716,278 1,330,320 115,122 6.3 %
Parks, Arts & Recreation 12,799,606 6,120,700 6,063,359 5,714,750 57,341 0.9 %
Streets 4,039,204 1,837,500 1,746,251 1,684,953 91,249 5.0 %
Non-Departmental 7,358,843 3,509,970 2,787,830 2,203,572 722,139 20.6 %
Total Operating Expenditures 77,514,644$ 36,788,730$ 34,005,818$ 31,147,357$ 2,782,911$ 7.6 %
2018 2018 YTD Budget vs. Actual
Favorable (Unfavorable)
Percentage
Page
Ref
2
Quarterly Financial Report Through Q2-2018 3
Executive Summary
This Executive Summary provides an overview of the City’s overall financial position for the
fiscal period ending June 30, 2018, reflecting financial data available as of July 19, 2018.
General Fund:
Through June 2018, General Fund revenues totaled $36.0 million compared to a budget of
$35.1 million, and were $1.2 million higher than revenues collected through Q2-2017. Some
notable variances to budget year-to-date include:
• Property tax collections through Q2-2018 totaled $11.2 million, which was $25,000
below budget expectations and $215,000 more than was collected through Q2-2017.
[page 6]
• General Fund retail sales tax revenues totaled $7.8 million, exceeding budget by 4.4%
or $330,000 and exceeding Q2-2017 collections by $481,000. The primary areas of
significant increase in sales activity compared to Q2-2017 collections were the
services, automotive, and wholesale trade categories. [pages 7-8]
• The other taxes category performed favorably to budget in Q2-2018. Actual revenues
collected through Q2-2018 was $7.0 million, which was $213,000, or 3.1% favorable
to budget. Leasehold excise tax revenues collected through Q2-2018 exceeded
budget by $144,000 due to a one-time tax receipt for the Emerald Downs property,
which is tribally owned. Electric tax revenues collected during the same period
exceeded budget by $109,000. These revenues were somewhat offset by unfavorable
variances in brokered natural gas tax revenues and telephone tax revenues in the
amount of $141,000 and $34,000, respectively. [pages 9-12]
• Building permit revenue collected through Q2-2018 totaled $518,000, compared to a
budget of $803,000. The number of building permits issued through Q2-2018 was
262, which represents a 34% decline over the number of permits issued through Q2-
2017. [page 14]
• Development services revenues collected through Q2-2018 were $283,000, or 44.5%,
unfavorable to budget. This variance was predominately due to plan check revenues
not meeting budget expectations. [page 17]
General Fund expenditures through the first half of 2018 totaled $34.0 million compared to a
budget of $36.8 million, representing a 7.6% favorable variance to budget. All departments
operated within their budget through Q2-2018.
Year-to-date General Fund expenditures ended the period $2.9 million, or 9.2% higher than
expenditures through Q2-2017. Salary and benefit costs increased by $1.8 million, or 10.2%,
compared to salary and benefit expenditures through Q2-2017. This year-over-year increase
was due primarily to an increase in Council-approved FTEs (Full Time Equivalents), cost of
living adjustments (COLAs), and increased costs associated with healthcare benefits.
Additionally, year-to-date transfers out to other funds increased by $373,000 in 2018 compared
to the same period the year prior. This included a one-time transfer-out of $1.5 million to the
Cumulative Reserve Fund.
3
Quarterly Financial Report Through Q2-2018 4
Street Funds:
The City’s three street funds are special revenue funds wherein the revenue sources and
expenditures are legally restricted. These funds are used for street capital construction
projects, local street repair, and arterial street repair and preservation projects. Through the first
two quarters of 2018, Arterial Street Fund revenues totaled $1.3 million as compared to
collections of $2.8 million through Q2-2017, while expenditures totaled $2.1 million as compared
to expenditures of $3.5 million spent during the same period last year. [pages 24–25]
Local Street Fund revenues of $1.3 million exceeded year-to-date budget expectations by
$390,000 or 47.2%, due to higher than anticipated sales tax revenues from local construction
projects; last year’s collections through the second quarter totaled $1.4 million. Expenditures
were $563,000 as compared with $210,000 in Q2-2017. [pages 26–27]
Lastly, the Arterial Street Preservation Fund revenues totaled $1.2 million through Q2-2018,
which was approximately $56,000 higher than revenues through Q2-2017. Expenditures totaled
$266,000 versus $831,000 through Q2-2017. Historically, the majority of expenditures in all
three street funds occur during the second half of the year when weather conditions are optimal
for pavement construction. [pages 28–29]
$35.1 M
$36.8 M
$36.0 M
$34.0 M
$0.0 $5.0 $10.0 $15.0 $20.0 $25.0 $30.0 $35.0 $40.0 $45.0
Revenues
Expenditures
$ Millions
General Fund
Revenues vs. Expenditures Through Q2-2018 2018 YTD Actual
2018 YTD Budget
4
Quarterly Financial Report Through Q2-2018 5
Enterprise Funds:
The City’s enterprise funds account for operations with revenues primarily provided from user
fees, charges or contracts for services.
Through June 30, 2018 the Water Fund experienced operating income before depreciation of
$2.1 million compared to $2.0 million during the same period last year. The Sewer Fund ended
the first quarter of 2018 with operating income before depreciation of $1.0 million versus $1.2
million through Q2-2017. The Stormwater Fund ended the second quarter with operating
income before depreciation of $1.3 million compared to $1.5 million in Q2-2017. The Solid
Waste Fund ended the quarter with operating income of $376,000 compared to $395,000 for
the same period in 2017. [pages 31–34]
Internal Service Funds:
Internal service funds provide services to other City departments and include functions such as
Insurance, Worker’s Compensation, Facilities, Innovation and Technology, and Equipment
Rental. All funds had sufficient revenues to cover year-end expenditures. [page 34]
Investment Portfolio:
The City’s total cash and investments at the end of the Q2-2018 totaled $141.2 million, and
compares to $132.4 million at the end of Q1-2018. [attachment]
5
Quarterly Financial Report Through Q2-2018 6
General Fund
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 Q2-2018 totaled $11.2 million and were $25,000, or 0.2%,
below budget expectations. While year-to-date revenues fell slightly short of budget
expectations in 2018, they were $215,000, or 2.0% higher than revenues collected through Q2-
2017. The majority of property taxes 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
$22.0
$24.0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsProperty Taxes
2018 Budget
2018 YTD Actual
2017 Actual
$14.4
$15.8
$17.2 $17.9
$20.8
$11.2
$0.0
$5.0
$10.0
$15.0
$20.0
$25.0
2013 2014 2015 2016 2017 2018 YTDMillionsProperty Tax Revenue
Actuals
6
Quarterly Financial Report Through Q2-2018 7
Sales tax collections through Q2-2018 totaled $8.9 million, of which $7.8 million was distributed
to the General Fund and $1.1 million was distributed to the Local Street Fund (SOS) program as
per financial practice. Total sales tax revenue distributions to the General Fund through Q2-
2018 exceeded budget expectations by $330,000, or 4.4%, and were $48,000 (6.6%) over the
same period in 2017.
$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)
2018 Budget
2018 YTD Actual
2017 Actual
$12.4
$13.8 $14.5 $14.6 $14.9
$7.8
$0.0
$2.0
$4.0
$6.0
$8.0
$10.0
$12.0
$14.0
$16.0
$18.0
$20.0
2013 2014 2015 2016 2017 2018 YTDMillionsSales and Use Tax
General Fund Only
Actuals
7
Quarterly Financial Report Through Q2-2018 8
The following table breaks out the City’s base sales taxes, excluding Pierce County Parks Sales
Tax, Criminal Justice Sales Tax, and Annexation Credit Sales Tax, by major business sector.
Total sales tax revenue collected through Q2-2018 exceeded prior year collections by $423,000,
or 5.0%. The business sectors showing the largest increase in revenues compared to last year
were the services, automotive, and wholesale trade industries.
Sales tax revenue on construction is transferred to the Local Street Fund (Fund 103) for local
street repair and maintenance. Through the second quarter of 2018, this totaled $1.1 million,
which was $58,000 less than collections through Q2-2017 but was $347,000 higher than
budget.
2017 2018
Component Group Actual Actual Amount
Construction 1,196,893$ 1,139,316$ (57,577)$ (4.8)%
Manufacturing 374,489 340,007 (34,482)(9.2)%
Transportation & Warehousing 47,245 52,991 5,746 12.2 %
Wholesale Trade 641,660 744,827 103,168 16.1 %
Automotive 1,899,945 2,020,503 120,558 6.3 %
Retail Trade 2,426,714 2,501,011 74,297 3.1 %
Services 1,866,349 2,042,381 176,032 9.4 %
Miscellaneous 39,785 74,998 35,213 88.5 %
YTD Total 8,493,080$ 8,916,034$ 422,954$ 5.0 %
Comparison of Sales Tax Collections by SIC Group
Through June
Change from 2017
Percentage
$0.0
$0.5
$1.0
$1.5
$2.0
$2.5
$3.0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsSales Tax on Construction Transfer
2018 Budget
2018 YTD Actual
2017 Actual
8
Quarterly Financial Report Through Q2-2018 9
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 Q2-2018 totaled $5.4 million and exceeded year-to-date budget by $129,000,
or 2.5%.
$1.9 $1.8
$2.3 $2.3
$2.6
$1.1
$0.0
$0.5
$1.0
$1.5
$2.0
$2.5
$3.0
2013 2014 2015 2016 2017 2018 YTDMillionsSales Tax On Construction Revenue
Actuals
$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
2018 Budget
2018 YTD Actual
2017 Actual
9
Quarterly Financial Report Through Q2-2018 10
Favorable variances in electric and solid waste revenues offset lower collections in telephone
utility taxes.
2017 2018 2018
Utility Tax Type YTD Actual YTD Budget YTD Actual Amount Amount
City Interfund Utility Taxes 1,855,464$ 1,878,100$ 1,849,170$ $ (6,294)(0.3)% $ (28,930)(1.5)%
Electric 1,998,132 1,939,200 2,048,591 50,459 2.5 %109,391 5.6 %
Natural Gas 727,262 683,500 699,014 (28,248) (3.9)%15,514 2.3 %
Telephone 711,186 724,600 690,962 (20,225) (2.8)%(33,638) (4.6)%
Solid Waste (external)63,427 0 66,702 3,275 5.2 %66,702 N/A %
YTD Total 5,355,471$ 5,225,400$ 5,354,438$ $ (1,033)(0.0)% $ 129,038 2.5 %
Through June 2018
Utility Tax by Type
2018 vs. 2017 Actual 2018 vs. Budget
Percentage Percentage
$9.5 $10.0 $9.7 $10.0 $10.2
$5.4
$0.0
$2.0
$4.0
$6.0
$8.0
$10.0
$12.0
2013 2014 2015 2016 2017 2018 YTDMillionsUtility Tax Revenues
Actuals
10
Quarterly Financial Report Through Q2-2018 11
Cable Franchise Fees, which are collected quarterly, totaled $487,000 and were $4,000, or
0.8%, under budget through Q2 2018.
$0
$100
$200
$300
$400
$500
$600
$700
$800
$900
$1,000
$1,100
1st Quarter 2nd Quarter 3rd Quarter 4th QuarterThousandsCable Franchise Fee
2018 Budget
2018 YTD Actual
2017 Actual
$0.9 $0.9 $0.9 $1.0 $1.0
$0.5
$0.0
$0.2
$0.4
$0.6
$0.8
$1.0
$1.2
$1.4
2013 2014 2015 2016 2017 2018 YTDMillionsCable Franchise Fee
Actuals
11
Quarterly Financial Report Through Q2-2018 12
Cable Utility Tax (New in 2017). In September 2016, City Council increased the Cable Utility
Tax from 1.0% to 6.0%, with the entirety of the new tax amount benefitting the General Fund.
This tax became effective on January 1, 2017 and is collected quarterly. The collections
through Q2-2018 totaled $516,000 and were favorable to budget by $16,000, or 3.2%.
$0
$100
$200
$300
$400
$500
$600
$700
$800
$900
$1,000
1st Quarter 2nd Quarter 3rd Quarter 4th QuarterThousandsCable Utility Tax
(New in 2017)
2018 Budget
2018 YTD Actual
2017 Actual
12
Quarterly Financial Report Through Q2-2018 13
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.
Business license revenues collected through June 2018 totaled $197,000 due to a large
percentage of business owners having paid their 2018 annual business license fees in Q1-2018.
$0
$20
$40
$60
$80
$100
$120
$140
$160
$180
$200
$220
$240
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecThousandsBusiness Licenses
2018 Budget
2018 YTD Actual
2017 Actual
$236
$171
$282
$225
$163
$197
$0
$50
$100
$150
$200
$250
$300
$350
2013 2014 2015 2016 2017 2018 YTDThousandsBusiness License Revenues
Actuals
13
Quarterly Financial Report Through Q2-2018 14
Building permit revenues collected through June 2018 totaled $518,000, as compared to a year-
to-date budget of $803,000. A total of 262 building permits were issued through Q2-2018
compared to 398 building permits issued through Q2-2017, representing a 34.2% reduction. Of
the building permit revenues collected through Q2-2018, 73% was attributable to commercial
projects and the remaining 27% was predominately single family housing permits.
Major projects contributing to building permit revenues this quarter include projects at the
Olympic Middle School, Skills, Inc., various Boeing sites, and multiple sites at the Outlet
Collection – Seattle. In addition, permits were issued for single family housing developments,
most notably Wyncrest II.
$0.0
$0.2
$0.4
$0.6
$0.8
$1.0
$1.2
$1.4
$1.6
$1.8
$2.0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsBuilding Permits
2018 Budget
2018 YTD Actual
2017 Actual
$2.1
$1.5
$1.2
$2.0
$1.2
$0.5
$0.0
$0.5
$1.0
$1.5
$2.0
$2.5
2013 2014 2015 2016 2017 2018 YTDMillionsBuilding Permits
Actuals
14
Quarterly Financial Report Through Q2-2018 15
Intergovernmental revenues include grants (direct and indirect federal, state and local),
compact revenue from the Muckleshoot Indian Tribe (MIT), intergovernmental service revenues,
and state shared revenues. Collections through Q2-2018 totaled $3.1 million and were
$183,000, or 6.2%, favorable to budget. The majority of the amount above budget was
increased distributions from the state for marijuana excise taxes. The Q1-2018 distribution for
this line item included make-up monies from the September and December 2017 distributions.
Also, the 2018 distribution is based upon a higher distribution base than 2017.
2017 2018 2018
Revenue YTD Actual YTD Budget YTD Actual Amount Amount
Federal Grants 72,562$ 100,000$ 110,084$ $ 37,522 51.7 % $ 10,084 N/A %
State Grants 70,234 94,000 89,821 19,587 27.9 %(4,179) (4.4)%
Interlocal Grants 65,000 40,000 28,817 (36,183) 0.0 %(11,183)N/A %
Muckleshoot Casino Services 399,837 368,488 496,975 97,137 24.3 %128,486 34.9 %
State Shared Revenues:
Streamlined Sales Tax 952,157 944,300 895,247 (56,909) (6.0)%(49,053) (5.2)%
Motor Vehicle Fuel Tax 533,050 606,500 577,019 43,969 8.2 %(29,481) (4.9)%
Criminal Justice - High Crime 286,498 96,000 104,972 (181,526) (63.4)%8,972 9.3 %
Criminal Justice - Population 10,658 12,200 11,190 532 5.0 %(1,010) (8.3)%
Criminal Justice - Special Prog.38,776 40,400 40,540 1,764 4.5 %140 0.3 %
Marijuana Revenues 19,665 32,500 145,971 126,306 642.3 %113,471 349.1 %
State DUI 5,877 6,000 5,837 (40) (0.7)%(163) (2.7)%
Fire Insurance Tax 78,078 75,000 79,798 1,720 2.2 %4,798 6.4 %
Liquor Excise 188,473 191,250 199,801 11,328 6.0 %8,551 4.5 %
Liquor Profit 325,408 324,000 327,159 1,751 0.5 %3,159 1.0 %
Total State Shared:2,438,640 2,328,150 2,387,534 (51,106)(2.1)%59,384 2.6 %
YTD Total 3,046,274$ 2,930,638$ 3,113,230$ 66,956$ 2.2 %182,592$ 6.2 %
Through June 2018
Intergovernmental Revenues (Grants, Entitlements & Services)
2018 vs. 2017 Actual 2018 vs. Budget
% Change % Change
$4.8 $5.1 $5.3 $5.7 $6.1
$3.1
$0
$1
$2
$3
$4
$5
$6
$7
$8
2013 2014 2015 2016 2017 2018 YTDMillionsIntergovernmental Revenues
(Grants, Entitlements & Services)
Actuals
15
Quarterly Financial Report Through Q2-2018 16
Charges for Services consist of general governmental service charges, public safety charges,
development service fees, and cultural & recreation fees. Total charges for services collected
through June 2018 totaled $2.3 million, which was $26,000 less than anticipated through the
first half of 2018. This was due to lower than expected development services revenues, offset
by increases in public safety and culture and recreation revenues, as explained below.
General governmental charges for service collected through Q2-2018 totaled $42,000 and were
$6,000 favorable to budget.
Public safety revenues consist of revenues received for police officer extra duty security
services – where officers are contracted for and reimbursement is made by the hiring contractor.
This also includes reimbursements from the Muckleshoot Indian Tribe (MIT) for a full-time
dedicated police officer and associated expenditures as well as monies collected from the
Auburn School District and the Criminal Justice Training Commission (CJTC) for services
rendered. Public safety revenues collected through Q2-2018 totaled $490,000 and compare to
a budget of $356,000. The majority of the favorability seen in this revenue source is due to
extra duty overtime reimbursements exceeding budget expectations – due to increased
requests for police officer security services.
2017 2018 2018
Revenue YTD Actual YTD Budget YTD Actual Amount Amount
General Government 41,494$ 36,000$ 41,605$ $ 111 0.3 % $ 5,605 15.6 %
Public Safety 474,227 356,350 489,924 15,698 3.3 %133,574 37.5 %
Development Services 599,939 634,300 351,908 (248,032) (41.3)%(282,393) (44.5)%
Culture & Recreation 1,229,849 1,251,300 1,368,831 138,982 11.3 %117,531 9.4 %
YTD Total 2,345,509$ 2,277,950$ 2,252,268$ (93,241)$ (4.0)% $ (25,682)(1.1)%
Through June 2018
Charges for Services by Type
2018 vs. 2016 Actual 2018 vs. Budget
Percentage Percentage
$3.3
$3.9 $4.3 $4.1 $4.2
$2.3
$0.0
$1.0
$2.0
$3.0
$4.0
$5.0
$6.0
2013 2014 2015 2016 2017 2018 YTDMillionsCharges for Services
Actuals
16
Quarterly Financial Report Through Q2-2018 17
Development services fee collections, which primarily consist of plan check fees, totaled
$352,000 and ended the quarter $283,000, or 44.5%, under budget expectations. Total plan
check revenues collected through Q2-2018 totaled $204,000 as compared to $464,000
collected the same period last year. Plan check revenues collected in Q2-2018 include both
commercial and residential projects, including projects at Boeing and the Outlet Collection as
well as single family housing plans – most notably Willow Place.
$0.0
$0.2
$0.4
$0.6
$0.8
$1.0
$1.2
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsDevelopment Service Fees
2018 Budget
2018 YTD Actual
2017 Actual
$1.1 $1.1
$1.4
$1.0
$0.9
$0.4
$0.0
$0.2
$0.4
$0.6
$0.8
$1.0
$1.2
$1.4
$1.6
2013 2014 2015 2016 2017 2018 YTDMillionsDevelopment Service Fees
Actuals
17
Quarterly Financial Report Through Q2-2018 18
Culture and recreation revenues collected through Q2-2018 totaled $1.4 million, exceeding
collections in the same period last year by $139,000 and exceeding Q2-2018 budget
expectations by $118,000. The majority of the year-over-year increase in revenues was seen in
green fee revenues at the Auburn Golf Course and recreational class revenues. The majority of
culture and recreation revenues are derived from greens fees and pro shop sales at the Auburn
Golf Course, recreational classes, athletic league fees, and special events.
$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
2018 Budget
2018 YTD Actual
2017 Actual
$2.1 $2.2 $2.3 $2.3 $2.4
$1.4
$0.0
$0.5
$1.0
$1.5
$2.0
$2.5
$3.0
2013 2014 2015 2016 2017 2018 YTDMillionsCulture & Recreation Revenues
Actuals
18
Quarterly Financial Report Through Q2-2018 19
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 Q2-2018 totaled $504,000 compared to a
budget of $446,000.
2017 2018 2018
Month YTD Actual YTD Budget YTD Actual Amount Amount
Civil Penalties 4,578$ 2,200$ 49,378$ $ 44,800 978.6 % $ 47,178 2,144.5 %
Civil Infraction Penalties 253,216 248,900 262,485 9,269 3.7 %13,585 5.5 %
Redflex Photo Enforcement 6,063 0 4,616 (1,446) (23.9)%4,616 N/A %
Parking Infractions 74,384 76,300 68,184 (6,199) (8.3)%(8,116) (10.6)%
Criminal Traffic Misdemeanor 28,366 20,500 28,616 250 0.9 %8,116 39.6 %
Criminal Non-Traffic Fines 13,824 20,400 26,032 12,208 88.3 %5,632 27.6 %
Criminal Costs 25,204 22,000 23,337 (1,867) (7.4)%1,337 6.1 %
Non-Court Fines & Penalties 38,292 55,600 40,938 2,646 6.9 %(14,662) (26.4)%
YTD Total 443,925$ 445,900$ 503,588$ $ 59,662 13.4 % $ 57,688 12.9 %
Through June 2018
Fines & Penalties by Type
2018 vs. 2017 Actual 2018 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
2018 Budget
2018 YTD Actual
2017 Actual
19
Quarterly Financial Report Through Q2-2018 20
Miscellaneous revenues consist of investment earnings, income from facility rentals,
contributions & donations, and other income including the quarterly purchasing card (P-card)
rebate monies. Revenues collected in this category through Q2-2018 totaled $868,000 and
exceeded budget expectations by $308,000. The majority of the increase in revenues was seen
in interest and investments as well as the rents and leases category.
Interest and investments revenues collected through Q2-2018 exceeded budget expectations by
$147,000. This year-over-year increase in investment revenue is primarily due to the increase
in the State Investment Pool interest rate.
Rents and lease revenue collected through Q2-2018 totaled $525,000 and was $77,000 higher
than what was collected through Q2-2017. The increase in revenues collected was seen in
facility rentals: miscellaneous parks unearned revenue (deposits) through Q2-2018 increased
by $34,000 compared to collections through Q2-2017. In addition, golf cart rental revenues
collected year-to-date were $23,000 more than was collected through Q2-2017.
Lastly, other miscellaneous revenues exceeded budget expectations by $37,000 mainly due to
assessments for code compliance property abatements and sales of unclaimed property.
$1.4
$1.2
$0.9 $0.9 $0.9
$0.5
$0.0
$0.2
$0.4
$0.6
$0.8
$1.0
$1.2
$1.4
$1.6
$1.8
$2.0
2013 2014 2015 2016 2017 2018 YTDMillionsFines & Penalties
Actuals
2017 2018 2018
Month YTD Actual YTD Budget YTD Actual Amount Amount
Interest & Investments 96,597$ 29,700$ 176,279$ 79,683$ 82.5 %146,579$ 493.5 %
Rents & Leases 447,860 403,000 525,096 77,236 17.2 %122,096 30.3 %
Contributions & Donations 20,545 14,100 16,196 (4,349)(21.2)%2,096 14.9 %
Other Miscellaneous Revenue 123,142 112,700 150,102 26,960 21.9 %37,402 33.2 %
YTD Total 688,144$ 559,500$ 867,673$ 179,529$ 26.1 %308,173$ 55.1 %
Miscellaneous Revenues by Type
Through June 2018
2018 vs. 2017 2018 vs. Budget
Percentage Percentage
20
Quarterly Financial Report Through Q2-2018 21
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 Q2-2018
totaled $1.9 million, exceeding budget expectations by $653,000 and exceeding prior year
collections through Q2-2017 by $171,000. Real estate sales in Q2-2018 represent the sale of
both commercial properties and single family residences. Commercial sales in Q2-2018
included the sale of several multi-family properties, vacant land, an auto dealership and the sale
of a hotel and a motel.
$0.7
$1.0 $1.0
$1.2
$1.5
$0.9
$0.0
$0.2
$0.4
$0.6
$0.8
$1.0
$1.2
$1.4
$1.6
2013 2014 2015 2016 2017 2018 YTDMillionsMiscellaneous Revenues
Actuals
2017 2018 2018
Month Actual Budget Actual Amount Amount
Jan 224,044$ 200,800$ 240,414$ 16,371$ 7.3 %39,614$ 19.7 %
Feb 249,683 200,800 200,783 (48,899) (19.6)%(17) (0.0)%
Mar 326,044 200,800 255,218 (70,826) (21.7)%54,418 27.1 %
Apr 234,480 200,800 362,999 128,519 54.8 %162,199 80.8 %
May 299,251 200,800 427,054 127,803 42.7 %226,254 112.7 %
Jun 353,807 200,800 371,816 18,009 5.1 %171,016 85.2 %
YTD Total 1,687,310$ 1,204,800$ 1,858,286$ 170,976$ 10.1 %653,486$ 54.2 %
2018 vs. 2017 2018 vs. Budget
Percentage
Real Estate Excise Tax Revenues
June 2018
Percentage
21
Quarterly Financial Report Through Q2-2018 22
$0.0
$0.5
$1.0
$1.5
$2.0
$2.5
$3.0
$3.5
$4.0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsReal Estate Excise Tax
2018 Budget
2018 YTD Actual
2017 Actual
$2.2 $2.5
$4.6
$4.3
$3.6
$1.9
$0.0
$0.5
$1.0
$1.5
$2.0
$2.5
$3.0
$3.5
$4.0
$4.5
$5.0
2013 2014 2015 2016 2017 2018
YTDMillionsReal Estate Excise Tax Revenues
Actuals
22
Quarterly Financial Report Through Q2-2018 23
Pet Licensing
Through the second quarter of 2018, 2,099 pet licenses were sold, resulting in $55,995 in
revenue. Through the second quarter of 2017, 2,178 licenses were sold, resulting in $56,315 in
revenue. As of March 2018, pet licensing services are provided by the Auburn Valley Humane
Society. Previously these services were provided by PetData.
0
500
1,000
1,500
2,000
2,500
$0
$5
$10
$15
$20
$25
JanFebMarAprMayJunJulAugSepOctNovDecNumber of Licenses IssuedLicense Revenue( thousands )Pet Licensing Revenues vs Licenses Sold
2018 vs 2017
2017 License Revenue
2018 License Revenue
2017 Licenses Issued
2018 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
2018 vs 2017
2018 License Revenue
2018 Licenses Issued
2017 Licenses Issued
23
Quarterly Financial Report Through Q2-2018 24
Street Funds
This section provides a financial overview of the City’s three street funds for the quarter ending
June 30, 2018. The City’s three street funds include the Arterial Street Fund (Fund 102), the
Local Street Fund (Fund 103), and the Arterial Street Preservation Fund (Fund 105).
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. As of June 30, 2018 there were 25 separate street projects
budgeted in this fund.
Through June, revenues collected totaled $1.3 million as compared with collections of $2.8
million through Q2-2017. Total expenditures through Q2-2018 were $2.1 million as compared to
$3.5 million expended through Q2-2017. Variances in revenues and expenditures are largely
due to the timing of capital expenditures and any subsequent reimbursement via federal grants,
as well as the current phase of individual capital projects.
Fund 102 - Arterial Street 2017
Summary of Sources and Uses Annual YTD YTD YTD
Report Period: June 2018 Budget Budget Actual Actual Amount
Revenues
Federal Grants 2,247,600$ 766,290$ 323,675$ 1,842,767$ (442,616)$ (57.8)%
State Grants 176,500 53,043 - 190,278 (53,043) (100.0)%
Motor Vehicle Fuel and Multimodal Taxes 585,000 277,729 303,360 265,954 25,631 9.2 %
Developer Contributions - - - 46,233 -
Miscellaneous Revenue 466,200 155,400 1,313 - (154,087) (99.2)%
Other Governmental Agencies - - - - -
Public Works Trust Fund Loans - - - - -
Operating Transfer In 1,833,417 735,721 613,996 470,254 (121,725) (16.5)%
Investment Income 2,600 1,177 14,465 4,723 13,287 1128.5 %
Total Revenues 5,311,317$ 1,989,361$ 1,256,809$ 2,820,209$ (732,552)$ (36.8)%
Expenditures
Salary and Benefits 551,000$ 283,810$ 196,445$ 354,273$ 87,365$ 30.8 %
Capital Outlay 5,418,300 1,786,210 1,431,033 2,885,700 355,177 19.9 %
Subtotal - Capital Project Expenditures 5,969,300 2,070,020 1,627,477 3,239,973 442,542 21.4 %
Services and Charges 405,200 49,361 170,642 36,068 (121,282) (245.7)%
Interfund Payments for Services 78,859 39,430 39,432 38,340 (3) (0.0)%
Debt Service Principal and Interest 208,818 208,818 208,817 209,511 1 0.0 %
Operating Transfer Out 55,615 27,808 15,490 6,139 12,318 44.3
Total Expenditures 6,717,792$ 2,395,435$ 2,061,858$ 3,530,031$ 333,577$ 13.9 %
Net Change in Fund Balance (1,406,475)$ (406,074)$ (805,049)$ (709,822)$ (398,975)$ 98.3 %
Beg. Fund Balance, January 2018 2,584,136$
Net Change in Fund Balance, June 2018 (805,049)
Ending Fund Balance, June 2018 1,779,087$
2018 Budgeted Ending Fund Balance 1,177,661$
2018 2018 YTD Budget vs. Actual
Favorable (Unfavorable)
Percentage
24
Quarterly Financial Report Through Q2-2018 25
This table presents the status of the projects with the most significant budget impact on the
fund:
Notes:
• Due to weather, including a wet spring, many projects will not be completed until later in 2018 and new
projects will be moving into construction in the third and fourth quarters of 2018.
$0.0
$1.0
$2.0
$3.0
$4.0
$5.0
$6.0
$7.0
$8.0
$9.0
$10.0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsFund 102 -Capital Project Expenditures
2018 YTD Budget
2018 YTD Actual
2017 YTD Actual
2018 YTD Actual:
$1.6M
2018 Annual Budget:
$6.0M
2017 YTD Actual:
$3.2M
Name Annual Budget YTD Actual Remaining
22nd St NE & I St NE Intersection $1.1M $0.6M $0.6M
AWS Corridor Safety Improvements $0.8M $0.5M $0.4M
A St SE & 37th St SE $0.8M $0.1M $0.7M
All Other Projects (21 Others Budgeted)$3.2M $0.5M $2.7M
Total $6.0M $1.6M $4.3M
*Components may not sum to total due to rounding.
Fund 102 - Arterial Street
Capital Projects Status *
25
Quarterly Financial Report Through Q2-2018 26
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 repair. Through June 30, 2018 revenues in this fund
totaled $1.3 million, exceeding year-to-date budget expectations by $390,000 due to higher than
anticipated sales tax revenues from local construction projects. This is consistent with
collections of $1.4 million through Q2-2017. Total expenditures through Q2-2018 were $563,000
and compare to expenditures of $210,000 through Q2-2017. Historically, well over half of this
fund’s annual expenditures occur in the final four months of each year due to the weather
sensitivity of pavement construction (this work needs to be done primarily in the summer and
early fall). Highlighted in the table below and shown in the following graph are the fund’s total
expenditures related to capital projects.
Fund 103 - Local Street Fund 2017
Summary of Sources and Uses Annual YTD YTD YTD
Report Period: June 2018 Budget Budget Actual Actual Amount
Revenues
Sales Tax on Construction 1,750,000$ 774,167$ 1,139,316$ 1,196,893$ 365,149$ 47.2 %
Operating Transfer In 150,000 150,000 150,000$ 150,000 - 0.0 %
Interest Earnings 9,100 4,175 28,630$ 11,881 24,456 585.8 %
Total Revenues 1,909,100$ 928,342$ 1,317,946$ 1,358,774$ 389,604$ 42.0 %
Expenditures
Salary and Benefits 148,817$ 68,039$ 66,926$ 64,852$ 1,112$ 1.6 %
Capital Project Expenditures 3,429,298 715,640 487,757 133,420 227,884 31.8 %
Services and Charges 700 350 2,236 294 (1,886) (538.1)%
Interfund Payments for Services 12,239 6,120 6,120 5,958 (1) (0.0)%
Operating Transfer Out 516 258 145 5,700 113 43.9
Total Expenditures 3,591,570$ 790,407$ 563,184$ 210,224$ 227,223$ 28.7 %
Net Change in Fund Balance (1,682,470)$ 137,935$ 754,762$ 1,148,550$ 616,827$ 447.2 %
Beg. Fund Balance, January 2018 2,943,350$
Net Change in Fund Balance, June 2018 754,762
Ending Fund Balance, June 2018 3,698,112$
2018 Budgeted Ending Fund Balance 1,260,880$
2018 2018 YTD Budget vs. Actual
Favorable (Unfavorable)
Percentage
26
Quarterly Financial Report Through Q2-2018 27
This table presents the status of the projects with the most significant budget impact on the
fund:
Notes:
• The 2017 Local Street Reconstruction Project began construction in 2017 and has continued into 2018 due
to weather limitations in 2017. The carry-forward for this project was approved in 2018 BA#4.
• 2018 Local Street Pavement Reconstruction was awarded by Council on 6/18/2018.
• 2018 Citywide Pavement Patching and Overlay was awarded by Council on 6/25/2018.
$0.0
$0.5
$1.0
$1.5
$2.0
$2.5
$3.0
$3.5
$4.0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsFund 103 -Capital Project Expenditures
2018 YTD Budget
2018 YTD Actual
2017 YTD Actual
2018 Annual
Budget :
$3.4M
2017 YTD Actual:
$0.1M
2018 YTD Actual:
$0.5M
Name Annual Budget YTD Actual Remaining
2018 Local Street Pavement Reconstruction $1.8M $0.1M $1.7M
2018 Citywide Pavement Patching & Overlay $0.9M $0.0M $0.9M
2017 Local Street Reconstruction & Preservation $0.7M $0.4M $0.3M
All Other Projects (1 Other Budgeted)$0.1M $0.0M $0.1M
Total $3.4M $0.5M $2.9M
*Components may not sum to total due to rounding.
Fund 103 - Local Street
Capital Projects Status*
27
Quarterly Financial Report Through Q2-2018 28
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. Major projects budgeted within the Arterial Street
Preservation Fund in 2018 include 15th Street NE/NW Preservation, South 277th Street
Preservation, and Citywide Pavement Patching and Overlay. Through Q2-2018, revenues
totaled $1.2 million, approximately $56,000 higher than the same period last year.
Total expenditures through Q2-2018 were $266,000, as compared to expenditures of $831,000
through Q2-2017. Historically, the majority of this fund’s expenditures occur in the second half of
each year due to the weather sensitivity of pavement construction (this work needs to be done
primarily in the summer and early fall). Highlighted in the table below and shown in the following
graph are the fund’s total expenditures related to capital projects.
Fund 105 - Arterial Street Preservation 2017
Summary of Sources and Uses Annual YTD YTD YTD
Report Period: June 2018 Budget Budget Actual Actual Amount
Revenues
City Utility Tax 700,000$ 344,771$ 308,195$ 309,244$ (36,576)$ (10.6)%
Electric Utility Tax 715,600 390,036 409,718 399,626 19,682 5.0 %
Natural Gas Utility Tax 201,200 134,984 139,803 145,452 4,819 3.6 %
Cable TV Tax 197,200 97,565 103,243 103,788 5,678 5.8 %
Telephone Utility Tax 281,600 146,167 126,231 142,237 (19,936) (13.6)%
Garbage Utility Tax (External Haulers)- - 10,746 10,571 10,746
Grants 1,511,840 219,950 68,224 25,065 (151,726) (69.0)%
Developer Mitigation Fees - - - - -
Operating Transfer In 2,212,400 2,212,400 33,845 14,647 (2,178,555) (98.5)%
Interest Earnings 4,900 2,450 19,095 12,531 16,645 679.4 %
Total Revenues 5,824,740$ 3,548,323$ 1,219,099$ 1,163,162$ (2,329,224)$ (65.6)%
Expenditures
Salary and Benefits 225,000$ 84,789$ 170,299$ 199,979$ (85,510)$ (100.8)%
Capital Outlay 5,895,840 2,369,517 95,379 620,468 2,274,138 96.0 %
Subtotal - Capital Project Expenditures 6,120,840 2,454,306 265,678 820,447 2,188,628 89.2 %
Supplies - - - - -
Services and Charges 150,000 - - - -
Operating Transfer Out 46,100 46,100 - 10,197 46,100 100.0
Total Expenditures 6,316,940$ 2,500,406$ 265,678$ 830,644$ 2,234,728$ 89.4 %
Net Change in Fund Balance (492,200)$ 1,047,917$ 953,421$ 332,518$ (94,496)$ (9.0)%
Beg. Fund Balance, January 2018 2,039,837$
Net Change in Fund Balance, June 2018 953,421
Ending Fund Balance, June 2018 2,993,258$
2018 Budgeted Ending Fund Balance 1,547,637$
2018 2018 YTD Budget vs. Actual
Favorable (Unfavorable)
Percentage
28
Quarterly Financial Report Through Q2-2018 29
This table presents the status of the projects with the most significant impacts on the fund:
Notes:
• Construction on the 15th Street NE/NW Preservation project was delayed from 2017 to 2018 due to the
Puget Sound Regional Council’s (PSRC’s) modification of the Grant’s obligation year to FY 2018. This
revision was part of a region-wide effort to address federal grant funding restrictions for FY 2017, 2018,
2019 and 2020, and means that funds could not be expended until 2018.
• 15th Street NE/NW Preservation was awarded by Council on 5/7/2018.
• South 277th Street Preservation was awarded by Council on 7/16/2018.
• 2018 Citywide Pavement Patching and Overlay was awarded by Council on 6/25/2018.
$0.0
$1.0
$2.0
$3.0
$4.0
$5.0
$6.0
$7.0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecMillionsFund 105 -Capital Project Expenditures
2018 YTD Budget
2018 YTD Actual
2017 YTD Actual
2018 Annual
Budget:
$6.1M
2017 YTD Actual:
$0.8M
2018 YTD Actual:
$0.3M
Name Annual Budget YTD Actual Remaining
15th St NE/NW Preservation $2.2M $0.1M $2.1M
S 277th Street Preservation $1.3M $0.1M $1.3M
2018 Citywide Pavement and Patching Overlay $1.7M $0.0M $1.6M
All Other Projects (4 Others Budgeted)$1.0M $.1M $0.9M
Total $6.1M $0.3M $5.9M
*Components may not sum to total due to rounding.
Capital Projects Status*
Fund 105 - Arterial Street Preservation
29
Quarterly Financial Report Through Q2-2018 30
Fund 124 – Mitigation Fees
The Mitigation Fees Fund is a special revenue fund funded from revenues from fees for new
development that are assessed at the time applications are received for development activity.
These funds are used to mitigate costs associated with City growth. Through Q2-2018,
revenues were below budget expectations, at 23.7% of the annual budgeted amount. This
variance is largely due to a decrease in single-family housing development, which is the source
of parks impact fees and a significant source of transportation impact fees. Expenditures were
also below budget due to the timing of capital projects funded by these revenues.
Fund 124 - Mitigation Fees
Summary of Sources and Uses
Report Period Through:Ending Ending
June 2018 Fund Balance Fund Balance
Transportation Impact Fees 202,285$ 512,053$ 4,906,702$ 800,000$ 1,498,517$ 4,517,955$
Transportation Migitation Fees - 101,943 132,362 - 188,800 45,505
Fire Impact Fees 112,507 - 198,880 100,000 50,000 136,373
Fire Mitigation Fees - - 81 - - 81
Parks Impact Fees 49,000 169,455 5,209,681 600,000 967,000 4,963,136
Parks Mitigation Fees - - 335,302 - - 335,302
School Impact Admin Fees 774 - 56,889 12,000 - 68,115
Wetland Mitigation Fees - - 69,661 - 31,600 38,061
Interest and Investment Income 89,995 - 89,995 8,200 - 8,200
Fees in Lieu of Improvements - - 123,313 - - 123,313
Operating Transfers - - - 400,000 100,000 300,000
Total 454,562$ 783,451$ 11,122,866$ 1,920,200$ 2,835,917$ 10,536,041$
Beginning Fund Balance, January 2018 11,451,755$
Net Change in Fund Balance, June 2018 (328,889)
Ending Fund Balance, June 2018 11,122,866$
2018 Budgeted Ending Fund Balance 10,536,041$
YTD ACTUALS BUDGET
Revenues Expenditures Revenues Expenditures
30
Quarterly Financial Report Through Q2-2018 31
Enterprise Funds
Detailed income and expense statements for Enterprise and Internal Service funds can be
found in an attachment at the end of this report. The attachment provides operating and, as
applicable, capital fund reports for these funds showing budget, actuals, and variances.
Operating funds house all the operating costs along with debt service and financing obligations.
Capital funds show costs associated with capital acquisition and construction. Both the
operating and capital funds 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.
Through June 30, 2018 the Water Utility had operating income before depreciation of $2.1
million as compared with $2.0 million during the same period last year. Revenues are on track
with budget expectations, and are expected to increase during the second half of the year due
to increased water consumption during the summer months.
Water sales by volume through Q2-2018 totaled 1.31 million hundred cubic feet (ccf), compared
to 1.34 million ccf through Q2-2017, representing a 1.8% decrease. This is part of a general
trend of decreased year-over-year water consumption per account due largely to conservation
efforts and appliance efficiency improvements. Additionally, the City has not provided water to
Water District #111 since its take-or-pay agreement expired and the Interlocal Agreement was
amended; whereas, through Q2-2017, Water District #111 consumed 39,300 ccf of water.
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
2018 vs 2017
2017 Water Sales ($)
2018 Water Sales ($)
2017 Water Sold (ccf)
2018 Water Sold (ccf)
31
Quarterly Financial Report Through Q2-2018 32
The Sewer Utility finished Q2-2018 with operating income before depreciation of $1.0 million as
compared to operating income of $1.2 million through Q2-2017. This decrease is due primarily
to lower revenue from charges for service.
The Stormwater Utility ended Q2-2018 with operating income before depreciation of $1.3
million compared with $1.5 million through Q2-2017. This decrease is due primarily to increases
in operating expenditures.
Through Q2-2018, the Solid Waste Utility Fund had $7.7 million in operating revenues,
compared to $7.3 million in operating expenditures, resulting in an increase in W orking Capital
of $376,000.
The City of Auburn’s Solid Waste services are outsourced to Waste Management and to
Republic Services, who manages the contract for the annexed areas. As of June 2018, Waste
Management serviced 15,479 customers (79% of customers) and Republic Services serviced
4,069 customers (21% of customers).
The current mix of customer account types is:
• 90% Residential
• 8% Commercial
• 2% Multifamily
The “diversion rate” is a measure of how much generated waste is not sent to the landfill; i.e.,
waste that is either recycled or collected yard waste. Through Q2-2018, the total diversion rate
was 30%, which represents a total of 10,000 tons of waste that was diverted from landfills.
Q2-2018 Tons Collected and Diversion Rates:
Garbage -
5,500 tons
(50.0%)Yard Waste -
3,300 tons
(30.6%)
Recycling -
2,100 tons
(19.4%)
Q2-2018 Residential Waste Stream
Garbage
Yard Waste
Recycling
Garbage -
3,500 tons
(76.6%)
Yard Waste
-300 tons
(6.1%)
Recycling -
800 tons
(17.3%)
Q2-2018 Multifamily Waste Stream
Garbage
Yard Waste
Recycling
Total: 4,600 tons collected
Diversion Rate: 23%
Total: 10,900 tons collected
Diversion Rate: 50%
32
Quarterly Financial Report Through Q2-2018 33
Of the total tonnage collected through Q2-2018, 32% was collected from residential customers,
14% from multifamily customers, and 54% from commercial customers, as shown in the
following graph.
Garbage -
14,800 tons
(81.0%)
Yard Waste
-100 tons
(0.6%)
Recycling -
3,400 tons
(18.4%)
Q2-2018 Commercial Waste Stream
Garbage
Yard Waste
Recycling
Total: 18,300 tons collected
Diversion Rate: 19%
Garbage -
23,800 tons
(70.4%)
Yard Waste -
3,700 tons
(11.0%)
Recycling -
6,300 tons
(18.6%)
Q2-2018 Total Waste Stream
Garbage
Yard Waste
Recycling
Total: 33,800 tons collected
Diversion Rate: 30%
5,808
4,715
5,541
0
1,000
2,000
3,000
4,000
5,000
6,000
7,000
Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18Tonnage2018 YTD Solid Waste Tonnage by Customer Type
Residential Multifamily Commercial
5,850 5,966 5,974
33
Quarterly Financial Report Through Q2-2018 34
Through Q2-2018 the Cemetery Fund experienced operating income of $111,000, as
compared with an operating income of $100,000 through Q2-2017. This variance is mainly due
to increased revenue from lot sales.
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 2018. As a result, the expenditure
balance will gradually diminish each month throughout the year.
No significant variances are reported in the Workers’ Compensation, Facilities, Innovation &
Technology, or Equipment Rental Funds.
$0
$200
$400
$600
$800
$1,000
$1,200
$1,400
$1,600
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecThousandsCEMETERY
2018 YTD Budgeted
Revenue
2018 YTD Actual
Revenue
2017 YTD Actual
Revenue
2018 YTD Actual
Expenses
Cumulative Revenues & Expenditures
2018 Budget vs. Actual
34
Quarterly Financial Report Through Q2-2018 35
P-Card Statistics
The City has been actively promoting the use of P-Cards in lieu of purchase orders to minimize
effort and maximize incentive payments from the vendor and the State. In Q2-2018, 4,266
P-Card transactions were processed as compared with 1,144 purchase order transactions.
Total incentive payments received from US Bank in Q2-2018 totaled $24,863. These are
estimated payments since the quarterly rebate checks are not actually received until the next
quarter. Additionally, there is an annual incentive payment from the State that is received in Q2
of each year. The annual State incentive payment for 2017 was $24,693 and was received in
April of 2018.
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.
1,001
3,722
1,144
4,266
-
500
1,000
1,500
2,000
2,500
3,000
3,500
4,000
4,500
5,000
Purchase
Order
Transactions
PCard
Transactions
PCard
Incentives
Received
(see text)
Purchase Order and PCard Transactions
Q2 2017 and 2018
2017 2018
$50,417 $49,556
35
Investment Purchase Purchase Maturity Yield to
Type Date Price Date Maturity
State Investment Pool Various 119,099,522$ Various 1.89%
KeyBank Money Market Various 4,953,893 Various 0.02%
OpusBank Public Interest Acct Various 10,104,958 Various 1.97%
FNMA 3/11/2016 998,844 2/22/2019 1.20%
FHLB 2/28/2018 2,000,000 2/28/2023 2.65%
FFCB 5/21/2018 2,000,000 10/21/2019 2.48%
FAMCA 6/27/2018 2,000,000 1/0/1900 2.50%
Total Cash & Investments 141,157,217$ 1.850%
Investment Mix % of Total
State Investment Pool 84.4%Current 6-month treasury rate 2.11%
KeyBank Money Market 3.5%Current State Pool rate 1.89%
OpusBank Public Interest Acct 7.2%KeyBank Money Market 0.02%
FNMA 0.7%OpusBank Public Interest Acct 1.97%
FHLB 1.4%Blended Auburn rate 1.85%
FFCB 1.4%
FAMCA 1.4%
100.0%
City of Auburn
Investment Portfolio Summary
June 30, 2018
Summary
36
SALES TAX SUMMARY
JUNE 2018 SALES TAX DISTRIBUTIONS (FOR APRIL 2018 RETAIL ACTIVITY)
2017 Annual Total 2017 YTD 2018 YTD YTD 2017 Annual Total 2017 YTD 2018 YTD YTD
NAICS CONSTRUCTION (Nov '16-Oct '17)(Nov '16-Apr '17)(Nov '17-Apr '18)% Diff NAICS AUTOMOTIVE (Nov '16-Oct '17)(Nov '16-Apr '17)(Nov '17-Apr '18)% Diff
236 Construction of Buildings 1,503,231 673,927 655,180 -2.8%441 Motor Vehicle and Parts Dealer 3,703,385 b 1,771,383 1,887,904 6.6%
237 Heavy and Civil Construction 209,928 87,476 68,876 -21.3%447 Gasoline Stations 268,146 128,562 132,598 3.1%
238 Specialty Trade Contractors 918,947 435,490 415,260 -4.6%TOTAL AUTOMOTIVE 3,971,531$ 1,899,945$ 2,020,503$ 6.3%
TOTAL CONSTRUCTION 2,632,107$ 1,196,893$ 1,139,316$ -4.8%Overall Change from Previous Year 120,558$
Overall Change from Previous Year (57,577)$
2017 Annual Total 2017 YTD 2018 YTD YTD
2017 Annual Total 2017 YTD 2018 YTD YTD NAICS RETAIL TRADE (Nov '16-Oct '17)(Nov '16-Apr '17)(Nov '17-Apr '18)% Diff
NAICS MANUFACTURING (Nov '16-Oct '17)(Nov '16-Apr '17)(Nov '17-Apr '18)% Diff 442 Furniture and Home Furnishings 197,226 100,407 104,300 3.9%
311 Food Manufacturing 4,642 2,777 3,217 15.8%443 Electronics and Appliances 211,036 104,146 112,421 7.9%
312 Beverage and Tobacco Products 7,842 3,557 6,214 74.7%444 Building Material and Garden 580,347 259,705 252,997 -2.6%
313 Textile Mills 264 93 297 221.5%445 Food and Beverage Stores 368,971 181,069 183,687 1.4%
314 Textile Product Mills 1,501 658 760 15.4%446 Health and Personal Care Store 368,699 184,781 201,383 9.0%
315 Apparel Manufacturing 227 81 145 79.9%448 Clothing and Accessories 1,118,980 551,953 a 588,758 6.7%
316 Leather and Allied Products 46 25 24 -4.8%451 Sporting Goods, Hobby, Books 199,717 103,093 109,173 5.9%
321 Wood Product Manufacturing 16,528 7,934 6,628 -16.5%452 General Merchandise Stores 992,858 521,330 478,419 -8.2%
322 Paper Manufacturing 15,254 8,455 4,093 -51.6%453 Miscellaneous Store Retailers 463,719 237,153 320,709 35.2%
323 Printing and Related Support 54,391 26,574 24,501 -7.8%454 Nonstore Retailers 370,027 183,077 149,165 -18.5%
324 Petroleum and Coal Products 1,040 339 5,511 1526.1%TOTAL RETAIL TRADE 4,871,580$ 2,426,714$ 2,501,011$ 3.1%
325 Chemical Manufacturing 15,982 8,548 5,868 -31.4%Overall Change from Previous Year 74,297$
326 Plastics and Rubber Products 8,856 3,884 4,791 23.3%
327 Nonmetallic Mineral Products 17,749 7,728 7,698 -0.4%
331 Primary Metal Manufacturing 818 496 683 37.7%2017 Annual Total 2017 YTD 2018 YTD YTD
332 Fabricated Metal Product Manuf 28,618 17,694 11,740 -33.7%NAICS SERVICES (Nov '16-Oct '17)(Nov '16-Apr '17)(Nov '17-Apr '18)% Diff
333 Machinery Manufacturing 18,216 7,961 13,530 69.9%51*Information 662,460 331,192 332,048 0.3%
334 Computer and Electronic Product 32,957 10,763 3,481 -67.7%52*Finance and Insurance 122,200 58,155 71,874 23.6%
335 Electric Equipment, Appliances 1,103 449 346 -22.9%53*Real Estate, Rental, Leasing 367,828 173,046 184,859 6.8%
336 Transportation Equipment Man 385,842 242,605 214,293 -11.7%541 Professional, Scientific, Tech 238,617 121,951 120,935 -0.8%
337 Furniture and Related Products 34,157 10,555 10,490 -0.6%551 Company Management 13 12 5 -60.2%
339 Miscellaneous Manufacturing 31,567 13,312 15,698 17.9%56*Admin. Supp., Remed Svcs 276,380 136,466 192,566 41.1%
TOTAL MANUFACTURING 677,596$ 374,489$ 340,007$ -9.2%611 Educational Services 55,506 25,448 22,465 -11.7%
Overall Change from Previous Year (34,482)$ 62*Health Care Social Assistance 74,678 40,364 45,791 13.4%
71*Arts and Entertainment 109,577 41,752 49,109 17.6%
72*Accommodation and Food Svcs 1,276,310 602,715 687,679 14.1%
2017 Annual Total 2017 YTD 2018 YTD YTD 81*Other Services 546,059 261,725 271,126 3.6%
NAICS TRANSPORTATION AND WAREHOUSING (Nov '16-Oct '17)(Nov '16-Apr '17)(Nov '17-Apr '18)% Diff 92*Public Administration 182,112 73,523 63,924 -13.1%
481 Air Transportation 2 2 0 -100.0%TOTAL SERVICES 3,911,740$ 1,866,349$ 2,042,381$ 9.4%
482 Rail Transportation 20,972 18,157 13,351 -26.5%Overall Change from Previous Year 176,032$
484 Truck Transportation 4,014 1,884 2,780 47.6%
485 Transit and Ground Passengers -3,390 -3,390 34 -101.0%
488 Transportation Support 51,246 23,404 27,619 18.0%2017 Annual Total 2017 YTD 2018 YTD YTD
491 Postal Service 274 149 659 343.2%NAICS MISCELLANEOUS (Nov '16-Oct '17)(Nov '16-Apr '17)(Nov '17-Apr '18)% Diff
492 Couriers and Messengers 1,859 524 1,074 105.1%000 Unknown 0 0 0 N/A
493 Warehousing and Storage 13,526 6,516 7,474 14.7%111-115 Agriculture, Forestry, Fishing 6,486 2,953 1,737 -41.2%
TOTAL TRANSPORTATION 88,502$ 47,245$ 52,991$ 12.2%211-221 Mining & Utilities 26,023 10,901 9,996 -8.3%
Overall Change from Previous Year 5,746$ 999 Unclassifiable Establishments 32,865 25,932 63,266 144.0%
TOTAL SERVICES 65,374$ 39,785$ 74,998$ 88.5%
Overall Change from Previous Year 35,213$
2017 Annual Total 2017 YTD 2018 YTD YTD
NAICS WHOLESALE TRADE (Nov '16-Oct '17)(Nov '16-Apr '17)(Nov '17-Apr '18)% Diff
423 Wholesale Trade, Durable Goods 1,080,558 509,344 603,177 18.4%GRAND TOTAL 17,581,514$ 8,493,080$ 8,916,034$
424 Wholesale Trade, Nondurable 278,097 129,173 139,479 8.0%Overall Change from Previous Year 422,954$ 5.0%
425 Wholesale Electronic Markets 4,428 3,143 2,172 -30.9%
TOTAL WHOLESALE 1,363,083$ 641,660$ 744,827$ 16.1%Total June 2018 Sales Tax Distributions 1,362,018$
Overall Change from Previous Year 103,168$ Dollar Increase from June 2017 38,328$
Percent Increase from June 2017
Includes Adjustments in excess of +/- $10,000.Comparisons:
a. WA State Dept of Revenue audit adjustment to sales tax returns for period of April 2017 (adjustment: - $29,746).June 2017 8,493,080 7,169,390 1,323,690$
b. WA State Dept of Revenue audit adjustment to sales tax returns for period of October 2017 (adjustment: $36,668).June 2016 8,339,659 6,963,435 1,376,224$
06/22/18
Prepared by Auburn Finance Department
2.9%
37
Budget
YTD
Actual Variance Budget
YTD
Actual Variance Budget
YTD
Actual Variance Budget
YTD
Actual Variance
OPERATING FUND:460 460 461 461 462 462
OPERATING REVENUES
Charges For Service 15,203,431 6,288,198 (8,915,233) 8,142,100 4,195,438 (3,946,662) 18,189,923 8,627,017 (9,562,906) 9,242,676 4,896,512 (4,346,164)
Grants - - - - - -
Interest Earnings 10,000 62,889 52,889 20,000 35,035 15,035 1,000 9,689 8,689 15,000 31,943 16,943
Rents, Leases, Concessions, & Other 219,024 127,034 (91,990) 75,570 35,434 (40,136) - - - 63,226 46,212 (17,014)
TOTAL OPERATING REVENUES 15,432,455 6,478,121 (8,954,334) 8,237,670 4,265,907 (3,971,763) 18,190,923 8,636,706 (9,554,217) 9,320,902 4,974,667 (4,346,235)
OPERATING EXPENSES
Salaries & Wages 2,799,131 1,284,391 1,514,740 1,808,531 898,243 910,288 - - - 2,716,743 1,326,041 1,390,702
Benefits 1,416,014 628,023 787,991 906,551 438,557 467,994 - - - 1,396,377 651,255 745,122
Supplies 334,244 131,349 202,895 136,550 67,066 69,484 - - - 94,550 43,844 50,706
Other Service Charges 5,245,350 1,260,106 3,985,244 2,990,471 1,177,923 1,812,548 - - - 1,847,779 734,809 1,112,970
Intergovernmental Services (Less Transfers Out)9,500 8,387 1,113 83,000 64,507 18,493
Waste Management Payments
Sewer Metro Services 18,250,200 8,724,969 9,525,231
(*) Debt Service Interest 1,313,575 395,512 918,063 264,928 138,410 126,518 - - - 350,697 175,348 175,349
Interfund Loan Repayment - - -
Net Change Restricted Assets
Interfund Operating Rentals & Supplies 1,422,040 711,065 710,975 1,034,321 517,158 517,163 - - - 1,444,254 722,681 721,573
TOTAL OPERATING EXPENSES 12,530,354 4,410,446 8,119,908 7,150,852 3,245,745 3,905,107 18,250,200 8,724,969 9,525,231 7,933,400 3,718,485 4,214,915
OPERATING REVENUES LESS EXPENSES
BEFORE DEPRECIATION 2,902,101 2,067,674 (834,427) 1,086,818 1,020,163 (66,655) (59,277) (88,263) (28,986) 1,387,502 1,256,182 (131,320)
NON-OPERATING REVENUES
Operating Transfers-in - - -
Intergovernmental Loan 1,196,600 915 1,195,685
Other Non-Operating Revenues 22,500
NON-OPERATING EXPENSES
Transfer to Capital Subfund 2,446,600 915 2,445,685 - - - 1,200,000 - 1,200,000
Other Operating Transfers-out 279,291 44,659 234,632 253,020 29,084 223,936 369,192 139,726 229,466
(*) Debt Service Principal 1,760,291 624,107 1,136,184 550,947 288,262 262,685 425,578 - 425,578
Net Change in Restricted Net Assets - 379,443 379,443 - 116,898 116,898 - 184,916 184,916
Interfund Loan Repayment
BEGINNING WORKING CAPITAL - January 1, 2018 5,574,972 5,574,972 0 3,609,377 3,609,377 (0) 3,033,467 3,033,467 0 2,910,117 2,910,117 0
ENDING WORKING CAPITAL - June 30, 2018 5,187,491 6,594,438 1,406,947 3,892,228 4,217,796 325,568 2,974,190 2,945,204 (28,986) 2,302,849 3,841,657 1,538,808
NET CHANGE IN WORKING CAPITAL (see Note)(387,481) 1,019,466 1,406,947 282,851 608,419 325,568 (59,277) (88,263) (28,986) (607,268) 931,540 1,538,808
CAPITAL FUND:
CAPITAL REVENUES
Interest Revenue - 8,520 8,520 - 99,522 99,522 - 105,927 105,927
Grants 152,600 22,332 (130,268) 210,000 - (210,000)
Contributions - - - - - - -
Other Non-Operating Revenue - - - - - - - - -
Gain (Loss) On Sale Of Fixed Assets - - - - - - - - -
Increase In Contributions - System Development 1,250,000 205,522 (1,044,478) 600,000 187,212 (412,788) 600,000 292,551 (307,449)
Interfund Revenues - - - - - - - - -
Increase In Contributions - FAA - - - - - - - - -
Proceeds of Debt Activity 2,500,000 - (2,500,000) - - - - - -
Transfers In from Operating Sub-Fund 2,446,600 915 (2,445,685) - - - 1,200,000 - (1,200,000)
Transfer In from Other Funds 200,000 - (200,000) - - - - -
Other Sources - - - - (13,751) (13,751) - - -
TOTAL CAPITAL REVENUES 6,549,200 237,289 (6,311,911) 600,000 272,983 (327,017) 2,010,000 398,479 (1,611,521)
CAPITAL EXPENSES
Other Non-Operating Expense - - - - - - - - -
Increase In Fixed Assets - Salaries 307,857 75,932 231,925 87,857 38,349 49,508 95,714 64,878 30,836
Increase In Fixed Assets - Benefits 123,143 34,898 88,245 35,143 15,866 19,277 38,286 29,003 9,283
Increase In Fixed Assets - Services - - - - - - - - -
Increase In Fixed Assets - Site Improvements - 36,552 (36,552) - - - - -
Increase In Fixed Assets - Equipment - - - - 18,854 (18,854) - - -
Increase In Fixed Assets - Construction 6,690,786 1,294,966 5,395,820 2,212,300 52,115 2,160,185 3,192,300 64,916 3,127,384
Operating Transfers Out 50,000 50,000 - 150,000 50,000 100,000 150,000 50,000 100,000
TOTAL CAPITAL EXPENSES 7,171,786 1,492,348 5,679,438 2,485,300 175,183 2,310,117 3,476,300 208,797 3,267,503
BEGINNING WORKING CAPITAL - January 1, 2018 1,485,010 1,485,010 (0) 12,467,191 12,467,191 0 13,194,888 13,194,888 (0)
862,424 229,951 (632,473) 10,581,891 12,564,992 1,983,101 11,728,588 13,384,570 1,655,982
NET CHANGE IN WORKING CAPITAL (see Note)(622,586) (1,255,058) (632,472) (1,885,300) 97,800 1,983,100 (1,466,300) 189,682 1,655,982
Total Change in Working Capital (1,010,067) (235,592) 774,475 (1,602,449) 706,219 2,308,668 (59,277) (88,263) (28,986) (2,073,568) 1,121,222 3,194,790
(*) Depreciation 3,250,000 1,711,181 2,430,000 1,118,572 - - 2,210,000 1,041,898
OPERATING & CAPITAL FUNDS
WATER
ENTERPRISE FUNDS
SEWER SEWER METRO STORMCash Basis through June 2018
(*) Debt service interest as shown represents actual cash outlay. Debt service principal represents actual expenditures; payments will be made as scheduled in December 2018.
Working Capital = Current Assets
minus Current Liabilities
ENDING WORKING CAPITAL - June 30, 2018
38
OPERATING FUND:
OPERATING REVENUES
Charges For Service
Grants
Interest Earnings
Rents, Leases, Concessions, & Other
TOTAL OPERATING REVENUES
OPERATING EXPENSES
Salaries & Wages
Benefits
Supplies
Other Service Charges
Intergovernmental Services (Less Transfers Out)
Waste Management Payments
Sewer Metro Services
(*) Debt Service Interest
Interfund Loan Repayment
Net Change Restricted Assets
Interfund Operating Rentals & Supplies
TOTAL OPERATING EXPENSES
OPERATING REVENUES LESS EXPENSES
BEFORE DEPRECIATION
NON-OPERATING REVENUES
Operating Transfers-in
Intergovernmental Loan
Other Non-Operating Revenues
NON-OPERATING EXPENSES
Transfer to Capital Subfund
Other Operating Transfers-out
(*) Debt Service Principal
Net Change in Restricted Net Assets
Interfund Loan Repayment
BEGINNING WORKING CAPITAL - January 1, 2018
ENDING WORKING CAPITAL - June 30, 2018
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
Interfund Revenues
Increase In Contributions - FAA
Proceeds of Debt Activity
Transfers In from Operating Sub-Fund
Transfer In from Other Funds
Other Sources
TOTAL CAPITAL REVENUES
CAPITAL EXPENSES
Other Non-Operating Expense
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 - Equipment
Increase In Fixed Assets - Construction
Operating Transfers Out
TOTAL CAPITAL EXPENSES
BEGINNING WORKING CAPITAL - January 1, 2018
NET CHANGE IN WORKING CAPITAL (see Note)
Total Change in Working Capital
(*) Depreciation
OPERATING & CAPITAL FUNDS
Cash Basis through June 2018
Working Capital = Current Assets
minus Current Liabilities
ENDING WORKING CAPITAL - June 30, 2018
Budget
YTD
Actual Variance Budget
YTD
Actual Variance Budget
YTD
Actual Variance Budget
YTD
Actual Variance
464 464 465 465 466 466 -
14,955,350 7,642,423 (7,312,927) 843,300 460,841 (382,459) 933,000 707,468 (225,532) - - -
88,600 - (88,600) - - - - -
9,000 39,306 30,306 2,500 6,318 3,818 800 5,237 4,437 1,500 9,213 7,713
- 882 882 3,000 2,169 (831) - (50) (50)
15,052,950 7,682,611 (7,370,339) 848,800 469,328 (379,472) 933,800 712,655 (221,145) 1,500 9,213 7,713
339,207 170,128 169,079 49,200 - 49,200 490,917 248,167 242,750 - - -
159,496 78,257 81,239 33,700 - 33,700 277,863 131,879 145,984 237,000 35,805 201,195
33,400 1,775 31,625 2,500 2,359 141 221,700 135,866 85,834 - - -
1,655,795 718,381 937,414 588,550 316,545 272,005 157,980 60,775 97,205 4,230 635,626 (631,396)
367,050 92,380 274,670 - - - - - - - - -
12,301,000 6,188,911 6,112,089
- - - 16,425 3,668 12,757 - - - - - -
- - - - -
114,279 57,138 57,141 1,500 750 750 48,898 24,450 24,448 - - -
14,970,227 7,306,970 7,663,257 691,875 323,323 368,552 1,197,358 601,137 596,221 241,230 671,432 (430,202)
82,723 375,641 292,918 156,925 146,005 (10,920) (263,558) 111,518 375,076 (239,730) (662,218) (422,488)
250,000 - (250,000) - - -
- - - 5,000 - 5,000 1,033 290 743
175,000 - 175,000 - - -
- (7,801) (7,801) - - -
40,100 20,155 19,945
5,083,854 5,083,854 0 422,608 422,608 (0) 514,788 514,788 (0) 2,015,500 2,015,500 0
5,166,577 5,459,495 292,918 359,433 556,259 196,826 500,197 626,016 125,819 1,775,770 1,353,282 (422,488)
82,723 375,641 292,918 (63,175) 133,652 196,827 (14,591) 111,228 125,819 (239,730) (662,218) (422,488)
- 1,969 1,969 - 2,070 2,070
44,467 - (44,467) - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
786,000 11,751 (774,249) - - -
- - - - - -
- - - - - -
- - - 75,000 - (75,000)
- - - - - -
830,467 13,720 (816,747) 75,000 2,070 (72,930)
- - - - - -
106,429 - 106,429 - - -
42,571 - 42,571 - - -
- - - - 33 (33)
- - - -
- -
799,034 49,300 749,734 75,000 - 75,000
- - - - - -
948,034 49,300 898,734 75,000 33 74,967
260,972 260,972 0 259,037 259,037 0
143,405 225,393 81,988 259,037 261,075 2,038
(117,567) (35,579) 81,988 - 2,037 2,037
82,723 375,641 (180,742) 98,072 278,814 (14,591) 113,265 127,856 (239,730) (662,218) (422,488)
19,500 9,410 481,000 225,125 51,000 17,123 - -
INSURANCE
(*) Debt service interest as shown represents actual cash outlay. Debt service principal represents actual expenditures;
payments will be made as scheduled in December 2018.
ENTERPRISE FUNDS
SOLID WASTE AIRPORT CEMETERY
INTERNAL SERVICE FUNDS
39
OPERATING FUND:
OPERATING REVENUES
Charges For Service
Grants
Interest Earnings
Rents, Leases, Concessions, & Other
TOTAL OPERATING REVENUES
OPERATING EXPENSES
Salaries & Wages
Benefits
Supplies
Other Service Charges
Intergovernmental Services (Less Transfers Out)
Waste Management Payments
Sewer Metro Services
(*) Debt Service Interest
Interfund Loan Repayment
Net Change Restricted Assets
Interfund Operating Rentals & Supplies
TOTAL OPERATING EXPENSES
OPERATING REVENUES LESS EXPENSES
BEFORE DEPRECIATION
NON-OPERATING REVENUES
Operating Transfers-in
Intergovernmental Loan
Other Non-Operating Revenues
NON-OPERATING EXPENSES
Transfer to Capital Subfund
Other Operating Transfers-out
(*) Debt Service Principal
Net Change in Restricted Net Assets
Interfund Loan Repayment
BEGINNING WORKING CAPITAL - January 1, 2018
ENDING WORKING CAPITAL - June 30, 2018
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
Interfund Revenues
Increase In Contributions - FAA
Proceeds of Debt Activity
Transfers In from Operating Sub-Fund
Transfer In from Other Funds
Other Sources
TOTAL CAPITAL REVENUES
CAPITAL EXPENSES
Other Non-Operating Expense
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 - Equipment
Increase In Fixed Assets - Construction
Operating Transfers Out
TOTAL CAPITAL EXPENSES
BEGINNING WORKING CAPITAL - January 1, 2018
NET CHANGE IN WORKING CAPITAL (see Note)
Total Change in Working Capital
(*) Depreciation
OPERATING & CAPITAL FUNDS
Cash Basis through June 2018
Working Capital = Current Assets
minus Current Liabilities
ENDING WORKING CAPITAL - June 30, 2018
Budget
YTD
Actual Variance Budget
YTD
Actual Variance Budget
YTD
Actual Variance Budget
YTD
Actual Variance
- - 568 568 560 560
1,008,100 510,464 (497,636) 3,463,200 1,833,088 (1,630,112) 6,212,031 3,104,284 (3,107,747) 2,260,325 1,135,444 (1,124,881)
- 49,000 - (49,000) - -
2,600 13,869 11,269 8,800 17,100 8,300 5,500 15,584 10,084 - 26,531 26,531
93,000 2,280 (90,720) - - - - 1,106 1,106 - 132,596 132,596
1,103,700 526,614 (577,086) 3,521,000 1,850,188 (1,670,812) 6,217,531 3,120,975 (3,096,556) 2,260,325 1,294,571 (965,754)
80,132 40,676 39,456 678,651 314,514 364,137 1,909,554 882,947 1,026,607 628,983 301,244 327,739
367,336 87,498 279,838 383,710 167,891 215,819 887,603 407,254 480,349 331,116 154,371 176,745
- - - 140,220 60,264 79,956 434,650 94,164 340,486 1,081,000 372,153 708,847
415,215 162,930 252,285 2,152,962 873,550 1,279,412 3,005,130 1,631,922 1,373,208 435,180 225,053 210,127
- - - - - - - - - - - -
- - - - - - - - - 2,618 1,523 1,095
- - - -
- - - 143,811 71,904 71,907 190,795 95,400 95,395 220,212 110,226 109,986
862,683 291,104 571,579 3,499,354 1,488,123 2,011,231 6,427,732 3,111,687 3,316,045 2,699,109 1,164,569 1,534,540
241,017 235,510 (5,507) 21,646 362,064 340,418 (210,201) 9,288 219,489 (438,784) 130,002 568,786
255,000 161,266 (93,734) 972,496 79,614 (892,882) 150,000 150,000 -
846,939 276,930 570,009 60,500 500 60,000 - - -
- - -
- 300 300 - - - - (146,398) (146,398)
1,625,120 1,625,120 (0) 1,741,924 1,741,924 0 1,804,816 1,804,816 (0) 3,110,811 3,110,811 0
1,866,137 1,860,629 (5,508) 1,171,631 1,988,024 816,393 2,506,611 1,893,217 (613,394) 2,822,027 3,537,211 715,184
241,017 235,510 (5,507) (570,293) 246,100 816,393 701,795 88,402 (613,393) (288,784) 426,400 715,184
- 13,581 13,581 - 29,432 29,432
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - 1,703,631 851,814 (851,817)
- - - - - -
- - - - - -
- - - - - -
232,300 - (232,300) 930,858 29,058 (901,800)
- - - - - -
232,300 13,581 (218,719) 2,634,489 910,304 (1,724,185)
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- -
1,061,100 123,847 937,253 1,615,951 792,766 823,185
98,600 78,240 20,360 800,100 68,664 731,436
- - - - - -
1,159,700 202,087 957,613 2,416,051 861,430 1,554,621
1,837,285 1,837,285 0 3,453,808 3,453,808 (0)
909,885 1,648,779 738,894 3,672,246 3,502,682 (169,564)
(927,400) (188,506) 738,894 218,438 48,874 (169,564)
241,017 235,510 (5,507) (570,293) 246,100 816,393 (225,605) (100,104) 125,501 (70,346) 475,274 545,620
- - - - 726,000 238,175 987,000 572,882
INTERNAL SERVICE FUNDS
WORKER'S COMPENSATION FACILITIES INNOVATION & TECHNOLOGY EQUIPMENT RENTAL
40