HomeMy WebLinkAboutSeptember 2010
A TY OF N UBUR AGENDA BILL APPROVAL FORM
WASHINGTON
Agenda Subject: September 2010 Financial Report Date: 11/12/2010
Department: Finance Attachments: September Monthly Budget Impact: 0
Report
Administrative Recommendation:
Background Summary:
The September 2010 status report highlights City revenues and expenditures and is based on
financial data available as of October 21, 2010. Sales tax reported in September is for business
activities that occurred in July 2010.
Total General Fund revenues for the City at the end of September were $36,840,651 which is
approximately 74% of the annual budgeted revenues. Compared to budgeted year-to-date
revenues, total General Fund revenue is $1.17M (3.3%) more primarily due to the receipt of
proceeds from general long term debt of $1,069,000 resulting from the Valley Communications
bond refunding that will be included in the next budget amendment.
Expenditures for the General Fund totaled $36,927,910 which is $3.74M (9.2%) under budget at
the end of September. This is due to the timing of utility and intergovernmental payments along
with professional services that are paid later in the year.
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 El Legal E) 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: Backus Staff: Coleman
Meeting Date: November 15, 2010 Item Number:
AUBURN *MOPE THAN YOU IMAGINED
1
Monthly Financial Report September 2010
General Fund 2010 2010 YTD Budget vs. Actual
Summary of Sources and Uses Favorable (Unfavorable)
Annual Budget YTD Budget YTD Actual Amount Percentage
OPERATING REVENUES
Property Tax 12,357,309 6,646,200 6,880,705 234,505 3.5%
Sales Tax (1) 14,255,000 10,762,300 10,803,828 41,528 0.4%
Sales Tax - Annexation Credit 1,453,500 1,090,200 1,035,099 (55,101) -5.1%
Criminal Justice Sales Tax 1,143,300 857,400 933,370 75,970 8.9%
Brokered Natural Gas Tax 260,000 202,700 213,537 10,837 5.3%
City Utilities Tax 2,140,200 1,686,600 1,787,469 100,869 6.0%
Admissions Tax 400,000 320,200 275,644 (44,556) -13.9%
Electric Tax 2,794,100 2,184,500 2,305,154 120,654 5.5%
Natural Gas Tax 1,245,500 1,125,600 867,960 (257,640) -22.9%
Cable TV Franchise Fee 676,300 506,900 582,815 75,915 15.0%
Telephone Tax 1,934,200 1,429,900 1,570,419 140,519 9.8%
Garbage Tax (external) 156,000 117,300 116,880 (420) -0.4%
Leasehold Excise Tax 80,000 68,200 20,686 (47,514) -69.7%
Gambling Excise Tax 466,500 371,500 196,868 (174,632) -47.0%
Business License Fees 200,000 185,400 114,632 (70,768) -38.2%
Building Permits 700,000 560,400 586,102 25,702 4.6%
Other Licenses & Permits 228,800 164,200 250,789 86,589 52.7%
Intergovernmental (Grants, etc) 4,524,940 3,500,400 2,837,640 (662,760) -18.9%
Charges for Services:
General Government Services 81,000 62,200 75,488 13,288 21.4%
Public Safety 244,000 192,500 175,867 (16,633) -8.6%
Development Services Fees 702,000 584,300 475,594 (108,706) -18.6%
Culture and Recreation 789,000 664,200 733,661 69,461 10.5%
Fines and Forfeits 2,107,400 1,584,700 1,948,050 363,350 22.9%
Interests and Other Earnings 170,000 144,500 115,348 (29,152) -20.2%
Rents, Leases and Concessions 543,000 488,100 547,990 59,890 12.3%
Contributions and Donations 51,600 34,300 47,663 13,363 39.0%
Other Miscellaneous 46,200 34,000 156,013 122,013 358.9%
Proceeds of Gen. Long Term Debt-Refi Valley Com 1,069,000 1,069,000 N/A
Transfers In 61,300 61,300 61,300 0.0%
Insurance Recoveries- Capital & Operating 55,000 41,300 54,782 13,482 32.6%
Total Operating Revenues 49,866,149 35,671,300 36,840,351 1,169,051 3.3%
Operating Expenditures
Council & Mayor 738,900 565,000 494,687 70,313 12.4%
Municipal Court & Probation 3,055,280 2,255,480 1,997,234 258,246 11.4%
Human Resources 736,150 578,050 513,101 64,949 11.2%
Finance 1,170,960 875,960 819,025 56,935 6.5%
City Attorney 1,675,050 1,294,850 1,193,669 101,181 7.8%
Planning 3,587,170 2,863,170 2,430,563 432,607 15.1%
Community & Human Services 1,070,400 744,200 628,272 115,928 15.6%
Police 23,650,215 17,331,315 15,874,568 1,456,747 8.4%
Engineering 2,599,010 2,008,810 1,791,818 216,992 10.8%
Parks and Recreation 6,801,200 5,149,500 4,918,740 230,760 4.5%
Streets 3,093,500 2,355,900 1,955,678 400,222 17.0%
Non-Departmental 7,190,700 4,649,600 4,310,554 339,046 7.3%
Total Operating Expenditures 55,368,535 40,671,835 36,927,910 3,743,925 9.2%
(1) The anticipated Streamlined Sales Tax Mitigation for 2010 is $1,966,775. The year to date actual sales tax amount
is adjusted to include $1,466,620 SST Mitigation the City received from the State through 31d quarter of 2010.
2
Monthly Financial Report September 2010
Overview
This financial overview reflects the City's overall financial position for the fiscal year through
September 30, 2010. The budgeted year to date revenues and operating expenditures are
primarily based on the collection/disbursement for the same period of 2009. The table on the
previous page summarizes the general fund revenues and expenditures.
Revenues
Taxes
In September, the combined collection of property tax, sales/use tax, utility tax, gambling, and
admissions tax represents 75% of all resources supporting general governmental activities. The
following section provides detail information on property and sales taxes.
Property Tax
Year to date collection at the end of September is $6,880,705 or 55.7% of the $12,357,309
annual budget. Compared to 2009, the City collected $1,178,753 or 20.7% more for the same
period. At the end of the September, property tax revenue is $234,505 or 3.5% more than the
year to date budget and is in line with the budget.
Property Tax Revenue
Year to Date through September
2009 2010 2010 2010 vs. 2009 2010 vs. Budget
Month Actual Budget Actual Amount Percentage Amount Percentage
Jan 38,602 45,000 27,735 (10,867) -28.2% (17,265) -38.4%
Feb 111,495 130,000 131,275 19,780 17.7% 1,275 1.0%
Mar 222,173 259,000 294,363 72,190 32.5% 35,363 13.7%
Apr 4,188,834 4,882,400 4,877,655 688,822 16.4% (4,745) -0.1%
Ma 852,588 993,800 1,200,112 347,524 40.8% 206,312 20.8%
Jun 37,763 44,000 76,369 38,606 102.2% 32,369 73.6%
Jul 21,078 24,600 29,190 8,112 38.5% 4,590 18.7%
Au 32,632 38,000 54,328 21,696 66.5% 16,328 43.0%
Se 196,787 229,400 189,677 (7,110) -3.6% (39,723) -17.3%
Oct 3,836,015 4,471,109
Nov 1,017,258 1,185,700
Dec 46,566 54,300
YTD Total 5,701,951 6,646,200 6,880,705 1,178,753 20.7% 234,505 3.5%
Annual Total 10,601,791 12,357,309
3
Monthly Financial Report September 2010
Sales Tax
At the end of September, the year to date sales tax revenue of $10,803,828 is $378.6K more
than 2009 and $41.5K more than the current YTD budget.- Also at the end of 3rd quarter, the
City has received $1,466620 of the total anticipated SST mitigation of $1,966,775 for 2010. The
actual amount of Streamlined Sales Tax mitigation the City will receive from the State is reduced
by taxes received from companies that have voluntarily complied with the new destination based
sales tax.
Sales & Use Tax Revenue
Year'to Date through September
2009 2010 2010 2010 vs. 2009. 2010 vs. Budget
Month Actual Budget Actual, Amount Percentage Amount'. Percentage
Jan 1;232,999.. 1;213,000 1128,608 (104,391) -8.50/6 . (84,392):. -7.0%
Feb 1;279,532 1,372,300.: 1,303,518. 23;985 1.9% (68;782) 5.0%
Mar 1,059,642 1,085,700: 1,012,173 (47,469) 4.5% (73,527) 6:8%
Apr 1,041,972 1,066,300' . 1,495,567 .453,595,' 43.5% 4291'267 40.3%
May 1,161,471. 1,249,400. 1,190,0217 28,550 2.5% (59,379) -4.8%
Jun 1,098,038 1,144,900 1,045,316 (52,722) 4.8% (99,584), -8.7%
Jul 1,152,738. 1,180,300. 1,104,591 (48,147) -4.2% (75,709) -6.4%
Au 1,250,264 1,302,700 1,302;641. 52,377 4.2% (59) 0.0%
Se 1,148,525 1,147,700 1;221,393 72,868 6.3% 73,693 6.4%
Oct 1,254,457 1,200,400 -
Nov 1,197,153 1,175,200
Dec 1,065,935 1,117,100
YTD Total- 10,425,182 10,762;300" 10,803,828 • ,378,646- 3:6% 41,528" 0.4%
Annual Total 13,942,728 14,255,000
*Includes Sales Tax Mitigatiomprorated monthly.
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.
Comparison of Sales Tax Collections by SIC Group
Year to Date through September
2009 2010 Change from 2009
Component Group Actual Actual Amount Percentage
New Construction.' - 981,143 -927,864 (53,279) -5.4%
Manufacturing 296;380 < 296,240. (140) 0.0%
Transportation & Warehousing 251298. 21,684 (3,614) -14.3%
Wholesale Trade 786,699 848;720 62,021, 7.9%
Automotive 1;870,891 1,875,315 4,424 0.2%
Retail Trade 2,710,152 2,673,466 (36,686) -1.4%
Services 2,191,360 2,603,815 412,455 18.8%
Miscellaneous 31,138 108,031 76,893 246.9%
YTD Total 81-893,061, 9,355,135. 462,074
4
Monthly Financial Report September 2010
Utility Tax
This revenue source consists of City inter-fund utility taxes (Water, Sewer, Storm and Solid Waste)
and external utility taxes (Electric, Natural gas, Telephone and Solid Waste). Year to date utility
tax revenue is $6,647,882 which is $922K (12.2%) less than 2009 primarily due to the City
Interfund utility taxes and a decrease in the Natural Gas utility tax. There was a temporary
increase in the City inter-fund tax for Solid Waste from November 2008 through October 2009.
In addition, record breaking warm winter temperatures in 2010 contributed the decrease in the
Natural Gas utility tax. Overall, the 2010 actual revenues are greater by $103.9K or 1.6% more
than budgeted tax revenues. The main source of this increase is attributed to higher revenues
from the telephone and electric utility tax.
Utility Tax Revenues
Year to Date through September
2009 2010 2010 2010 vs. 2009 2010 vs. Budget
Month Actual Budget Actual Amount Percentage Amount Percentage
Jan 1,329,027 1,198,800 1,258,792 (70,236) -5.3% 59,992 5.0%
Feb 592,186 482,100 483,456 (108,730) -18.4% 1,356 0.3%
Mar 304,496 223,800 416,213 111,717 36.7% 192,413 86.0%
Apr 1,911,964 1,758,200 1,505,874 (406,090) -21.2% (252,326) -14.4%
May 575,114 469,900 492,247 (82,867) -14.4% 22,347 4.8%
Jun 441,229 345,000 365,171 (76,058) -17.2% 20,171 5.8%
Jul 1,340,355 1,204,500 1,303,301 (37,054) -2.8% 98,801 8.2%
Au 621,691 504,300 458,060 (163,631) -26.3% (46,240) -9.2%
Se 453,881 357,300 364,769 (89,112) -19.6% 7,469 2.1%
Oct 1,123,629 987,100
Nov 516,516 433,900
Dec 376,459 305,100
YTD Total 7,569,943 6,543,900 6,647,882 (922,062) -12.2% 103,982 1.6%
Annual Total 9,586,547 8,270,000
The following table presents utility tax by source:
Utilty Tax by Type
Year to Date through September
2009 2010 2010 2010 vs. 2009 2010 vs. Budget
Month Actual Budget Actual Amount Percentage Amount Percentage
City Interfund Utility Taxes 2,420,313 1,686,600 1;787,469 (632,844) -26.1% 100,869 6.0%
Electric 2,346,398 2,184,500 2,305,154 (41,245) -1.8% 120,654 5.5%
Natural Gas 1,118,118 1,125,600 867,960 (250,158) -22.4% (257,640) -22.9%
Telephone 1,571,092 1,429,900 1,570,419 (673) 0.0% 140,519 9.8%
Solid Waste 114,022 117,300 116,880 2,858 2.5% (420) -0.4%
YTD Total 7,569,943 6,543,900 6,647,882 (922,062) -12.2% 103,982 1.6%
Annual Total 9,586,547 8,270,000
5
Monthly Financial Report September 2010
Cable TV Franchise Fees are received quarterly and are shown on the table below. This is
$23.4K or 4.2% more than the previous year for the same period and is $75.9K or 15.0%
greater than the 2010 year to date budget.
Cable TV Franchise Fee
Year to Date through September
2009 2010- 2010 2010 vs. 2009 2010 vs. Budget
Month Actual Bud et - Actual Amount Percents a Amount Percentage
Jan 188,592 170,900 (188,592) -100.0% (170,900) -100.0%
Feb - - 193,004 193,004 N/A 193,004 N/A
Mar - - N/A N/A
Apr - - 194,032 194,032 N/A 194,032 N/A
May 184,011 166,800 , (184,011) -100.00/c; (166,800) -100.0%
Jun - - - - N/A - N/A
Jul 186,766 169,200 195,778 9,012, 4.8% 26,578 15.7%
Au - - N/A - N/A
Se - N/A - N/A
Oct 186,910 169,400
Nov -
Dec -
YTD Total 559,370 506,900 582,815 23,445 4.2% 77915 15.07
Annual Total 746,280, 676,300
Licenses and Permits
This revenue source is comprised of business licenses, building permits, plumbing, electric and
other licenses and permit fees. At the end of September, the City has collected 84.3% of the
annual projected revenue from licenses and permits. Building permit fees and Business licenses
make up 80% of the annual budgeted revenue in this category and the following tables present
detail information for each.
Building Permits
Year to Date through September
2009 2010 2010. 2010 vs. 2009 2010 vs. Budget
Month Actual Budget Actual Amount Percents a Amount Percentage
Jan 17,047 69,800 88,175 71,128 417.2% - 18,375- 25.3%
Feb 30,070 30,500 49,731 19,661 65.4% 19,231 63.1%
Mar 34,273: 84,000 43,796 9,523 27.8% (40,204) -47.9%
Apr 85,717 51,800, 44,422 (41,295) -48.2% (7,378) -14.2%
May 44,732 47,100, 96,244 51,512 115.2% 49,144 104.3%
Jun 158,105 49,800 74,701 (83,404) -52.8% 24,901 50.0%
Jul 90,765 62,900 72,745 (18,020) -19.9% 9,845 15.7%
Au 54,856, 96,200 61,216 6,360 11.6% (34,984) -36.4%
Se .42,615 68,300 55;073 12,458 29.2% (13,227) =19.4%
Oct 83,041. .45,300
Nov 56,606 38,200
Dec - 137,651 56,100
Y .D Total 558,180 560,400 586,102 '27,922 -25,702 4.67
Annual Total 835,478 700,000
6
IMonthly Financial Report September 2010
t Total building permit revenues at the end of September were $586,102. This was $27.9K greater .
than 2009 for the same period and $25.7K or 4.6% more than budgeted revenues in 2010. The
temporary increase in June & July of 2009 was primarily due to the developments at Trail Run
and North Tapps Estates.
Business License revenues at the end of September were $79.1K or 40.8% less than 2009 and
$70.8K or 38.2% less than the 2010 year to date budget. This revenue source is lower in
comparison to 2009 and the year to date budget due toa change in timing of payments. In
prior years, payments received mid year were for a 12 month period. In 2010 these payments
are only for the last 6 months of the year. Business license fees will be billed again in December
to cover a full year in 2011.
Business License
Year to Date through Septmber
2009 2010 2010 2010 vs. 2009 2010 vs. Budget
Month Actual Budget Actual Amount Percentage Amount . Percentage
Jan 6,626 6,300 3,945 (2,681) -40.5% (2,355) -37.4%
Feb 4,258 4,100 4,347 89 2.1% 247 6.-0%
Mar 4,706' 4,500 3,627. (1,079) -22.9% (873) -19.4%
Apr 3,952 3,800 4,342 390 9.9% 542 14.3%
May 4,289 4,200 1,987 .(2,303) -53.7% (2,214) -52.7%
Jun 102,500 98,000 22,171, (80,330) =78.4% (75,830) -77.4%
Jul 49:110 47,000 53,961 4,851 9.9% 6,961 14.8%
Au 12,061 11,500 13,403 1,342 11:1% 1,903 16.5%
Se 6,271 6,000 6,850 579 9.2% 850 14.2%
Oct 6,277 6,000
Nov 5,229 5,000
Dec 3;810 3,600
YTD Total 193,773 185,400 114,632 (79,141) -40.8% (70,768) -38.2%
Annual Total 209,089 200,000
Intergovernmental
Revenues in this category include Grants (Direct & Indirect Federal, State and Local), State shared
revenues and compact revenue from the Muckleshoot Indian Tribe. At the end of September
Intergovernmental revenues are less than 2009 and YTD budget because the quarterly revenue
for the Muckleshoot compact has not been received as it is currently being negotiated. Timing of
rant revenue varies as the are processed on a'reimbursement basis.
Intergovernmental
Year to Date through September
2009 2010 2010 2009 vs 2010 2010 vs.Bud et
Revenue Actual - 'Budget Actual % Change % Change
Federal Grants 51,478 193,800 331,879 544.7% 71.2%
State Grants 87,878 59,600 94,141 7.1% 58.0%
Interlocal Grants 206,255 109,400 110,038 -46.6% 0.6%
State Shared Revenue 1,851,407 1,955,355 1,933,351 4.4% -1.1%
Muckleshoot Casino Emer . 1,059,688 742,100 368,231 -65.3% -50.4%
YTD Total 3,256,706 3,060,255 2,837,640 -12.9% -7.3%
Annual Total 4,499,411 4,524,940
YTD % 72% 68% 63%
7
l
' I
Monthly Financial Report September 2010
Total state shared revenues are greater than 2009 actual for the same period due to higher liquor
profits and the new revenue source for Criminal Justice-High crime. Based on crime statistics,
beginning on July 2010 the City will receive this revenue in place of Criminal Justice- population.
This revenue source is low compared to the 2010 budget due to less than anticipated motor
vehicle fuel tax and liquor profits receipts.
State Shared Revenues
Year to Date through September
2009 2010 2010 2010 vs. 2009 2010 vs. Budget
Revenue Actual Budget Actual Amount Percentage Amount Percentage
Trial Court Improvements 12,395 16,700 16,999 4,604 37.14% 299 1.79%
Court Interpreter Program 12.271 (12,271) -100.00% - N/A
Motor Vehicle Fuel Tax 1,075;658 1,124,955 1,078,395 2,736 0.3% (46,560) -4.1%
Criminal Justice -High Crime - 37,276 37,276 N/A 37,276 N/A
Criminal Justice -Population . 49,605 51,300 37,878 11,727 -23.6% (13,422 -26.2%
Criminal Justice -Spec. Pro g. 41,050 24,600 42,497 1,448 3.5% 17,897 72.8%
State DUI 9,138 3,000 9,409 271 3.0% 6,409 213.6%
Fire Insurance Premium Tax .59,677 60,000 63,545 3;868 6.5% 3,545 5.9%
Liquor Excise Tax 237,591 238,400 244,986 7,396 3.1% 6,586 2.8%
Liquor Profits 354,023 436,400 402,365 48343 13.7% (34,035 -7.8%
YTD Total 1,851,407 1,955,355 1,933,351 81,944 4.4% (22,004) -1.1%
Annual Total -2,465,986 2,594,740
Charges for Services
This revenue source consist of general governmental services, public safety, development service
fees and cultural & recreation fees. Development services and culture & recreation revenues make
up approximately 82% of the $1,816,000 annual budget for this category and are presented
following the Charges for Service table below. At the end of September $1,460,609 or 80% of
the annual budget has been received for all charges for services.
General government services include passport services, administrative fees, court duplicating costs
and sale of maps & publications. This revenue-source is low compared to 2009 primarily because
the City received $12,394 for court services from the City of Algona in January 2009 for prior
year services. The mid year budget amendment included a reduction for City of Algona court
charges since the City of Auburn is no longer collecting this revenue as Algona's court cases are
now being handled by the City of Pacific.
Public Safety consists of law enforcement services, probation and prisoner lodging fees; overall
this revenue source is 8.6% less than budget at the end of September due to decreased probation
revenues and law enforcement service revenue related to the.amphitheater events. Probation
fees account for $147.1K of the $175.9K received to date for this category.
Charges for Services by Type
Year to Date through September
2009 2010 2010 2010 vs. 2009 2010 vs. Budget'
Revenue Actual Budget Actual Amount Percentage Amount Percentage
General Government 83,831 62,200- 75,488 (8,343) -9.95% 13,288 21.36%
Public Safety 198,371 192,500 175,867 (22,504) 11.3% (16,633) -8.6%
Development Services 411,568 584,300 475,594 64,026 15.6% 108,706) -18.6%
Culture & Recreation 700,566 664,200 733,661 33,095 4.7% 69,461 10.5%
YTD Total 1,394,336 1,503,200 11460,609 66,273 4.8% (42,591) 2.8%
Annual Total 1,683,495 1,816,000
l
8
Monthly Financial Report September 2010
Development Services include Engineering fees, zoning & subdivision fees and plan check fees. At
the end of September, year to date revenues totaled $475,594 and is 15.6% or $64K more than
the same period in 2009. This is due to the receipt of plat security funds for the North Tapps
Estates development.and plan check fees for an addition to the Auburn public library and new
hotel within the City. Total development service revenue is less than the budget for the year by
$108.7K or 18.6% due to lower than anticipated engineering fees and plan check fee revenues.
We will continue to monitor these revenue sources and adjust budget as needed.
Development Service Fees .
Year to Date through September
2009 2010 2010 2010 vs. 2009 2010 vs.' Budget
Month Actual Budget Actual Amount Percentage'
ercenta a Amount Percentage
Jan 51,833 73,600 39,755 (12,078) -23.3% (33,845) -46.0%
Feb 46,818 66,500 53,677 6,859 14.7% (12,823) -19.3%
Mar 29,147 41,400 82,904 53,757 184.4% 41,504 100.3%
Apr 45,238 64,200 28,762 (16,476) -36.4% (35,438) -55.2%
May 23,450 33,300 18,069 (5,381) -22.9% (15,231) -45.7%
Jun 86,974 123,500 38,276 (48,698) -56.0% (85,224) -69.0%
Jul 42,644 60,500 439402 758 1.8% (17,098) -28.3%
Au 53,060 75,300 70,844 17,784 33.5% (4,456) -5.9%
Se 32,404 46,000 99,904. 67,500 208.3% 53,904 117.2%
Oct 15,079 21,400
Nov 26,650 37,800-
Dec 41,227 58,500
YTDTotal. 411,568 584,300 475,594 64,026 15.6% (108,706) -18.6%
Annual Total 494,524 702,000
Culture & Recreation revenues consist of theater ticket sales,,recreational classes, arts commission
and senior citizen program fees. Total revenue at the end.of September shows an increase of
$33.1K from 2009 and $69.5K greater than 2010 YTD budget. September increases are mainly
due to success of the around the bell before & afterschool programs and adult fitness programs.
Culture & Recreation
Year to Date through September
2009 2010 2010 2010 vs. 2009 2010 vs. Budget
Month Actual Budget Actual Amount Percentage Amount Percentage
Jan 71,561 67,900 65,917 (5,644) -7.9% (1,983) -2.9%
Feb 51,878 49,200 57,959, 6,081 11.7% 8,759 17.8%
Mar 124,525 118,100 133,930 9,405 7.6% 15,830 13.4%
Apr 81;520 77;200 69,877 (11,643) -14.3% (7,323) -9.5%
May 75,505 71,600 70,119 (5,386) -7.1% (1,481) -2.1%
Jun 90,011 85,300 109,364 19,353 21.5% 24,064 28.2%
Jul 77,622 73,600 89,315 11,693 15.1% 15,715 21.4%
Au 66,639 63,200 76,531 9,892 14.8% 13,331 21.1%
Se 61,305 58,100 60,648 (657) -1.1% 2,548 4.4%
Oct 41,086 39,000
Nov 44,066 41,800
Dec 46,428 44,000
YTD Total. 700,566 664,200 '733,661 33,095 4J% 69,461 10.50
Annual Total 832,146 789,000
9
Monthly Financial Report September 2010
Fines & Penalties
This revenue category includes traffic and parking infraction penalties, criminal (traffic, non traffic
and costs) false alarm and shopping cart fines. Year to date, this revenue source is $531,267 or
37.5% greater than 2009 for the same period and $363,350 or 22.9% higher than the projected
budget.. The overall increase is primarily due to the rise in the traffic infraction and photo
enforcement revenues. Criminal non-traffic fees and Traffic infraction revenues were also
budgeted conservatively and contributed to the overall increase between the year to date actual
revenues and budget.
Fines & Forfeits by Month
Year to Date through September
2009 2010 2010 2010 vs. 2009 2010 vs. Budget
Month Actual Budget Actual Amount Percentage Amount Percentage
Jan 148,141 173,900' 236,675 88,534 59.8% .62,775 36.1%
Feb 153,213 179,200 223,295 70,082 45.7% 44,095 24.6%
Mar 168,348 190,800 252,739 84,391 50.1% 61,939 32.5%
Apr 165,420 177,100 239,856 74,436 45.0% 62,756, 35.4%
May 174,475 187,700 228,603 54,128 31.0% 40,903 21.8%
Jun' '168,280 181,500 204,577 36,297 21.6% 23,077 12.7%
Jul 159,112 183,500 219,109 59,997 37.7% 35,609 19.4%
Au 144,593 164,000 177,615 33,022 22.8% 13,615 8.3%
Se 135,201 147,000 165,581 30,380 22.5% 18,581 12.6%
Oct 140,945 150,300
Nov 151,870 173,800
Dec 210,746 198,600
YTD Total 1,416,783 .1,584,700 1,948,050 531,267 37.5% 363,350 22.90
Annual Total 1,920,344 2,107,400
Fines & Forfeits by Type
Year to Date through September
2009 2010 2010 2010 vs. 2009. 2010 vs. Budget
Month Actual Budget Actual ' Amount Percentage Amount Percentage
Civil Penalties 15,856 11,000 18,109 2,252 14.2% 7,109 64.6%
Civil Infraction Penalties 476,532 344,800 589,896 113,364 23.8% 245,096 71.1%
Red Light Photo Enforcement 619,893 835,700 942,414 322,520 52.0% 106,714 12.8%
Parkin Infractions 108,271 121,100 148,708 40,437 37.3% 27,608 22.8%
Criminal Traffic Misdemeanor 70,052 82,500 75,651 5,598 8.0% (6,849) -8.3%
Criminal Non-Traffic Fines 95,045 73,800 87,928 (7,116) -7.5% 14,128 193%
Criminal Costs 9,655 15,800 9,246 (409) -4.2% (6,554) -41.5%
Non-Court Fines & Penalties - 21,477 100,000 76,100 54,623 254.3% (23,900) -23.9%
YTD.Total 1,416,783 .1,584,700 1,948,050 531,269 37.5% 363,350 22.9%
Annual Total 1,920,344 2,107,400
10
Monthly Financial Report September 2010
Photo Enforcement
Year to Date through September
2009 2010 2010 2010 vs. 2009 2010 vs. Budget
Month Actual Budget Actual Amount Percentage Amount Percentage
Jan 73,432 101,000 134,182 60,751 82.7% 33,182 32.9%
Feb 62,632 91,900 103,153 40,521 64.7% 11,253 12.2%
Mar 67,543 93,300 118,358 50,815 75.2% 25,058 26.9%
Apr 70,057 91,600 122,490 52,433 74.8% 30,890 33.7%
May 78,746 103,000 117,742 38,996 49.5% 14,742 14.3%
Jun 76,980 100,700 98,202 21,222 27.6% (2,498) -2.5%
Jul 79,382 103,800 122,177 42,795 53.9% 18,377 17.7%
Au 63,225 82,700 75,485 12,260 19.4% (7,215) -8.7%
Se 47,897 67,700 50,624 2,727 5.7% (17,076) -25.2%
Oct 44,010 62,600
Nov 74,239 97,100
Dec 102,895 104,600
YTD Total 619,893 835,700 942,414 322,520 52.0% 106,714 12.87
Annual Total 841,038 1,100,000
Miscellaneous
This revenue source is comprised of interest and other investment earnings, rents, leases &
concessions, contributions & donations and other miscellaneous income. The 2010 budget for
this revenue category is $810,800 and interest & investment and rentals & leases make up 85% of
the annual budget. Decreased interest revenue reflects the decline in the financial markets; the
Local Government Investment Pool interest has decreased from 1.27% in January 2009 to
0.26% in September 2010. The increase in rentals & leases from 2009 is due to the inter-fund
payment from the utility funds for the City Hall Annex lease. Compared to the 2010 budget, the
increase in rentals & leases is primarily from Parks facility rentals. Contributions & donations are
higher than YTD budget because of increases in the Parks contributions and donations account
that support parks special programs such as the senior wellness and teen programs. Other
miscellaneous revenue is budgeted conservatively and year to date receipts are greater than 2009
receipts & 2010 budget due to reimbursements for prior year general fund expenditures.
Miscellaneous Revenues by Type
Year to Date through September
2009 2010 2010 2010 vs. 2009 2010 vs. Budget
Month Actual Budget Actual Amount Percentage Amount Percentage
Interest & Investments 151,791 144,500 115,348 (36,443) -24.0% (29,152) -20.2%
Rents & Leases 219,645 488,100 547,990 328,345 149.5% 59,890 12.3%
Contributions & Donations 78,947 34,300 47,663 (31,284) -39.6% 13,363 39.0%
Other Miscellaneous Revenue 58,375 34,000 156,013 97,638 167.3% 122,013 358.9%
YTD Total 508,758 700,900 867,015 358,257 70.4% 166,115 23.7%
Annual Total 664,307 810,800
Monthly Financial Report September 2010
Real Estate Excise Tax
The Real Estate Excise Tax (REET) revenue is received in the Capital Improvement Projects Fund
and is used for governmental capital projects. In September, year to date revenue of $813,825 is
$308.9K or 27.5% less than the projected budget. This is $158.5K or 16.3% less than 2009 for
the same period and the recent drop in revenues for August & September reflects the current
slump in the commercial and residential markets. In addition, the City did not receive Real Estate
Excise Tax revenue from King County in September and anticipate that it will be included with
the October revenues.
Real Estate Excise Tax Revenues
Year to Date through September
2009 2010 2010 2010 vs. 2009 2010 vs. Budget
Month Actual Budget Actual Amount Percentage Amount Percentage
Jan 55,308 63,900 44,219 (11,088) -20.0% (19,681) -30.8%
Feb 115,443 133,300 56,636 (58,807) -50.9% (76,664) -57.5%
Mar 114,240 131,900 74,986 (39,254) -34.4% (56,914) -43.1%
Apr 75,831 87,600 89,679 13,848 18.3% 2,079 2.4%
May 68,846 79,500 207,808 138,962 201.8% 128,308 161.4%
Jun 141,704 163,600 153,434 11,730 8.3% (10,166) -6.2%
Jul 106,672 123,200 114,879 8,208 7.7% (8,321) -6.8%
Au 115,268 133,100 49,393 (65,875) -57.1% (83,707) -62.9%
Se 179,067 206,700 22,789 (156,278) -87.3% (183,911) -89.0%
Oct 314,172 362,700
Nov 184,935 213,500
Dec 87,440 101,000
YTD Total 972,379 1,122,800 813,825 (158,554) -16.3% (308,975) -27.5%
Annual Total 1,558,926 1,800,000
12
Monthly Financial Report September 2010
Enterprise Funds
The table below provides an analysis of all City Enterprise funds and shows the year to date
revenues and expenditures for each enterprise fund.
Water Sewer Storm Solid Waste Airport Cemetery Golf Comm. Retail
OPERATING REVENUES
Charges for services 6,890,829 11,782,482 4,809,094 6,891,351 20,006 555.133 1,228,141
Rents, Leases, Concessions & Other 461,106 - 42,542
TOTAL OPERATING REVENUES 6,890,829 11,782,482 4,809,094 6,891,351 481,112 555,133 1,270,683
OPERATING EXPENSES:
Administration 1,727,657 1,345,874 1,590,433 544,616 354,483 201,511 157,337
Operations & Maintenance 3,273,696 10,782,662 1,746,413 6,114,493 116 491,143 927.717
Depreciation & Amortization 1,588,078 1,032,584 818,878 15,258 163,147 42,899 253,281 33,328
TOTAL OPERATING EXPENSES 6,589,431 13,161,120 4,155,723 6,674,367 517,746 735,554 1,338,335 33,328
OPERATING INCOME (LOSS) 301,398 (1,378,638) 653,371 216,985 (36,634) (180,420) (67,653) (33,328)
NON-OPERATING REVENUES & EXPENSES
Interest Revenue 36,194 53,320 14,559 1,968 2.730 540 464
Other Non Operating Revenue 43,234 504,516 82,015 9,058 113,834 282 2,746
Other Non Operating Expense (135,257) (120,045) (100,000) (28,938) (11,134) (99,297)
TOTAL NON-OPERATING REVENUES (EXPENSES) (55,830) 437,791 (3,426) 11,027 87,626 (10,311) (96,087)
INCOME (LOSS) BEFORE CONTRIBUTIONS &
TRANSFERS 245,568 (940,847) 649,945 228,011 50,993 (190,731) (163,740) (33,328)
Contributions 343,192 187,454 219,450
Transfers In 61,038
Transfers Out (58,600) (58,200) (62,800) (900)
TOTAL CONTRIBUTIONS & TRANSFERS 284,592 129.254 156,650 (900) 61,038
CHANGE IN FUND BALANCE 530,160 (811,593) 806,596 227,111 50.993 (190,731) 002,702) (33,328)
BEGINNING FUND BALANCE, January 1, 2010 58,580,941 64,391,028 39,620,492 1,576,387 9,687,653 1,114,074 5,501,774 1,473,941
ENDING FUND BALANCE, September 30, 2010 59,111,101 63,579,435 40,427,087 1,803,498 9,738,646 923,343 5,399,073 1,440,613
Solid Waste operating expenses are low due to timing of invoices from Waste Management.
September billing of $653,801 was posted in October.
13
Monthly Financial Report September 2010
Internal Service Funds
The table below provides an analysis of all City Internal Service funds and shows the year to date
revenues and expenditures for each fund.
Information Equipment
Insurance Facilities Services Rental
OPERATING REVENUES:
Interfund Charges for services 1,948,158 2,926,557 1,852,454
Rents, Leases, Concessions & Other 96,593 18,742
TOTAL OPERATING REVENUES - 2,044,751 2,945,299 1,852,454
OPERATING EXPENSES:
Administration 432,629 - 391,541
Operations & Maintenance 1,466,298 2,514,622 952,107
Depreciation & Amortization - 352,864 762,203
TOTAL OPERATING EXPENSES 432,629 1,466,298 2,867,486 2,105,851
OPERATING INCOME (LOSS) (432,629) 578,452 77,813 (253,397)
NON-OPERATING REVENUES & EXPENSES
Interest Revenue 3,778 1,484 9,068 11,997
Other Non Operating Revenue 40,341 12,912
Other Non Operating Expense -
TOTAL NON-OPERATING REVENUES (EXPENSES) 3,778 1,484 49,409 24,909
INCOME (LOSS) BEFORE CONTRIBUTIONS & TRANSFERS (428,851) 579,936 127,222 (228,488)
Contributions - 10,950 90,964
Transfers In 238,600
Transfers Out - (29,500) (22,400)
TOTAL CONTRIBUTIONS & TRANSFERS 238,600 (18,550) 68,564
CHANGE IN FUND BALANCE (190,251) 579,936 108,672 (159,924)
BEGINNING FUND BALANCE, January 1, 2010 2,234,469 207,637 4,914,846 10,892,939
ENDING FUND BALANCE, September 30, 2010 2,044,219 787,573 5,023,517 10,733,015
The Insurance Fund expenses include $308,089 that was paid at the beginning of the year. This
amount will be decreasing throughout the year as the expense is being allocated to the various
departments and funds on a monthly journal entry.
Equipment rental fund balance of $10,733,015 includes approximately $5 million in fixed assets
net of depreciation which primarily consist of the City's fleet vehicles.
Contact Information
This report is prepared by the Finance Department. Additional financial information can also be
viewed at our website: http://www.auburnwa.govZ. For any questions about the report please
contact us at kiesterPauburnwa.gov or scoleman(aauburnwa.gov.
14
SALES TAX SUMMARY
September 2010 Jul Receipts)
YTD YTD
NAICS CONSTRUCTION 09 TOTAL 09 YTD 10 YTD % Diff NAICS AUTOMOTIVE 09 TOTAL 09 YTD 10 YTD % Diff
236 Construction of Buildings 625,111 456,560 433,284 -5.1% 441 Motor Vehicle & Parts Dealer 2,369,443 1,736,442 1,727,263 -0.5%
237 Heavy & Civil Construction 140,889 95,911 94,941 -1.0% 447 Gasoline Stations 189,621 134,449 148,052 10.1%
238 Specialty Trade Contractors 602,216 428,672 399,639 -6.8% TOTAL AUTOMOTIVE $ 2,559,064 $ 1,870,891 $ 1,875,315
TOTAL CONSTRUCTION E 1,368,217 S 981,143 S 927,864 Overall Automotive Change Iron Previous Year $4,424 0.2%
Overall Construction Change from Previous Year ($53,278) -5.4%
NAICS RETAIL TRADE 09 TOTAL 09 YTD 10 YTD % Diff
YTD 442 Furniture & Home Furnishings 219,775 167,254 145,760 -12.9%
MANUFACTURING 09 TOTAL 09 YTD 10 YTD % Diff 443 Electronics & Appliances 131,716 102,956 89,337 -13.2%
311 Food Manufacturing 2,677 2,248 1,640 -27.1% 444 Building Material & Garden 358,226 269,735 292,357 8.4%
312 Beverage & Tobacco Products 3,890 3,018 2,541 -15.8% 445 Food & Beverage Stores 352,401 262,252 259,370 -1.1%
313 Textile Mills 215 192 82 -57.1% 446 Health & Personal Care 149,756 117,095 109,112 -0.8%
314 Textile Product Mills 1,354 1,080 1,175 8.8% 448 Clothing & Accessories 781,336 574,432 559,137 -2.7%
315 Apparel Manufacturing 279 2,775 2,121 -23.6% 451 Sporting Goods, Hobby, Books 45,215 34,797 67,966 95.3%
316 Leather & Allied Products 61 52 39 -25.1% 452 General Merchandise Stores 832,911 636,903 603,025 -5.3%
321 Wood Product Manufacturing 31,411 21,527 24,203 12.4% 453 Miscellaneous Store Retailers 481,356 372,859 372,336 -0.1%
322 Paper Manufacturing 8,997 6,664 8,350 25.3% 454 Nonstore Retailers 228,036 171,869 175,065 1.9%
323 Printing 8 Related Support 41,517 30,649 32,186 5.0% TOTAL RETAIL TRADE $ 3,580,729 $ 2,710,152 S 2,673,466
324 Petroleum & Coal Products 10,708 7,536 2,394 -68.2% Overall General Retail Change from Previous Year ($36,687) -1.4%
325 Chemical Manufacturing 6,905 4,736 5,607 18.4%
326 Plastic & Rubber Products 9,663 6,537 6,779 3.7% YTD
327 Nonmetallic Mineral Products 15,270 10,148 13,679 34.8% SERVICES 09 TOTAL 09 YTD 10 YTD % Diff
331 Primary Metal Manufacturing 592 583 63 -89.2% 51' Information 456,586 346,464 880,031 154.0%
332 Fabricated Metal Mfg Products 12,232 9,978 12,247 22.7% 52' Finance & Insurance 82,939 65,039 50,979 -21.6%
333 Machinery Manufacturing 8,798 5,826 10,062 72.7% 53' Real Estate, Rental, Leasing 304,200 239,772 216,062 -9.9%
334 Computer & Electronic Products 8,595 6,320 11,497 81.9% 541 Professional, Scientific, Tech 199,772 160,699 142,186 -11.5%
335 Electric Equipment, Appliances 2,219 1,724 2,549 47.9% 551 Company Management 478 400 124 -69.0%
336 Transportation Equipment Mfg 177,978 143,635 128,910 -10.3% 56• Admin, Supp, Famed Svcs 260,987 204,828 157,227 -23.2%
337 Furniture & Related Products 12,187 8,924 8,789 -1.5% 611 Educational Services 42,162 24,893 36,838 48.0%
339 Miscellaneous Manufacturing 27,923 22,228 21,327 -4.1% 62' Health Care Social Assistance 61,157 47,084 25,539 -45.8%
TOTAL MANUFACTURING $ 383,469 $ 296,380 S 296,240 71• Arts & Entertainment 147,103 126,871 126,584 -0.2%
Overall Manufacturing Change from Previous Year ($139) O.o% 72• Accommodation & Food Svcs 827,347 621,423 598,445 -3.7%
81' Other Services 423,203 318,045 289,171 -9.1%
YTD 92' Public Administration 61,553 35,842 80,628 125.0%
TRANSPORTATION & WAREHOUSING 09 TOTAL 09 YTD 10 YTD % Diff TOTAL SERVICES $ 2,867,488 $ 2,191,360 $ 2,603,815
481 Air Transportation 0 0 0 N/A Overall Services Change from Previous Year $412,455 18.8%
482 Rail Transportation 8,577 8,361 4,042 -51.7%
484 Truck Transportation 7,090 5,100 5,302 4.0%
485 Transit and Ground Passengers 5 40 57 41.8% YTD
488 Transportation Support 13,090 10,294 9,448 -8.2% MISCELLANEOUS 09TOTAL 09YTD IOYTD %Diff
491 Postal Services 190 149 151 N/A 000 Unknown 272 269 808 200.7%
492 Couriers & Messengers 1,114 966 829 -14.1% 111-115 Agriculture, Forestry, Fishing 1,827 1,315 1,832 39.3%
493 Warehousing & Storage 726 388 1,854 378.0% 211-221 Mining & Utilities 27,452 19,443 15,969 -17.9%
TOTAL TRANSP & WHSING $ 30,791 $ 25,298 $ 21,684 999 Unclassifiable Establishments 16,906 10,111 89,422 784.4%
Overall Transportation Change from Previous Year ($3,614) -14.3% MISCELLANEOUS TOTAL S 46,456 S 31,138 $ 108,031
Overall Miscellaneous Change from Previous Year $76,893 246.9%
YTD
WHOLESALE TRADE 09 TOTAL 09 YTD 10 YTD % Diff
423 Whls Trade-Durable Goods 919,970 663,159 726,983 9.6% YTD
424 Whls Trade-Nondurable Goods 149,252 121,404 120,017 -1.1% 09 TOTAL 09 YTD 10 YTD % Diff
425 Wholesale Electronic Markets 3,744 2,135 1,720 -19.5% GRANDTOTALS _ $11,909,179 $8,893,060 $9,355,135
WHOLESALE TRADE TOTAL S 1,072,965 $ 786,699 E 848,720 Grand Total Change from Prevous Year $462,075 5.20%
Overall Wholesale Change from Previous Year $62,021 79%
15
9/2n/sm0 Page 1 10sd,,Tm,ept. t
City of Auburn
Investment Portfolio Summary
As of September 30, 2010
Investment Purchase Purchase Maturity Yield to
Type Date Price Date Maturity
State Investment Pool Various $ 72,874,616 Various 0.30%
KeyBank Money Market Various 6,116,870 Various 0.10%
US Treasury 05/04/1990 57,750 05/15/2016 5.72%
FHLB 2/2/2009 1,000,000.00 2/2/2011 1.540%
FHLB 2/2/2009 1,000,000.00 8/2/2011 1.840%
FHLB 12/29/2009 1,000,000.00 6/29/2012 1.375%
FHLB 3/24/2010 2,000,000.00 12/24/2012 1.550%
FNMA 3/25/2010 2,000,000.00 3/25/2013 1.850%
FNMA 5/13/2010 1,725,000.00 12/24/2013 1.550%
FHLB 5/20/2010 2,500,000.00 2/20/2013 1.625%
FHLMC 6/24/2010 2,000,000.00 12/24/2013 1.750%
FNMA 6/30/2010 1,000,000.00 12/30/2013 1.750%
Total Cash & Investments $ 93,274,236 0.497%
Investment Mix % of Total Summary
State Investment Pool 78.1% Current 6-month treasury rate 0.22%
KeyBank Money Market 6.6% Current State Pool rate 0.30%
US Treasury 0.1% KeyBank Money Market 0.10%
FHLB 8.0% Blended Auburn rate 0.50%
FNMA 5.1%
FHLMC 2.1%
100.0%
16