HomeMy WebLinkAboutJanuary 2013
AGENDA BILL APPROVAL FORM
Agenda Subject: January 2013 Financial Report
Date: March 13, 2013
Department: Finance
Attachments: Monthly Financial
Report
Budget Impact: $0
Administrative Recommendation:
Background Summary:
The purpose of the monthly financial reports is to summarize for the City Council the general state of
Citywide financial affairs and to highlight significant items or trends that the City Council should be aware
of. The following provides a high level summary of the City’s financial performance. Further detail can be
found within the attached financial report.
The January status report is based on financial data available as of March 11, 2013. Sales tax
information represents business activity that occurred in November 2012.
General Fund:
The general fund is the City’s largest fund and is used to account for the majority of City resources and
services except those required by statute or to be accounted for in another fund.
Revenue collections totaled $4.3 million and are running ahead of 2013 budget of $4.1 million due
primarily to increased revenues from City utility taxes, sales tax revenue, building permits, and
development service fees. City utility taxes collected in the month of January exceed budget $131,000
primarily due to the WSDOT Goedecke Land Agreement of $2.1 million. Retail sales tax collections for
the month exceeded budget by $114,000 due to stronger than anticipated retail sales. Building permit
revenue and development services revenue exceeds budget by $58,000 and $40,000 respectively. This
is a result of overall increased development activity in the region. The building permit fees and
development service fees are related to several projects within the City including The Outlet Collection-
Seattle, as well as several housing developments including Brandon Meadows and Lakeland East.
General fund expenses for January totaled $4.4 million and are in line with budget.
During the month of January, 270 pet licenses were sold resulting in $7,275 in revenue (based on
preliminary data provided by PetData Inc.)
Enterprise Funds:
The City’s eight enterprise funds account for operations with revenues primarily provided from user fees,
charges or contracts for services.
At the end of January, the Water fund ended with operating income of $67,300; the Sewer fund ended the
period with a $203,300 operating loss; and the Storm Drainage fund ended with operating income of
$136,200.
The Golf Course ended the period with an operating loss of $86,200 as compared to an operating loss of
$84,900 for the same period last year. Year-to-date rounds played at the Golf Course totaled 1,277 as
compared to 1,125 the previous year. The Cemetery ended with $3,700 in net operating income
compared to an operating loss of $5,600 for the previous year.
1
Agenda Subject: January 2013 Financial Report
Date: 3/13/2013
Internal Service Funds:
Internal Service Funds provide services to other City departments and include functions such as
Insurance, Facilities, Innovation and Technology, and Equipment Rental. By the end of the year,
revenues received from charges to internal client departments are projected to be sufficient to meet
expenses.
Investment Portfolio:
The City’s total cash and investments at the end of January was $90.6 million which represents no
change from the month prior.
Reviewed by Council & Committees: Reviewed by Departments & Divisions:
Arts Commission COUNCIL COMMITTEES: Building M&O
Airport Finance Cemetery Mayor
Hearing Examiner Municipal Serv. Finance Parks Human Services Planning & CD Fire Planning
Park Board Public Works Legal Police
Planning Comm. Other Public Works Human Resources
Information Services
Action:
Committee Approval: Yes No
Council Approval: Yes No Call for Public Hearing ___/___/____
Referred to _________________________________ Until ____/___/____
Tabled ______________________________________ Until ___/___/____
Councilmember: Partridge Staff: Coleman
Meeting Date: March 18, 2013 Item Number:
2
Monthly Financial Report January 2013
General Fund 2012
Summary of Sources and Uses Annual
BudgetYTD BudgetYTD ActualYTD ActualAmountPercentage
OPERATING REVENUES
Property Tax 14,299,417.00 42,300.00 30,759.46 25,549.49 (11,540.54)-27.3%
Sales Tax 11,280,869.00887,300.001,001,222.89 994,984.41 113,922.89 12.8%
Sales Tax - Annexation Credit 1,397,602.00104,300.00125,582.34 113,646.69 21,282.34 20.4%
Criminal Justice Sales Tax 1,225,059.00 92,800.00120,208.99 107,078.86 27,408.99 29.5%
Brokered Natural Gas Tax 301,500.00 32,100.00 30,564.40 33,214.12 (1,535.60)-4.8%
City Utilities Tax 2,991,933.00222,400.00353,083.01194,049.94 130,683.01 58.8%
Admissions Tax 363,609.00 57,200.00 56,211.04 51,616.58 (988.96)-1.7%
Electric Tax 3,340,500.00857,000.00786,368.23 812,586.09 (70,631.77)-8.2%
Natural Gas Tax 1,201,900.00303,300.00 242,839.11295,288.92 (60,460.89)-19.9%
Cable TV Franchise Fee 808,000.00204,100.00 212,145.32 202,201.09 8,045.32 3.9%
Cable TV Franchise Fee - Capital 62,000.00 15,600.00 15,820.88 15,823.75 220.88 1.4%
Telephone Tax 2,032,574.00148,300.00 85,519.46 148,887.23 (62,780.54)-42.3%
Garbage Tax (external)151,504.00 8,000.00 7,899.52 4,213.80 (100.48)-1.3%
Leasehold Excise Tax 50,501.00 0.00 0.00 0.00 0.00 N/A
Gambling Excise Tax 247,965.00 32,000.00 7,617.98 59,159.78 (24,382.02)-76.2%
Taxes sub-total 39,754,933.003,006,700.003,075,842.633,058,300.7569,142.63 2.3%
Business License Fees 202,005.00 37,000.00 60,211.00 29,394.00 23,211.00 62.7%
Building Permits 1,182,066.00 72,600.00 130,516.70 92,333.05 57,916.70 79.8%
Other Licenses & Permits 454,413.00 25,100.00 46,368.58 25,623.91 21,268.58 84.7%
Intergovernmental (Grants, etc.) - (1)4,751,784.00465,900.00 510,431.36376,544.57 44,531.36 9.6%
Charges for Services:
General Government Services 94,467.00 6,900.00 12,576.24 8,155.82 5,676.24 82.3%
Public Safety 219,305.00 14,600.00 4,365.22 15,429.94 (10,234.78)-70.1%
Development Services Fees 832,458.00 30,600.00 70,450.44 33,758.46 39,850.44 130.2%
Culture and Recreation 809,717.00 52,000.00 67,743.84 53,504.32 15,743.84 30.3%
Fines and Forfeits 1,556,500.00 122,400.00 121,998.49 119,437.73 (401.51)-0.3%
Fees/Charges/Fines sub-total10,102,715.00827,100.001,024,661.87754,181.80197,561.87 23.9%
Interests and Other Earnings 64,900.00 4,200.00 4,086.58 5,837.48 (113.42)-2.7%
Rents, Leases and Concessions 308,000.00 46,500.00 28,728.59 25,658.00 (17,771.41)-38.2%
Contributions and Donations 30,000.00 1,100.00 514.90 2,366.99 (585.10)-53.2%
Other Miscellaneous 92,200.00 3,600.00 7,293.25 4,381.98 3,693.25 102.6%
Transfers In 193,000.00193,000.00 119,548.00 17,000.00 (73,452.00)-38.1%
Insurance Recoveries- Capital & Operating 25,000.00 1,120.40 20,901.69 4,840.53 19,781.29 1765.6%
Other Revenues sub-total 713,100.00249,520.40181,073.0160,084.98(68,447.39)-27.4%
Total Operating Revenues 50,570,748.004,083,320.404,281,577.513,872,567.53198,257.11 4.9%
Operating Expenditures
Council & Mayor 960,930.00 65,600.00 71,090.27 61,077.46 (5,490.27)-8.4%
Municipal Court & Probation 549,494.00 38,200.00 32,115.96 222,120.99 6,084.04 15.9%
Human Resources 1,572,256.00 118,800.00 112,793.06 66,422.34 6,006.94 5.1%
Finance 1,287,232.00100,300.00 89,872.21 90,112.40 10,427.79 10.4%
City Attorney 1,728,391.00126,500.00129,603.89 118,182.79 (3,103.89)-2.5%
Planning 3,824,581.00336,900.00386,952.41349,710.96 (50,052.41)-14.9%
Community & Human Services 1,136,717.00 84,300.00 77,292.43 35,568.36 7,007.57 8.3%
Jail - SCORE 6,676,146.00 714,587.17796,309.94 0.00 (81,722.77)-11.4%
Police 19,434,846.001,692,700.001,578,043.731,611,303.40 114,656.27 6.8%
Engineering 2,646,999.00208,300.00 189,511.71198,284.68 18,788.29 9.0%
Parks and Recreation 7,719,646.00525,800.00573,067.73 516,212.64 (47,267.73)-9.0%
Streets 3,263,864.00207,600.00 207,018.16198,950.94 581.84 0.3%
Non-Departmental 3,567,437.00 177,100.00 190,951.24 136,911.21 (13,851.24)-7.8%
Total Operating Expenditures 54,368,539.004,396,687.174,434,622.743,604,858.17(37,935.57)-0.9%
2013 2013 YTD Budget vs. Actual
Favorable (Unfavorable)
(1) Streamlined Sales Tax mitigation payments represent intergovernmental revenues from the State of Washington
and are presented above in the Intergovernmental Revenue category. For the month of January 2013,
$166,667.67 in Streamlined Sales Tax mitigation payments is included based upon anticipated 2013 Streamlined
Sales Tax mitigation payments of $2,000,000.00 and are reconciled at the end of each quarter based upon actual
distributions from the State.
3
Monthly Financial Report January 2013
Overview
This financial overview reflects the City’s overall financial position for the fiscal period ending
January 31, 2013 and represents financial data available as of March 11, 2013. The budgeted
year-to-date revenues and operating expenses are primarily based on collection/disbursement
average for the same period of the two years prior.
General Fund revenues for the month of January totaled $4.3 million and were above budget by
4.9% or 198,000. This period’s highlights include:
- Tax revenues totaled $3.1 million and were $69,000 above budget.
- Sales taxes totaled $1.0 million and were $114,000 above budget.
- City utility taxes totaled $353,000 and were $131,000 above budget.
- Revenue from Fees/Charges/Fines totaled $1.0 million and was $198,000 above budget
due to stronger than budgeted revenue from development activity.
- Other revenues totaled $181,000 and were $68,000 below budget primarily due to the
timing of transfers.
General Fund expenses in totaled $4.4 million and is on target with budget.
Revenues
The combined total of property tax, sales/use tax, utility tax, gambling, and admissions tax
provide approximately 80% of all resources supporting general governmental activities. The
following section provides additional information on these sources.
Property Tax collections totaled $31,000 and were within expectations. The majority of
property taxes are collected in the months of April and October, coinciding with the due date for
County property tax billings.
$0.0
$2.0
$4.0
$6.0
$8.0
$10.0
$12.0
$14.0
$16.0
JanFebMarAprMayJunJulAugSepOctNovDec
Mi
l
l
i
o
n
s
Property Taxes
2013 budget
2013 actual to date
2012 actual
4
Monthly Financial Report January 2013
Sales taxes, including sales taxes from Pierce County parks, totaled $1.0 million and exceed
budget by $114,000, or 12.8%. This higher revenue is a reflection of increased growth in the
local economy and a rise in consumer confidence. Effective this month, all sales tax revenue
from construction is transferred to the Local Street Fund (Fund 103) for local street repair and
maintenance.
$0.0
$2.0
$4.0
$6.0
$8.0
$10.0
$12.0
$14.0
JanFebMarAprMayJunJulAugSepOctNovDec
Mi
l
l
i
o
n
s
Sales & Use Tax
2013 budget
2013 actual to date
2012 actual
The following table breaks out the City’s base sales tax, excluding Criminal Justice, Annexation
Credit and Streamlined Sales Tax Mitigation by major business sectors.
20122013
Component GroupActualActualAmountPercentage
Construction 105,681.53118,411.0112,729.4812.0%
Manufacturing (35,065.02)60,633.4895,698.50-272.9%
Transportation & Warehousing2,798.384,768.491,970.1170.4%
Wholesale Trade 98,006.4290,351.50(7,654.92)-7.8%
Automotive 223,346.60219,702.55(3,644.05)-1.6%
Retail Trade 324,108.87346,516.5322,407.666.9%
Services 269,210.85269,099.54(111.31)0.0%
Miscellaneous 2,681.895,668.422,986.53111.4%
YTD Total 990,769.521,115,151.52124,382.0012.6%
Change from 2012
January-2013
Comparison of Sales Tax Collections by SIC Group
As shown above, sales taxes by business sector totaled $1.1 million and were $124,000 or 12.6%
more than the year prior.
5
Monthly Financial Report January 2013
Effective January 2013, sales tax revenue on construction is transferred from the General Fund to
the Local Street Fund (Fund 103) for local street repair and maintenance. January sales tax
revenue on construction was $118,000 compared to budget of $125,000.
$0.0
$0.2
$0.4
$0.6
$0.8
$1.0
$1.2
$1.4
$1.6
JanFebMarAprMayJunJulAugSepOctNovDec
Mi
l
l
i
o
n
s
Sales Tax on Construction Transfer
2013 budget
2013 actual to date
$0.0
$2.0
$4.0
$6.0
$8.0
$10.0
$12.0
JanFebMarAprMayJunJulAugSepOctNovDec
Mi
l
l
i
o
n
s
Utility Tax
2013 budget
2013 actual to date
2012 actual
6
Monthly Financial Report January 2013
Utility Taxes consists of City inter-fund utility taxes (Water, Sewer, Storm and Solid Waste) and
external utility taxes (Electric, Natural Gas, Telephone and Solid Waste). Total utility taxes
collected in January was $1.8 million and was $63,000 or 4.1% less than budget. The following
table presents utility tax collections by source:
201220132013
Month ActualBudgetActualAmountPercentageAmountPercentage
City Interfund Utility Taxes194,049.94222,400.00353,083.01159,033.0782.0%130,683.0158.8%
Electric 812,586.09857,000.00786,368.23(26,217.86)-3.2%(70,631.77)-8.2%
Natural Gas 295,288.92303,300.00242,839.11(52,449.81)-17.8%(60,460.89)-19.9%
Telephone 148,887.23148,300.0085,519.46(63,367.77)-42.6%(62,780.54)-42.3%
Garbage (external)4,213.808,000.007,899.523,685.7287.5%(100.48)-1.3%
YTD Total 1,455,025.981,539,000.001,475,709.3320,683.351.4%(63,290.67)-4.1%
January-2013
Utility Tax by Type
2013 vs. 2012 2013 vs. Budget
Cable TV Franchise Fees, which are collected quarterly, totaled $212,000 and exceed budget by
$10,000 or 4.9%.
$0
$100
$200
$300
$400
$500
$600
$700
$800
$900
1st Quarter2nd Quarter3rd Quarter4th Quarter
Th
o
u
s
a
n
d
s
Cable TV Franchise Fee
2013 budget
2013 actual to date
2012 actual
Licenses and Permits include business licenses, building permits, plumbing, electric and other
licenses and permit fees. Building permit fees and business licenses make up 80% of the annual
budgeted revenue in this category.
Building permit revenues in January was $131,000 and exceeded both budget and prior year
actuals of $73,000 and $92,000 respectively. This revenue was generated from several projects
including the The Outlet Collection – Seattle, as well as the Lakeland East and Kendall Ridge
housing developments. In general, building permit activity has increased, reflecting the broader
trend of increased construction activity in the region.
7
Monthly Financial Report January 2013
$0
$200
$400
$600
$800
$1,000
$1,200
$1,400
$1,600
$1,800
JanFebMarAprMayJunJulAugSepOctNovDec
Th
o
u
s
a
n
d
s
Building Permits
2013 budget
2013 actual to date
2012 actual
Business License revenues totaled $60,000 in January and exceeds budget due to timing of
payments. The majority of business license payments are collected within the first two months of
the year and in December.
$0
$50
$100
$150
$200
$250
JanFebMarAprMayJunJulAugSepOctNovDec
Th
o
u
s
a
n
d
s
Business Licenses
2013 budget
2013 actual to date
2012 actual
8
Monthly Financial Report January 2013
Intergovernmental includes Grants (Direct & Indirect Federal, State and Local), state shared
revenues and compact revenue from the Muckleshoot Indian Tribe. Collections totaled
$510,000 and exceeds budget by $45,000 or 9.6%. State shared revenue includes $167,000 in
Streamlined Sales Tax mitigation payments.
201220132013
Revenue ActualBudgetActual% ChangeAmount% Change
Federal Grants 0.00 0.004,544.04 N/A4,544.04 N/A
State Grants 0.00 0.0010,159.57 N/A10,159.57 N/A
Interlocal Grants 0.00200.00 0.00 N/A(200.00)-100.0%
State Shared Revenue 376,544.57300,700.00306,000.05-18.7%5,300.05 1.8%
Muckleshoot Casino Emerg.0.00165,000.00182,594.00 N/A17,594.0010.7%
Intergovernmental Service 0.00 0.007,133.70 N/A7,133.70 N/A
YTD Total 376,544.57465,900.00510,431.3635.6%44,531.36 9.6%
January-2013
Intergovernmental
2013 vs. 20122013 vs. Budget
Charges for Services consists of general governmental services, public safety, development service
fees and cultural & recreation fees and totaled $155,000 in January. Development service fees
and culture and recreation fees make up over 85% of the revenue within this category.
Development services revenues totaled $70,000 compared to budget of $31,000 due to strong
development activity. Development service revenues primarily reflect plan check revenues of
which are most notably attributable to The Outlet Collection – Seattle, and several sub-divisions
including Vista Pointe, Kersey III and Kendall Ridge. Culture and recreation revenues are
improved over 2012 levels and are higher than budget, reflecting revenues from the Daddy
Daughter Date Night, increased ticket sales at the Auburn Avenue Theatre, and increased
registrations for recreation classes and league enrollment.
201220132013
Revenue ActualBudgetActualAmountPercentageAmountPercentage
General Government 8,155.826,900.0012,576.244,420.4254.20%5,676.2482.26%
Public Safety 15,429.9414,600.004,365.22(11,064.72)-71.7%(10,234.78)-70.1%
Development Services33,758.4630,600.0070,450.4436,691.98108.7%39,850.44130.2%
Culture & Recreation53,504.3252,000.0067,743.8414,239.5226.6%15,743.8430.3%
YTD Total 110,848.54104,100.00155,135.7444,287.2040.0%51,035.7449.0%
January-2013
Charges for Services by Type
2013 vs. 20122013 vs. Budget
9
Monthly Financial Report January 2013
$0
$200
$400
$600
$800
$1,000
$1,200
$1,400
JanFebMarAprMayJunJulAugSepOctNovDec
Th
o
u
s
a
n
d
s
Development Service Fees
2013 budget
2013 actual to date
2012 actual
$0
$100
$200
$300
$400
$500
$600
$700
$800
$900
$1,000
JanFebMarAprMayJunJulAugSepOctNovDec
Th
o
u
s
a
n
d
s
Culture & Recreation
2013 budget
2013 actual to date
2012 actual
Fines & Penalties include traffic and parking infraction penalties, Redflex photo enforcement
violations, criminal fines (including criminal traffic, criminal non traffic and criminal costs) as well
as non court fines such as false alarm and shopping cart fines. Total revenue for the month of
January was $122,000 and is on target with expectations.
10
Monthly Financial Report January 2013
201220132013
Month ActualBudgetActualAmountPercentageAmountPercentage
Civil Penalties 1,037.77900.001,181.79144.0213.9%281.7931.3%
Civil Infraction Penalties 44,664.2745,600.0035,323.42(9,340.85)-20.9%(10,276.58)-22.5%
Red Light Photo Enforcement53,880.9848,700.0054,973.831,092.852.0%6,273.8312.9%
Parking Infractions 7,595.9511,900.0013,092.315,496.3672.4%1,192.3110.0%
Criminal Traffic Misdemeanor5,076.626,000.004,679.30(397.32)-7.8%(1,320.70)-22.0%
Criminal Non-Traffic Fines4,402.235,000.004,312.19(90.04)-2.0%(687.81)-13.8%
Criminal Costs 867.99900.00325.96(542.03)-62.4%(574.04)-63.8%
Non-Court Fines & Penalties1,911.923,400.008,109.696,197.77324.2%4,709.69138.5%
YTD Total 119,437.73122,400.00121,998.492,560.762.1%(401.51)-0.3%
January-2013
Fines & Forfeits by Type
2013 vs. 20122013 vs. Budget
$0.0
$0.2
$0.4
$0.6
$0.8
$1.0
$1.2
$1.4
$1.6
$1.8
JanFebMarAprMayJunJulAugSepOctNovDec
Mi
l
l
i
o
n
s
Fines & Penalties
2012 budget
2012 actual to date
2011 actual
11
Monthly Financial Report January 2013
$0
$100
$200
$300
$400
$500
$600
$700
JanFebMarAprMayJunJulAugSepOctNovDec
Th
o
u
s
a
n
d
s
Photo Enforcement
2013 budget
2013 actual to date
2012 actual
Miscellaneous revenues include interest and other investment earnings, rents, leases &
concessions, contributions & donations and other miscellaneous income. Revenues in this
category totaled $41,000 and was below budget by $15,000 partially due to timing of revenues
from rents and leases.
201220132013
Month ActualBudgetActualAmountPercentageAmountPercentage
Interest & Investments 5,837.484,200.004,086.58(1,750.90)-30.0%(113.42)-2.7%
Rents & Leases 25,658.0046,500.0028,728.593,070.5912.0%(17,771.41)-38.2%
Contributions & Donations2,366.991,100.00514.90(1,852.09)-78.2%(585.10)-53.2%
Other Miscellaneous Revenue4,381.983,600.007,293.252,911.2766.4%3,693.25102.6%
YTD Total 38,244.4555,400.0040,623.322,378.876.2%(14,776.68)-26.7%
Miscellaneous Revenues by Type
January-2013
2013 vs. 20122013 vs. Budget
12
Monthly Financial Report January 2013
Real Estate Excise Tax (REET) revenue is receipted into the Capital Improvement Projects Fund
and is used for governmental capital projects. January REET revenue was $114,000 and exceeds
budget by $53,000.
$0.0
$0.2
$0.4
$0.6
$0.8
$1.0
$1.2
$1.4
$1.6
$1.8
JanFebMarAprMayJunJulAugSepOctNovDec
Mi
l
l
i
o
n
s
Real Estate Excise Tax
2013 budget
2013 actual to date
2012 actual
13
Monthly Financial Report January 2013
Pet Licensing
During the month of January, 270 pet licenses were sold resulting in $7,275 in revenue. *
0
100
200
300
400
500
600
700
800
900
1000
$0
$1,000
$2,000
$3,000
$4,000
$5,000
$6,000
$7,000
$8,000
JanFebMarAprMayJunJulAugSepOctNovDec
Pet Licensing Revenue & Sales By Month
2013
2013 License Revenue (L)2013 Licenses Sold (R)
*Based on preliminary data from PetData Inc. A reconciliation by City staff is in progress.
Enterprise Funds
Starting with this month’s Financial Report, the detailed Working Capital and Fund Balance
statements for Enterprise and Internal Service funds are presented on larger ledger-sized paper for
general readability and can be found in the Appendix at the end of this Report.
The Water Utility ended January with $67,300 in net operating income and compares to a $200
net operating loss for the same period in 2012.
0
200,000
400,000
600,000
800,000
1,000,000
1,200,000
1,400,000
JanFebMarAprMayJunJulAugSepOctNovDec
Water Revenues vs Water Sold
2013 vs 2012
2012 Water Sales ($)
2013 Water Sales ($)
2012 Water Sold (ccf)
2013 Water Sold (ccf)
14
Monthly Financial Report January 2013
The Sewer Utility ended the period with a $203,300 net operating loss and compares to a
$290,000 net loss for the same period in 2012.
The Stormwater Utility ended the period with $136,200 in net operating income which
compares to $100,800 in net income for the same period last year.
The number of rounds played at the Auburn Golf Course (AGC) in January totaled 1,277 which
compares to 1,125 for the same period last year. The AGC ended January with a net operating
loss of $86,200 compared to a loss of $84,900 for the same period last year.
0
50,000
100,000
150,000
200,000
250,000
300,000
JanFebMarAprMayJunJulAugSepOctNovDec
Golf Course Operating Revenues By Month
2013 vs 2012
2013 Budget
2013 Actual
2012 Actual
The Cemetery Fund ended January with $3,700 in net operating income compared to a $5,600
net operating loss for the same period last year.
0
20,000
40,000
60,000
80,000
100,000
120,000
JanFebMarAprMayJunJulAugSepOctNovDec
Cemetery Operating Revenues By Month
2013 vs 2012
2013 Budget
2013 Actual
2012 Actual
15
Monthly Financial Report January 2013
Internal Service Funds
Operating expenses within the Insurance Fund represents the premium cost-pool that will be
allocated monthly to other City funds over the course of 2013. As a result, this balance will
gradually diminish each month throughout the year. The Innovation & Technology Fund ended
with a net loss, reflecting the timing of expenses. No significant variances are reported in the
Facilities Fund or Equipment Rental Fund. Both funds have had sufficient revenues to cover year-
to-date expenses.
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 the report please
contact us at mchaw@auburnwa.gov or scoleman@auburnwa.gov.
16
Investment Purchase Purchase Maturity Yield to
Type Date Price Date Maturity
State Investment Pool Various 80,248,588$ Various 0.17%
KeyBank Money Market Various 10,342,061 Various 0.15%
US Treasury 05/04/1990 57,750 05/15/2016 5.72%
Total Cash & Investments 90,648,400$ 0.175%
Investment Mix % of Total
State Investment Pool 88.5%Current 6-month treasury rate 0.11%
KeyBank Money Market 11.4%Current State Pool rate 0.17%
US Treasury 0.1%KeyBank Money Market 0.15%
Blended Auburn rate 0.18%
100.0%
City of Auburn
Investment Portfolio Summary
January 31, 2013
Summary
17
SALES TAX SUMMARY
JANUARY 2013 SALES TAX DISTRIBUTIONS (FOR NOVEMBER 2012 RETAIL ACTIVITY)
2012 Annual Total 2012 YTD 2013 YTD YTD 2012 Annual Total 2012 YTD 2013 YTD YTD
NAICS CONSTRUCTION (Nov '11-Oct '12)(Nov '11)(Nov '12)% Diff NAICS AUTOMOTIVE (Nov '11-Oct '12)(Nov '11)(Nov '12)% Diff
236 Construction of Buildings 483,409 31,483 48,714 54.7%441 Motor Vehicle and Parts Dealer 2,795,164 206,933 201,889 -2.4%
237 Heavy and Civil Construction 114,823 16,401 5,278 -67.8%447 Gasoline Stations 223,463 16,414 17,814 8.5%
238 Specialty Trade Contractors 622,980 57,798 64,419 11.5%TOTAL AUTOMOTIVE 3,018,627$ 223,347$ 219,703$ -1.6%
TOTAL CONSTRUCTION 1,221,212$ 105,682$ 118,411$ 12.0%Overall Change from Previous Year (3,644)$
Overall Change from Previous Year 12,729$
2012 Annual Total 2012 YTD 2013 YTD YTD
2012 Annual Total 2012 YTD 2013 YTD YTD NAICS RETAIL TRADE (Nov '11-Oct '12)(Nov '11)(Nov '12)% Diff
NAICS MANUFACTURING (Nov '11-Oct '12)(Nov '11)(Nov '12)% Diff 442 Furniture and Home Furnishings 226,309 19,290 20,442 6.0%
311 Food Manufacturing 2,932 231 65 -72.1%443 Electronics and Appliances 145,391 10,748 22,032 105.0%
312 Beverage and Tobacco Products 5,855 320 539 68.7%444 Building Material and Garden 425,494 28,287 29,824 5.4%
313 Textile Mills 570 13 16 25.8%445 Food and Beverage Stores 341,379 29,048 26,942 -7.2%
314 Textile Product Mills 4,457 323 255 -21.0%446 Health and Personal Care Store 148,812 12,702 12,216 -3.8%
315 Apparel Manufacturing 218 13 23 79.8%448 Clothing and Accessories 772,153 68,391 71,683 4.8%
316 Leather and Allied Products 59 6 - -100.0%451 Sporting Goods, Hobby, Books 120,507 10,563 9,501 -10.0%
321 Wood Product Manufacturing 31,417 1,905 9,320 389.3%452 General Merchandise Stores 967,039 85,383 85,402 0.0%
322 Paper Manufacturing 3,944 272 187 -31.1%453 Miscellaneous Store Retailers 508,326 36,016 38,406 6.6%
323 Printing and Related Support 28,275 3,198 1,797 -43.8%454 Nonstore Retailers 268,503 23,682 30,070 27.0%
324 Petroleum and Coal Products 10,532 712 786 10.4%TOTAL RETAIL TRADE 3,923,913$ 324,109$ 346,517$ 6.9%
325 Chemical Manufacturing 8,089 487 579 18.9%Overall Change from Previous Year 22,408$
326 Plastics and Rubber Products 9,469 933 501 -46.3%
327 Nonmetallic Mineral Products 17,324 1,158 920 -20.5%
331 Primary Metal Manufacturing 1,766 - 2 N/A 2012 Annual Total 2012 YTD 2013 YTD YTD332Fabricated Metal Product Manuf 24,965 712 9,606 1249.3%NAICS SERVICES (Nov '11-Oct '12)(Nov '11)(Nov '12)% Diff
333 Machinery Manufacturing 12,890 1,189 1,102 -7.3%51*Information 396,353 32,011 35,160 9.8%
334 Computer and Electronic Produc 10,260 435 1,049 141.1%52*Finance and Insurance 53,291 6,038 10,544 74.6%
335 Electric Equipment, Appliances 426 25 41 66.4%53*Real Estate, Rental, Leasing 326,259 27,396 23,975 -12.5%
336 Transportation Equipment Man 187,175 (49,007) a 30,393 -162.0%541 Professional, Scientific, Tech 173,274 15,939 10,927 -31.4%
337 Furniture and Related Products 18,721 584 1,476 152.5%551 Company Management 16 1 0 -78.9%
339 Miscellaneous Manufacturing 25,368 1,427 1,978 38.6%56*Admin. Supp., Remed Svcs 334,354 18,414 19,696 7.0%
TOTAL MANUFACTURING 404,712$ (35,065)$ 60,633$ -272.9%611 Educational Services 53,672 2,573 1,754 -31.9%
Overall Change from Previous Year 95,699$ 62*Health Care Social Assistance 114,833 7,518 572 -92.4%
71*Arts and Entertainment 153,417 58,132 57,080 -1.8%
72*Accomodation and Food Svcs 920,556 67,198 75,883 12.9%
2012 Annual Total 2012 YTD 2013 YTD YTD 81*Other Services 388,279 27,547 28,587 3.8%
NAICS TRANSPORTATION AND WAREHOUSING (Nov '11-Oct '12)(Nov '11)(Nov '12)% Diff 92*Public Administration 142,188 6,444 4,923 -23.6%
481 Air Transportation - - - N/A TOTAL SERVICES 3,056,492$ 269,211$ 269,100$ 0.0%
482 Rail Transportation 19,182 487 2,566 426.5%Overall Change from Previous Year (111)$
484 Truck Transportation 10,245 811 393 -51.5%
485 Transit and Ground Passengers 268 - - N/A
488 Transportation Support 18,841 1,137 1,450 27.5%2012 Annual Total 2012 YTD 2013 YTD YTD
491 Postal Service 470 17 71 307.3%NAICS MISCELLANEOUS (Nov '11-Oct '12)(Nov '11)(Nov '12)% Diff
492 Couriers and Messengers 568 32 13 -60.4%000 Unknown 1 - - N/A
493 Warehousing and Storage 5,376 313 276 -11.9%111-115 Agriculture, Forestry, Fishing 2,868 96 222 131.7%
TOTAL TRANSPORTATION 54,952$ 2,798$ 4,768$ 70.4%211-221 Mining & Utilities 30,229 842 932 10.6%
Overall Change from Previous Year 1,970$ 999 Unclassifiable Establishments 27,601 1,744 4,515 158.9%
TOTAL SERVICES 60,699$ 2,682$ 5,668$ 111.4%
Overall Change from Previous Year 2,987$
2012 Annual Total 2012 YTD 2013 YTD YTD
NAICS WHOLESALE TRADE (Nov '11-Oct '12)(Nov '11)(Nov '12)% Diff
423 Wholesale Trade, Durable Goods 1,137,932 88,408 80,666 -8.8%GRAND TOTAL 13,037,326$ 990,770$ 1,115,152$ 424 Wholesale Trade, Nondurable 153,721 9,226 9,324 1.1%Overall Change from Previous Year 124,382$ 12.6%
425 Wholesale Electronic Markets 5,065 373 361 -3.1%
TOTAL WHOLESALE 1,296,718$ 98,006$ 90,352$ -7.8%
Overall Change from Previous Year (7,655)$
a. Wa. State Dept of Revenue audit adjustment to sales tax returns for period Nov 2011 (adjustment: -$73,971).
01/22/13 file:Monthly Sales Tax Report.xls
Prepared by Auburn Finance Department
18
INNOVATION EQUIPMENT
& TECHNOLOGY RENTAL
OPERATING REVENUES
Charges For Service 733,055.97 466,424.30 - 652,505.93 1,068,585.17 1,231.15 70,801.80 21,180.03 - - - -
Interfund Charges For Service - - - - - - - - - 290,816.00 398,140.00 242,677.00
Sewer Metro Service Revenue - - 1,008,167.06 - - - - - - - - -
Rents, Leases, Concessions, & Other - - - - - 49,073.03 - 13,427.06 - 17,332.48 6,300.00 -
TOTAL OPERATING REVENUES 733,055.97 466,424.30 1,008,167.06 652,505.93 1,068,585.17 50,304.18 70,801.80 34,607.09 - 308,148.48 404,440.00 242,677.00
OPERATING EXPENSES
Salaries & Wages 185,952.16 123,432.24 - 158,691.39 31,578.93 1,625.41 36,273.84 46,096.11 - 53,162.24 113,090.06 37,421.37
Benefits 83,503.55 53,713.12 - 68,686.03 13,873.86 554.88 15,747.95 22,739.80 - 23,895.38 46,717.40 17,019.22
Supplies 3,472.56 469.38 - 1,083.12 78.66 - 3,106.88 5,529.70 - 11,414.02 27.60 2,029.77
Other Service Charges 115,168.94 264,156.82 - 60,022.13 64,192.32 72,116.25 2,510.14 7,074.55 844,412.00 60,262.80 345,448.62 23,922.94
Intergovernmental Services - - - 657.00 - - - - - - - -
Waste Management Payments - - - - 15.00 - - - - - - -
Sewer Metro Services - - 1,199,585.15 - - - - - - - - -
Interfund Operating Rentals & Supplies 92,392.00 80,801.00 - 106,983.00 15,075.00 - 4,683.00 13,708.00 - 9,934.00 25,142.00 20,625.00
Other Expenses - - - - - - - - - - - -
Depreciation & Amortization 185,227.38 147,125.31 - 120,199.02 1,568.27 33,360.63 4,806.93 25,680.12 - - 39,526.40 67,255.35
TOTAL OPERATING EXPENSES 665,716.59 669,697.87 1,199,585.15 516,321.69 126,382.04 107,657.17 67,128.74 120,828.28 844,412.00 158,668.44 569,952.08 168,273.65
OPERATING INCOME (LOSS)67,339.38 (203,273.57) (191,418.09) 136,184.24 942,203.13 (57,352.99) 3,673.06 (86,221.19) (844,412.00) 149,480.04 (165,512.08) 74,403.35
NON-OPERATING REVENUES & EXPENSES
Interest Revenue 1,637.80 1,870.60 1.86 1,418.64 106.17 140.92 30.32 59.71 168.36 248.28 425.07 795.04
Contributions - - - - 54,267.75 - - - - - - -
Other Non-Operating Revenue - 109,700.00 - - - (16,167.40) - - - - - 6,294.33
Gain (Loss) On Sale Of Fixed Assets - - - - - - - - - - - -
Debt Service Interest - - - - - - - - - - - -
Other Non-Operating Expense - - - - - - - - - - - -
TOTAL NON-OPERATING REVENUES & EXPENSES 1,637.80 111,570.60 1.86 1,418.64 54,373.92 (16,026.48) 30.32 59.71 168.36 248.28 425.07 7,089.37
PLUS ITEMS NOT EFFECTING WORKING CAPITAL
Depreciation 185,227.38 147,125.31 - 120,199.02 1,568.27 33,360.63 4,806.93 25,680.12 - - 39,734.65 67,255.35
NET WORKING CAPITAL FROM OPERATIONS 254,204.56 55,422.34 (191,416.23) 257,801.90 998,145.32 (40,018.84) 8,510.31 (60,481.36) (844,243.64) 149,728.32 (125,352.36) 148,748.07
Increase In Contributions - System Development 1 43,632.00 2,095,550.00 - 42,994.00 - - - - - - - -
Increase In Contributions - Area Assessments - - - - - - - - - - - -
Increase In Contributions - Other Governments - - - - - - - - - - - -
Increase In Contributions - Other Funds - - - - - - - - - - - -
Increase In Contributions - FAA - - - - - 2,872.47 - - - - - -
Proceeds of Debt Activity - - - - - - - - - - - -
Operating Transfers In - - - - - - - 1,059.00 - - - -
Increase In Restricted Net Assets 896.52 5,412.56 - - - 1,631.33 - - - - - -
Decrease In Long-Term Receivables - - - - - - - - - - - -
Increase In Deferred Credits - - - - - 18,730.97 - - - - - -
TOTAL RESOURCES OTHER THAN OPERATIONS 44,528.52 2,100,962.56 - 42,994.00 - 23,234.77 - 1,059.00 - - - -
Net Change In Restricted Net Assets 174.18 60.35 - 122.84 - 2,287.12 - 2,187.46 - - - -
Increase In Fixed Assets - Salaries 22,266.16 3,502.76 - 12,400.57 - - - - - - - -
Increase In Fixed Assets - Benefits 9,335.69 1,623.65 - 5,571.41 - - - - - - - -
Increase In Fixed Assets - Site Improvements - - - - - - - - - - 208.25 -
Increase In Fixed Assets - Equipment - - - - - - - - - - - 13,115.91
Increase In Fixed Assets - Construction 54,451.86 - - 322.62 - - - - - - - -
Operating Transfers Out 50,000.00 50,000.00 - 50,000.00 - - - - - - - 7,000.00
Debt Service Principal - - - - - - - - - - - -
TOTAL USES OTHER THAN OPERATIONS 136,227.89 55,186.76 - 68,417.44 - 2,287.12 - 2,187.46 - - 208.25 20,115.91
NET CHANGE IN WORKING CAPITAL 162,505.19 2,101,198.14 (191,416.23) 232,378.46 998,145.32 (19,071.19) 8,510.31 (61,609.82) (844,243.64) 149,728.32 (125,560.61) 128,632.16
BEGINNING WORKING CAPITAL - January 1, 2013 10,196,281.10 12,072,579.09 - 10,218,848.21 1,018,487.34 818,912.00 182,098.05 90,691.62 2,028,681.08 1,473,040.96 2,885,527.19 5,559,564.94
ENDING WORKING CAPITAL - January 31, 2013 10,358,786.29 14,173,777.23 (191,416.23) 10,451,226.67 2,016,632.66 799,840.81 190,608.36 29,081.80 1,184,437.44 1,622,769.28 2,759,966.58 5,688,197.10
NET CHANGE IN WORKING CAPITAL 162,505.19 2,101,198.14 (191,416.23) 232,378.46 998,145.32 (19,071.19) 8,510.31 (61,609.82) (844,243.64) 149,728.32 (125,560.61) 128,632.16
ENTERPRISE FUNDS INTERNAL SERVICE FUNDSWORKING CAPITAL
The following table presents the Working Capital Statement for each of the City's Enterprise and Internal Service funds. Working Capital is generally defined as the difference between current assets and current liabilities.
CEMETERY GOLF INSURANCE FACILITIESWATERSEWERSEWER METRO STORM SOLID WASTE AIRPORT
19
INNOVATION EQUIPMENT
& TECHNOLOGY RENTAL
OPERATING REVENUES
Charges For Service 733,055.97 466,424.30 - 652,505.93 1,068,585.17 1,231.15 70,801.80 21,180.03 - - - -
Interfund Charges For Service - - - - - - - - - 290,816.00 398,140.00 242,677.00
Sewer Metro Service Revenue - - 1,008,167.06 - - - - - - - - -
Rents, Leases, Concessions, & Other - - - - - 49,073.03 - 13,427.06 - 17,332.48 6,300.00 -
TOTAL OPERATING REVENUES 733,055.97 466,424.30 1,008,167.06 652,505.93 1,068,585.17 50,304.18 70,801.80 34,607.09 - 308,148.48 404,440.00 242,677.00
OPERATING EXPENSES
Administration 212,489.39 165,597.05 - 201,585.55 54,565.00 74,296.54 26,216.29 19,147.57 844,412.00 - - 63,359.22
Operations & Maintenance 267,999.82 356,975.51 - 194,537.12 70,233.30 - 36,105.52 76,000.59 - 158,668.44 530,425.68 37,659.08
Waste Management Payments - - - - 15.00 - - - - - - -
Sewer Metro Services - - 1,199,585.15 - - - - - - - - -
Depreciation & Amortization 185,227.38 147,125.31 - 120,199.02 1,568.27 33,360.63 4,806.93 25,680.12 - - 39,526.40 67,255.35
TOTAL OPERATING EXPENSES 665,716.59 669,697.87 1,199,585.15 516,321.69 126,381.57 107,657.17 67,128.74 120,828.28 844,412.00 158,668.44 569,952.08 168,273.65
OPERATING INCOME (LOSS)67,339.38 (203,273.57) (191,418.09) 136,184.24 942,203.60 (57,352.99) 3,673.06 (86,221.19) (844,412.00) 149,480.04 (165,512.08) 74,403.35
NON-OPERATING REVENUES & EXPENSES
Interest Revenue 1,637.80 1,870.60 1.86 1,418.64 106.17 140.92 30.32 59.71 168.36 248.28 425.07 795.04
Other Non-Operating Revenue - 109,700.00 - - 54,267.75 (16,167.40) - - - - - 6,294.33
Gain (Loss) On Sale Of Fixed Assets - - - - - - - - - - - -
Other Non-Operating Expense - - - - - - - - - - - -
TOTAL NON-OPERATING REVENUES & EXPENSES 1,637.80 111,570.60 1.86 1,418.64 54,373.92 (16,026.48) 30.32 59.71 168.36 248.28 425.07 7,089.37
68,977.18 (91,702.97) (191,416.23) 137,602.88 996,577.52 (73,379.47) 3,703.38 (86,161.48) (844,243.64) 149,728.32 (165,087.01) 81,492.72
Contributions 1 43,632.00 2,095,550.00 - 42,994.00 - 2,872.47 - - - - - -
Transfers In - - - - - - - 1,059.00 - - - -
Transfers Out (50,000.00) (50,000.00) - (50,000.00) - - - - - - - (7,000.00)
TOTAL CONTRIBUTIONS & TRANSFERS (6,368.00) 2,045,550.00 - (7,006.00) - 2,872.47 - 1,059.00 - - - (7,000.00)
CHANGE IN FUND BALANCE 62,609.18 1,953,847.03 (191,416.23) 130,596.88 996,577.52 (70,507.00) 3,703.38 (85,102.48) (844,243.64) 149,728.32 (165,087.01) 74,492.72
BEGINNING FUND BALANCE - January 1, 2013 67,719,034.00 74,779,493.00 - 49,964,488.00 1,128,442.00 9,439,263.00 872,103.00 8,578,904.00 2,028,681.00 1,415,971.00 4,069,294.00 10,502,921.00
ENDING FUND BALANCE - January 31, 2013 67,781,643.18 76,733,340.03 (191,416.23) 50,095,084.88 2,125,019.52 9,368,756.00 875,806.38 8,493,801.52 1,184,437.36 1,565,699.32 3,904,206.99 10,577,413.72
1 Sewer contributions reflect System Development Charges resulting from the Goedecke land swap agreement with the WA Department of Transportation.
FUND BALANCE ENTERPRISE FUNDS INTERNAL SERVICE FUNDS
The following table provides an analysis of each of the City's Enterprise and Internal Service funds - showing 2013 revenues and expenditures by fund.
INCOME (LOSS) BEFORE CONTRIBUTIONS &
TRANSFERS
CEMETERY GOLF INSURANCE FACILITIESWATERSEWERSEWER METRO STORM SOLID WASTE AIRPORT
20