HomeMy WebLinkAboutApril 2010AGENDA BILL APPROVAL FORM
* SASH II'Ti
Agenda Subject: April 2010 Financial Report Date: 6/15/2010
Department: Finance Attachments: April Monthly Report Budget Impact: 0
Administrative Recommendation:
Background Summary:
The April 2010 status report highlights City revenues and expenditures and is based on financial
data available as of May 25, 2010. Sales tax reported in April is for business activities that occurred in February 2010.
Total General Fund revenues for the City at the end of April were $19,171,903 which is
approximately 39% of the annual budgeted revenues. Compared to budgeted year-to-date
revenues, this is $826.8K (4.5%) more due to timing of receipts for Cable TV Franchise fees
and intergovernmental revenues coupled with increases in traffic infraction & photo enforcement revenues.
Expenditures for the General Fund totaled $15,141,370 which is $2,599K (14.7%) under budget
at the end of April. Most of the departments' expenses in the General Fund are below budget
during the first part of the year as some expenses such supplies, professional and
intergovernmental services are paid out in later periods.
Reviewed by Council & Committees: Reviewed by Departments & Divisions:
❑ Arts Commission COUNCIL COMMITTEES: ❑ Building ❑ M&0
❑ 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 I l Referred to Until I l
Tabled Until I I
Councilmember: Backus Staff: Coleman Meeting Date: June 21, 2010 Item Number:
rr~Y
t 4 ~ i ri' rr ~ :'r }1 •~K SAY J l ~ ~ I i y a fir' ti i f.. ~ ~ .i f ~ Sr 'r9 .AS ~1
1
M®nthly Financial Rep®rt April 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 5,316,400 5,331,029 14,629 0.3% Sales Tax (1) 14,255,000 4,737,300 4,777,095 39,795 0.8°l0
Sales Tax -Annexation Credit 1,453,500 497,600 444,655 (52,945) -10.6%
Criminal Justice Sales Tax 1,143,300 385,200 413,846 28,646 7.4°l0 Brokered Natural Gas Tax 260,000 115,200 111,211 (3,989) -3.5%
City Utilities Tax 2,140,200 727,300 773,918 46,618 6.4%
Admissions Tax 400,000 170,400 135,598 (34,802) -20.4%
Electric Tax 2,794,100 1,526,200 1,586,935 60,735 4.0°l0 Natural Gas Tax 1,245,500 834,200 633,305 (200,895) -24.1%
Cable TV Franchise Fee 676,300 170,900 387,036 216,136 126.5%
Telephone Tax 1,734,200 473,500 619,696 146,196 30.9%
Garbage Tax (external) 100,000 30,200 50,481 20,281 67.2°l0 Leasehold Excise Tax 80,000 43,600 10,397 (33,203) -76.2%
Gambling Excise Tax 766,500 366,900 171,572 (195,328) -53.2%
Business License Fees 200,000 18,700 16,261 (2,439) -13.0°l0 Building Permits 700,000 236,100 226,123 (9,977) -4.2%
Other Licenses & Permits 188,000 61,700 95,000 33,300 54.0°l0
Intergovernmental (Grants, etc) 4,388,740 1,142,300 1,425,708 283,408 24.8°l0
Charges for Services: General Government Services 113,000 43,900 33,398 (10,502) -23.9%
Public Safety 244,000 93,400 84,599 (8,801) -9.4%
Development Services Fees 857,000 299,800 205,098 (94,702) -31.6% Culture and Recreation 821,000 325,100 327,684 2,584 0.8%
Fines and Forfeits 1,870,700 603,600 952,565 348,965 57.8%
Interests and Other Earnings 170,000 82,500 45,665 (36,835) -44.6%
Rents, Leases and Concessions 223,000 72,900 115,927 43,027 59.0°l0 Contributions and Donations 26,600 5,000 18,243 13,243 264.9%
Other Miscellaneous 46,200 15,900 132,326 116,426 732.2%
Transfers In 17,000 17,000 17,000 - 0.0% Insurance Recoveries- Capital & Operating 55,000 18,300 29,533 11,233 61.4°l0
Total Operating Revenues 49,326,149 18,431,100 19,171,903 740,803 4.0°l0
Operating Expenditures
Council & Mayor 738,900 263,700 220,390 43,310 16.4% Municipal Court & Probation 3,055,280 993,680 846,580 147,100 14.8%
Human Resources 736,150 251,150 221,056 30,094 12.0%
Finance 1,170,960 396,060 354,538 41,522 10.5% City Attorney 1,636,050 632,450 485,775 146,675 23.2%
Planning 3,081,470 1,159,070 1,057,811 101,259 8.7°l0
Community & Human Services 1,050,400 319,100 277,652 41,448 13.0%
Police 23,429,315 7,734,215 6,725,467 1,008,748 13.0% Engineering 2,941,610 1,058,610 808,432 250,178 23.6°l0
Parks and Recreation 6,766,200 2,252,900 2,108,276 144,624 6.4%
Streets 3,093,500 1,033,100 839,616 193,484 18.7%
Non-Departmental 5,821,200 1,646,300 1,195,777 450,523 27.4°l0 Total Operating Expenditures 53,521,035 17,740,335 15,141,370 2,598,965 14.7%
(1J The anticipated Streamlined Sales Tax Mitigation for 2010 is $1,966,755. The year to date actual sales tax amount
is adjusted to include $489,227 SST Mitigation the City received from the State for 1St the quarter of 2010.
2
M®nthly Financial Rep®rt April 2010
Overview
This financial overview reflects the City's overall financial position for the fiscal year through
April 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 April, the combined collection of property tax, sales/use tax, utility tax, gambling, and
admissions tax represents 81 % of all resources supporting general governmental activities. The
following section provides detail information on property and sales taxes.
Pr®perty Tax
Year to date collection at the end of April is $5,331,029 or 43.1% of the $12,357,509 annual
budget. Compared to 2009, the City collected $769,925 or 16.9% more for the same period.
At the end of the April, property tax revenue is $14,629 or .3% more than the year to date
budget and is in line with the budget.
Property Tax Revenue
Year to Date through April 2009 2010 2010 2010 vs. 2009 2010 vs. Budget
Month Actual Bud et Actual Amount Percenta a Amount Percenta e
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%
May 852,588 993,800
Jun 37,763 44,000
Jul 21,078 24,600
Aug 32,632 38,000 Sep 196,787 229,400
Oct 3,836,015 4,471,109
Nov 1,017,258 1,185,700
Dec 46,566 54,300
YTD Total 4,561,104 5,316,400 5,331,029 769,925 16.9% 14,629 0.3%
Annual Total 10,601,791 12,357,309
3
M®nthly Financial Rep®rt April 2010
Sales Tax
Although the Sales tax revenue in April currently does not include a portion of the Streamlined
Sales tax mitigation, it is already greater than April 2009 by $290.8K due to a one time
adjustment to correct prior years' revenues. Compared to the projected monthly budget; it is
over by $266.5K or 25% more and brings the year to date revenue to be $163K greater than
2009 and $39.8K greater than YTD budget. At the end of the 15t quarter the City has received
$489,227 of the total anticipated SST mitigation of $1,966,775 for 2010. The actual amount of
SST 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 April
2009 2010 2010 2010 vs. 2009 2010 vs. Bud et
Month Actual " Bud et ~ Actual Amount Percenta a Amount Percenta e
Jan 1,232,999 1,213,000 1,128,608 (104,391) -8.5% (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,332,796 290,824 27.9% 266,496 25.0%
May 1,161,471 1,249,400
Jun 1,098,038 1,144,900
Jul 1,152,738 1,180,300 Au 1,250,264 1,302,700
Sep 1,148,525 1,147,700
Oct 1,254,457 1,200,400
Nov 1,197,153 1,175,200
Dec 1,065,935 1,117,100
YTD Total 4,614,145 4,737,300 4,777,095 162,950 3.5% 39,795 0.8%
Annual Total 13,942,728 14,255,000
Includes Sales Tax Mitigation prorated 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 SlC Group
Year to Date through April
2009 2010 Chan a from 2009
Component Group Actual Aetual Amount Percenta e
New Construction 433,777 416,759 (17,019) -3.9%
Manufacturing 132,880 126,363 (6,517) -4.9%
Transportation & Warehousing 10,189 8,853 (1,337) -13.1%
Wholesale Trade 345,491 355,649 10,158 2.9%
Automotive 781,866 760,111 (21,755) -2.8% Retail Trade 1,273,792 1,228,110 (45,682) -3.6%
Services 968,195 1,361,743 393,548 40.6%
Miscellaneous 14,464 68,352 53,888 372.6%
YTD Total 3,960,655 4,325,939 365,284 9.2%
4
M®nthly Financial Rep®rt April 2010
Utilit Tax
This revenue source consists of City inter-fund utility taxes (1Xlater, Sewer, Storm and Solid Waste)
and external utility taxes (Electric, Natural gas, Telephone and Solid Waste). Year to date utility
tax revenue is $3,664,334 which is $473.3K (11.4%) less than 2009 primarily due to the City
lnterfund 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 $72.9K or 2% more than budgeted tax revenues. This increase is mainly attributable to higher revenues in the
telephone utility tax. An adjustment to increase estimated revenues for telephone utility tax by
$200K is included in the mid year budget amendment.
Utility Tax Revenues
Year to Date through April
2009 2010 2010 2010 vs. 2009 2010 vs. Bud et
Month Actual Bud et Actual Amount Percents a Amount Percents e
Jan 1,329,027 1,188,200 1,258,792 (70,236) -5.3% 70,592 5.9%
Feb 592,186 448,200 483,456 (108,730) -18.4% 35,256 7.9%
Mar 304,496 216,900 416,213 111,717 36.7% 199,313 91.9%
Apr 1,911,964 1,738,100 1,505,874 (406,090) -21.2% (232,226) -13.4%
May 575,114 436,000
Jun 441,229 325,200 Jul 1,340,355 1,195,700
Aug 621,691 469,600
Sep 453,881 336,100
Oct 1,123,629 980,000
Nov 516,516 397,200
Dec 376,459 282,800
YTD Total 4,137,673 3,591,400 3,664,334 (473,340) -11.4% 72,934 2.0%
Annual Total 9,586,547 8,014,000
The following table presents utility tax by source:
Utilty Tax by Type
Year to Date through April
2009 2010 2010 2010 vs. 2009 2010 vs. Bud et
Month Actual Bud et Actual Amount Percents a Amount Percents e
City lnterfund Utility Taxes 1,043,742 727,300 773,918 (269,824) -25.9% 46,618 6.4%
Electric 1,639,293 1,526,200 1,586,935 (52,358) -3.2°l0 60,735 4.0%
Natural Gas 828,684 834,200 633,305 (195,379) -23.6°l0 (200,895) -24.1%
Telephone 580,204 473,500 619,69b 39,492 6.8% 146,196 30.9%
Solid Vllaste 45,750 30,200 50,481 4,731 10.3°l0 20,281 67.2%
YTD Total 4,137,b73 3,591,400 3,664,334 (473,340) -11.4°l0 72,934 2.0%
Annual Total 9,586,547 8,014,000
5
M®nthly Financial Rep®rt April 2010
Cable TV Franchise Fees are received quarterly and are shown on the table below. This is
$198.4K or 105.2% more than the previous year for the same period due to timing of receipts
and is $216.1 K or 126.5% greater than the 2010 year to date budget.
Cable TV Franchise Fee
Year to Date through April
2009 2010 2010 2010 vs. 2009 2010 vs. Bud et
Month Actual Bud et Actual Amount Percenta a Amount Percenta e
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
Jun - -
Jul 186,766 169,200
Au - -
Sep - -
Oct 186,910 169,400 Nov - -
Dec - -
YTD Total 188,592 170,900 387,036 198,444 105.2% 216,136 126.5%
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 April, the City has collected 31% of the annual
projected revenue from licenses and permits. Building permit fees and Business licenses make up
83% of the annual budgeted revenue in this category and the following tables present detail
information for each.
Building Permits
Year to Date through April
2009 2010 2010 2010 vs. 2009 2010 vs. Bud et
Month Actual Bud et Actual Amount Percenta a Amount Percenta e
Jan 17,047 69,800 88,175 71,128 417.2% 18,375 26.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 Jun 158,105 49,800
Jul 90,765 62,900
Aug 54,856 96,200
Sep 42,615 68,300
Oct 83,041 45,300
Nov 56,606 38,200
Dec 137,651 56,100
YTD Total 167,107 236,100 226,123 59,016 35.3% (9,977) -4.2%
Annual Total 835,478 700,000
6
M®nthly Financial Rep®rt April 2010
Total building permit revenues at the end of April were $226,123. This was $59K greater than
2009 for the same period and $9.9K or 4.2% less than budgeted revenues. The increase from
2009 is primarily due to the developments at Trail Run and North Tapps Estates.
Business License revenues at the end of April are $3.3K or 16.8% less than 2009 and $2.4K or
13.0% less than 2010 year to date budget. This revenue source is expected to be low during the
first part of the year as most licenses are renewed mid year.
Business License
Year to Date through April
2009 2010 2010 2010 vs. 2009 2010 vs. Bud et
Month Actual Bud et Actual Amount Percents a Amount Percents e
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
Jun 102,500 98,000
Jul 49,110 47,000
Aug 12,061 11,500 Sep 6,271 6,000
Oct 6,277 6,000
Nov 5,229 5,000
Dec 3,810 3,600
YTD Total 19,542 18,700 16,261 (3,281) -16.8% (2,439) -13.0%
Annual Total 209,089 200,000
Inters®vernmental
Revenues in this category include Grants, (Direct & Indirect Federal, State and Local) State shared
revenues and compact revenue from the Muckleshoot Indian Tribe. April receipts are greater
than budgeted revenue mainly due to the Muckleshoot compact that is budgeted conservatively.
Timing of grant revenue varies as they are processed on a reimbursement basis.
Intergovernmental
Year to Date through April
2009 2010 2010 2009 vs 2010 2010 vs.Bud et Revenue Actual Bud et Actual % Chan e % Chan e
Federal Grants 21,737 53,900 131,810 506.4% 144.5%
State Grants 13,806 11,400 19,656 42.4% 72.4% lnterlocal Grants - 35,400 52,592 N/A 48.6%
State Shared Revenue 787,215 815,200 853,419 8.4% 4.7%
Muckleshoot Casino Emer . 323,222 226,400 368,231 13.9% 62.6%
YTD Total 1,145,980 1,142,300 1,425,708 24.4% 24.8%
Annual Total 4,499,411 4,388,740 YTD % 25% 26% 32%
Total state shared revenues are greater than 2009 for the same period due to the increased
Motor Vehicle Fuel Tax revenues and the timing of Trial Court Improvements revenue. This
7
M®nthly Financial Rep®rt April 2010
revenue was not received until June in 2009. Compared to budget, revenues are greater by
$38,219 or 4.7%. Income from Criminal Justice-Special programs and Liquor profits were
budgeted conservatively and contributed to the overall increase.
State Shared Revenues
Year to Date through April 2009 2010 2010 2010 vs. 2009 2010 vs. Bud et
Revenue Actual Bud et Actual Amount Percenta a Amount Percenta e
Trial Court Improvements - 6,000 11,360 11,360 N/A 5,360 89.33%
Court Interpreter Program 10,205 - - (10,205) N/A - N/A
Motor Vehicle Fuel Tax 442,722 463,100 452,834 10,112 2.3% (10,266) -2.2%
Criminal Justice -Population 32,452 33,600 34,040 1,588 4.9% 440 1.3% Criminal Justice -Spec. Prog. 26,876 16,100 28,009 1,132 4.2% 11,909 74.0%
State DUI 5,964 2,000 6,288 324 5.4% 4,288 214.4%
Liquor Excise Tax 162,338 162,900 167,432 5,094 3.1% 4,532 2.8%
Liquor Profits 106,658 131,500 153,457 46,799 43.9% 21,957 16.7%
YTD Total 787,215 815,200 853,419 66,204 8.4% 38,219 4.7%
Annual Total 2,465,986 2,594,740
Charles f®r 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 $2,035,000 annual budget for this category and are presented
following the Charges for Service table below. At the end of April $650,779 or 31.9% of 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 includes a reduction for City of Algona court
charges as the City of Auburn is no longer collecting this revenue since 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.
Probation fees account for $70K of the $84.6K received to date for this category and is 9.4% less
than budgeted revenues as of the end of April.
Charges for Services by Type
Year to Date through April
2009 2010 2010 2010 vs. 2009 2010 vs. Bud et
Revenue Actual Bud et Actual Amount Percenta a Amount Percenta e
General Government 48,660 43,900 33,398 (15,262) -31.36% (10,502) -23.92%
Public Safety 96,219 93,400 84,598 (11,620) -12.1% (8,802) -9.4%
Development Services 173,036 299,800 205,098 32,062 18.5% (94,702) -31.6%
Culture ~ Recreation 329,484 325,100 327,684 (1,800) -0.5% 2,584 0.8%
YTD Total 647,399 762,200 650,779 3,380 0.5% (111,421) -14.6%
Annual Total 1,683,495 2,035,000
Development Services include Engineering fees, zoning & subdivision fees and plan check fees.
Year to date revenues total $205,098 and is 18.5% or $32K greater than 2009 for the same
s
M®nthly Financial Rep®rt April 2010
period. Zoning a & subdivision fees related to Kersey 3 and Jovita Heights contributed to the
overall increase from 2009 coupled with plan check fees for various commercial and residential
projects. Still, overall revenue is less than the budget for the year by $94.7K or 31.6% due to
lower than anticipated engineering fees revenue. The mid year budget amendment includes a
reduction of $155K for engineering fees to reflect actual receipts.
Development Service Fees
Year to Date through April
2009 2010 2010 2010 vs. 2009 2010 vs. Budget Month Actual Budget Actual Amount Percentage Amount Percentage
Jan 51,833 89,800 39,755 (12,078) -23.3% (50,045) -55.7%
Feb 46,818 81,100 53,677 6,859 14.7% (27,423) -33.8% Mar 29,147 50, 500 82, 904 53, 757 184.4% 32,404 64.2%
Apr 45,238 78,400 28,762 (16,476) -36.4% (49,638) -63.3%
May 23,450 40,600
Jun 86,974 150,800
Jul 42,644 73,900
Aug 53,060 92,000 Sep 32,404 56,200
Oct 15,079 26,100
Nov 26,650 46,200
Dec 41,227 71,400
YTD Total 173,036 299,800 205,098 32,062 18.5% (94,702) -31.6%
Annua( Total 494,524 857,000
Culture & Recreation revenues consist of theater ticket sales, recreational classes, arts commission
and senior citizen program fees. Revenue for the month of April shows a decrease from 2009
and is mainly due to decrease in the Bravo ticket sales revenue and timing of parks recreation
program registration receipts.
Culture & Recreation
Year to Date through April
2009 2010 2010 2010 vs. 2009 2010 vs. Budget
Monfih Actual Budget Actual Amounfi Percentage Amount Percentage
Jan 71,561 70,600 65,917 (5,644) -7.9% (4,683) -6.6%
Feb 51,878 51,200 57,959 6,081 11.7% 6,759 13.2%
Mar 124,525 122,900 133,930 9,405 7.6% 11,030 9.0% Apr 81,520 80,400 69,877 (11,643) -14.3% (10,523) -13.1%
May 75,505 74,500
Jun 90,011 88,800
Jul 77,622 76,600
Aug 66, 639 65, 700 Sep 61,305 60,500
Oct 41,086 40,500
Nov 44,066 43,500
Dec 46,428 45,800
YTD Total 329,484 325,100 327,684 (1,800) -0.5% 2,584 0.8%
Annua( Total 832,146 821,000
9
M®nthly Financial Rep®rt April 2010
Fines & Penalties
These revenue sources include traffic and parking infraction penalties, criminal (traffic, non traffic
and costs) false alarm and shopping cart fines. This revenue source is $317,443 or 50% greater
than 2009 for the same period and $248,965 or 57.8% higher than the projected year to date
budget. The overall increase is primarily due to the rise in the traffic infraction and photo
enforcement revenues. Traffic and parking infractions revenue are 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 April
2009 2010 2010 2010 vs. 2009 2010 vs. Budget
Month Actual Budget Actual Amount Percentage Amount Percentage
Jan 148,141 140,800 236,675 88,534 59.8% 95,875 68.1%
Feb 153,213 145,600 223,295 70,082 45.7% 77,695 53.4%
Mar 168,348 160,000 252,739 84,391 50.1% 92,739 58.0% Apr 165,420 157,200 239,856 74,436 45.0% 82,656 52.6%
May 174,475 165,800
Jun 168,280 159,900
Jul 159,112 151,200
Aug 144, 593 137, 500
Sep 163,212 155,200
Oct 143, 517 136, 500
Nov 167,497 159,200
Dec 212, 349 201, 800
YTD Total 635,122 603,600 952,565 317,443 50.0% 348,965 57.8%
Fines & Forfeits by Type
Year to Date through April
2009 2010 2010 2010 vs. 2009 2010 vs. Budget
Month Actual Budget Actual Amount Percentage Amount Percentage
Civil Penalties 6,372 4,500 8,390 2,019 31.7% 3,890 86.5%
Civil Infraction Penalties 207,770 150,300 295,166 87,396 42.1% 144,866 96.4%
Red Light Photo Enforcement 273,664 377,800 478,184 204,520 74.7% 100,384 26.6%
Parking Infractions 49,748 15,400 68,053 18,305 36.8% 52,653 341.9%
Criminal Traffic Misdemeanor 32,931 38,700 31,624 (1,307) -4.0% (7,076) -18.3%
Criminal Non-Traffic Fines 47,547 36,800 43,928 (3,619) -7.6% 7,128 19.4% Criminal Costs 5,200 8,600 3,980 (1,221) -23.5°l0 (4,620) -53.7%
Non-Court Fines & Penalties 11,889 8,200 23,238 11,349 95.5% 15,038 183.4%
YTD Total 635,121 640,300 952,564 317,443 50.0% 312,264 48.8°l0
Annual Total 1, 920, 343 1, 870, 700
10
M®nthly Financial Rep®rt April 2010
Photo Enforcement
Year to Date through April
2009 2010 2010 2010 vs. 2009 2010 vs. Budget
Monfih Actual Budget Acfiual Amounfi 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 Jun 76,980 100,700
Jul 79,382 103,800
Aug 63,225 82,700
Sep 47, 897 67, 700
Oct 44,010 62,600
Nov 74,239 97,100
Dec 102,895 104,600
YTD Total 273, 664 377, 800 478,184 204, 520 74.7°l0 100, 384 26.6%
Annual Total 841,038 1,100,000
Miscellane®us
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 $465,800 and interest & investment and rentals & leases make up 86%
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.24% in April 2010. The increase in rentals & leases is primarily from Parks facility rentals.
Contributions & donations are high because of unbudgeted employee contributions. 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 April
2009 2010 2010 2010 vs. 2009 2010 vs. Budget
Month Actual Budget Actual Amount Percentage Amount 'Percentage
1 nterest & I nvestments 86, 643 82, 500 45, 665 (40, 978) -47.3°l0 (36, 835) -44.6%
Rents ~ Leases 92,733 72,900 115,926 23,193 25.0°l0 43,026: 59.0%
Contributions & Donations 7,588 5,000 18,243 10,655 140.4% 13,243 264.9%
Other Miscellaneous Revenue 27,281 15,900: 132,326 105,045 385.0% 116,426: 732.2%
YTD Total 214, 245 176, 300 312,161 97, 916 45.7°l0 135, 861: 77.1
Annual Total 664, 307 465, 800
11
M®nthly Financial Rep®rt April 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. April year to date revenue of $265,521 is $95,301
or 26.4% less than 2009 for the same period. This is $151.2K less than the budget for the year
and reflects the current slump in the commercial and residential market.
Real Estate Excise Tax Revenues
Year to Date through April 2009 2010 2010 2010 vs. 2009 2010 vs. Bud et
Month Actual Bud et Actual Amount Percenta a Amount Percenta e
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
Jun 141,704 163,600
Jul 106,672 123,200
Aug 115,268 133,100
Sep 179,067 206,700 Oct 314,172 362,700
Nov 184,935 213,500
Dec 87,440 101,000
YTD Total 360,822 416,700 265,521 (95,301) -26.4% (151,179) -36.3%
Annual Total 1,558,926 1,800,000
12
M®nthly Financial Rep®rt April 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 2,737,315 5,163,329 2,132,832 3,070,907 9,714 246,126 242,405
Rents, leases, and concessions - 208,776 43,940
TOTAL OPERATING REVENUES 2,737,315 5,163,329 2,132,832 3,070,907 218,489 246,126 286,345
OPERATING EXPENSES:
Administration 741,495 570,565 677,712 234,326 173,186 87,284 69,856
Operations & Maintenance 1,395,613 4,140,899 729,126 2,309,826 48 206,302 385,094
Depreciation & Amortization 706,210 461,835 367,200 6,845 72,510 19,066 112,987 20,333 TOTAL OPERATING EXPENSES 2,843,318 5,173,299 1,774,037 2,550,996 245,744 312,651 567,937 20,333
OPERATING INCOME (LOSS) (106,003) (9,970) 358,795 519,911 (27,254) (66,526) (281,591) (20,333)
NON-OPERATING REVENUES & EXPENSES
Interest Revenue 15,103 24,203 3,904 817 925 249 119
Other Non Operating Revenue 15,635 3,831 - 568 113,334 218 9,102
Other Non Operating Expense (100,000) (100,000) (100,000)
TOTAL NON-OPERATING REVENUES (EXPENSES) (69,262) (71,966) (96,096) 1,385 114,258 467 9,221
INCOME (LOSS) BEFORE CONTRIBUTIONS &
TRANSFERS (175,265) (81,936) 262,698 521,296 87,004 (66,059) (272,370) (20,333)
Contributions 154,336 100,469 90,662
Transfers In - 31,750
Transfers Out (58,600) (58,200) (62,800) (900) TOTAL CONTRIBUTIONS & TRANSFERS 95,736 42,269 27,862 (900) - - 31,750 -
CHANGE IN FUND BALANCE (79,529) (39,668) 290,560 520,396 87,004 (66,059) (240,620) (20,333)
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, April 30, 2010 58,501,412 64,351,360 39,911,052 2,096,783 9,774,657 1,048,016 5,261,154 1,453,608
Solid Waste operating expenses are low due to timing of invoices form Waste Management. April billing of $646,024 was posted in May.
13
M®nthly Financial Rep®rt April 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 - 865,848 1,300,692 819,389
Rents, Leases & Concessions - 47,497 42,648 - TOTALOPERATING REVENUES - 913,345 1,343,340 819,389
OPERATING EXPENSES: Administration 895,522 - - 169,944
Operations & Maintenance - 642,110 1,111,395 367,524
Depreciation & Amortization - - 171,021 354,882
TOTAL OPERATING EXPENSES 895,522 642,110 1,282,415 892,350
OPERATING INCOME (LOSS) (895,522) 271,236 60,925 (72,961)
NON-OPERATING REVENUES & EXPENSES
Interest Revenue 1,234 410 3,271 4,245 Other Non Operating Revenue - - - 23,350
Other Non Operating Expense - - - -
TOTALNON-OPERATING REVENUES (EXPENSES) 1,234 410 3,271 27,595
INCOME (LOSS) BEFORE CONTRIBUTIONS & TRANSFERS (894,287) 271,645 64,196 (45,367)
Contributions - - 10,950 -
Transfers In 238,600
Transfers Out - - (29,500) (22,400) TOTAL CONTRIBUTIONS & TRANSFERS 238,600 - (18,550) (22,400)
CHANGE IN FUND BALANCE (655,687) 271,645 45,646 (67,767)
BEGINNING FUND BALANCE, January 1, 2010 2,234,469 207,637 4,914,846 10,892,939
ENDING FUND BALANCE, April 30, 2010 1,578,782 479,283 4,960,492 10,825,173
The Insurance Fund expenses include $895,522 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,825,173 includes over $5.4 million infixed assets net of
depreciation which primarily consist of the City's fleet vehicles.
C®ntact Informati®n
This report is prepared by the Finance Department. Additional financial information can also be
viewed at our website: htt ://www.auburnwa.~ov/. For any questions about the report please
contact us at kjester(~auburnwa.~ov or scoleman(~auburnwa.~ov.
14
0o co co ~o N
N ~ n o5 M
G o o 0 0 o 0 0 Q ° o o~ o 0 0 0 0 o a M D ° D H Q f` p Q~ O~ M I~ ~ M~ I~ 00 H Q O N CO M M 00 LL') Lf) O L() N 07 H Q O~ ~ H Q ~ C [h W C ~ W~~ I~ O M (D CO ~ ~l o I~ r r r CD ~ M~
N~ N N O~ 6j ~ ~ i i N i i i i i i i i i~ o n1 ~ O o
X Q X
p o~ ~ p ~ co ~ ~n ~n co a~ m co o~ p c~~ ti N co o~ r ~n r r M r~ ti p co co ~n ~n p o~ ~ ~ ~ ~ CO ~ ~ ~ L(~ I~ ~ ~ C.O O~ O N CO Lf") ~ N ~ I~ Lf") ~ r LC') O I~ CO LC') ~ ~ ~ OJ ~
~ N 67 O~ ~ ^ ~ M R r N .r M ~ ~ ^ } N ~ LC') ~ 67 ~ I~ N O lfi ~ ~ } M O~ I~ 07 c*i O (.D N 07 CD 07 ^ C!' .r O N O N } O DO ~
O~ 67 N N C~'i ~ CO N LC') r N ~ I~ M O ~ O LC') O~ ~ N O L(7 ~ ~ LCj N ~j nl v, 0 0~ 0 ~ O CO ~ ~ ~ u i I~ N O c0 ~ O~ O W N 6) I~ ~ r r~~ M N ~ ~"1 O O O M O N E o r CO ~ N~ ~ ~ ~
N N ~ N~ N ~ M M r fD ~ r M
~ r ~ ~ ~ ~ ~
i~} fA EA EPr Q N L[) Q ~ O LL') N CO O 67 ~ r ~ Q Lf) CU 67 N I~ Lf) ~ ~ O 67 CO ~ Q M (D ~ ~ Q u7 ~ 07 f~ O ~ O ~ O 6) O Lf) L!) 6) ~ N N ~ ~ O 6) O Cfl O M O N M Ltd ~ ~ ~ CO 67 ~
cD ~ ~ Lt7 } ~ (D ~ } ~ 67 r N N N (D ~ M r^ } O r N O r L!') r O~ CO Lt7 } 00 O O H } C4
L[') CO ~ M N O 00 CO CO CO LL') M ~ I~ ~ O ~ N~ N O~ M N ~ 00 O O N~ ~ 67 00 lC') O ~ LL) I~ ~ O M 09 Lf) N O I~ O N N~ O M O 67 ~ W O O~ 0^0 O ~ ~ N M r N O r r N r ~ O r O O
M r ~
64 ifl EA 64 J M ~ J L[) CO CO ~ CO (O LL') ~ CO (O J CO 67 O N 00 f~ N~ M ti M M J N I~ N O J O a~ N~ a~ ~ N O Lf) M ~ ~ Lf) M N~ a O M O~~ O CD Lf7 O H O Ltd ~ a~ N Lf) O~ ~ a n
~ ~ CO O ~ ~ ~ ~ N ~ ~ M N 67 M O ^ to ~ l! i O~ N I~ ~ O r T T M N ~ ~ ~ N o0 ~ 6~ ~ t~ ~ ~ O W 67 O O W ~ O N 67 ~ LL') N r 00 ~ O CO N S W O N r I~ ti M ~ L O O ~ O T cD 00 G7 a1
~ M Lf) Lf) ~ 00 ~ M 00 N O Lf) O O 67 Cfl ~ CO ~ N N (D ^ ~D N ~ t9 O ~ M ~ N ~ M M ~ I~ 00 ~ N~ y M r N r CO ~ O~ 67 ~ y W~~
O N N~ O M ~ O nj y O ~ O~
•i ~ •i ~ i a ~ a .o ~ o ~ o
o ~ ~ ~ a ° ~ o~ ~ m ~ w
~ ~ ~ y ~ w V ~ r ~ ~ ~ V ~ 0 \
~ ~ ~ 41 h ~ ~ ~ Q ~ ~ ~ C
~ \ ~ ~ ~ ~ W ~ W ~ > > ~ J ~
> > Q a, N O O a, Q ~ O a ~ ~ L ~ W ~ ~ W ~ ~ ~ O ~ ~ ~ c °o ~ ~ O U ~ ~ N ~ ~ Q ~ ~ J O O ~ o J N N~ N m o d W ~ > v ~ J ~ E~ Q
~ ~ ~ W ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ D W J ci = ~ ~ D W LL y O z p ~ > ~ c o ca ~ m a fn m ~ ~ o
L w LL +J U L o y m ~ coi - ~ m m Q c LL a rU ~ ~ ~ LL N a s cn O ~ m n m m N=~° L~ c~~ m~ m m~ ~ W ~ y N~ O c ca o ~ ~ c cn c~ o o o ~ cn m w ~ ~ ~ 2 aS ~ ~ ~ Q °o ~ o m a c ~ m t6
~ m ~ c}a ~ .S > w ~ z
Q V xS a ~ E Q ~ c m vi ca ~ J ~ ~ ~ m ~ ~ ~ c ~ U ~ w O m mQ ~•~~maxSC~~ ~ oxS ~ a~ c c to c o Z-aN c m~ ~J > C J ~ o off ~ ~ <6 ~ a J ~ ~ W N ~ c N ~ W E Uj Q J ~ ~ ~ vNi W
o c`na p ~ ~ °o a~i a n aci o p ° ~ a~i ° o ~ ~ a~i ~ ~ ~ ~ p c c N ~ ~t~~ wwmw=UcnC~~z~ ~LL~aUQ W 2000aH ~Q~~~
L ~ f~ N M~~ O O ~ N M~ ~ ~ ~ ~ ~ ~ ~ ~ ~ N
~~.i ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ L[) Lf) Lf) Lf) r N M ~ L!') Cfl r N r N r N O r N 67 r ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ L!7 Lf7 Lf7 Lf7 L!") Lf7 CO CO I~ ~ CO 07 p ~ ~ ~ ~ Q~ z z ~ N d
N ~ ~ ~ ~ a
W r M ~ ~ N ~ w a waaaaaaaaaaa aaaaaaaaa w a as ao ~ as
J N D o h o G. o 0 0 0 0 0 0 0 0~ o~ o~ o 0 0~~ o o Q o~~ o o p G ~ 0 0 Q ~ D CO O O ~ Q O~~~ O O O lC1 N N O~~ N N u i N M O CO M ~ Q Q M~~ a0 Q N~ ~ Q~ N~ ~ ~ o W ~ ~ ~ o ~ M o0 ~j
O (D ~ ~ N ~ M N O N ~ r I~ O N O `r o Z N h1 ~ Z ~ 67 ~ o ~ ~ \ , M, \ LC1 N M~ I~ ~ M~ ~ 00 r 0 CO ~ O O r i N M M \ N N N ~ ~
L
Q ~ ~ N ~ ~ ~ ~ ~ ~ ~ o c i ~ ~ cNY, cc~'~ ~ o u`Y'-, ~ c°v ~ o ~ ~ o ~i ~ ~ ^ ~ ~ ~ ~ ~i cNV ~ ~i ~ ~ ~ ti ~ ~ ~ ~
} I~ N ti ^ } LCi ~ Lf i CO ~ r'i I~ ~ Lfi ti O M N O O lf'i O ~ o~ M } 6) N ~ ~ 67 O M ~ ~ r ~ CO ~ 67 LCj ~ ~ ~ CyJ L(") r C{J ~ (.p Ltd cY7 O ~ O ~ N ~ M CO ~ O~~ ti CD ^ O ~ ~ ~
CD Cp O W ri O O H u7 p ~ ~ r r N~ r ~ M ~ ~ ~ ~ {g r M y~
fA b9 fPr £9 Q LC•) Lf) O Q I~ 67 M 67 ~ M 00 N W I~ ~ CO CO ~ L!~ CO r I~ ~ ~ CO Q O Lf) M Lf) CO N LC') M Q CO N M
~ CO f~ M ^ ~ N O ~ ~ O M ~ O L!i CO O CO 6~ O ~ 6~ ~ O ~ Lf) ~ O ~ ~ cD O W ~ M O ~ N ~ LC) ~ } W ~ O ^ } N ~ N ~ lfi L[) I~ O Lf) 00 c0 N ~ cfl I~ CO M M M ~ } CO ~ f~ ~ ~ } Lf) N
~ ~ 67 f~ O ~ ~ N O N M M r N N M N N 00 M O ~ N Lf) O~ D O M 00 M ~ r r CO M ~ ~ ~ 67 Lf) ~ N ~ ~ r N M
69 ~ ia4 ~ ~ ~ ifl J ~ 67 CO ~ J I~ O~~ 6) ~ ~ I~ ~ O L! i M O N N QO L! i O~ 00 I~ M ~ J O f~ O~ O O~ cD ~ J O N ~
a ~ O a~ 67 ~ LL') I~ cD ~ 67 B O O CO I~ O M 67 67 r I~ O N d'7 a ~ 67 W 67 ~ N ~ a~ Lf) ~ ~ 00 N N y ~ O O N M N ~ 6) lf) ~ 6) cfl N lfi N I~ l[) N W ~ W~ y ~ ~ O O ~ ~ O N ti~ O lC1
O N O O N M ~ ~ O ~ O CO 67 LL') N O O N~ N~ O O 00 f~ M ~ O O 67 67 M ~
M ~ M O
4 O ~ ~ 0
~ ~ ~ ag ~ bs ~ ag ~ es V V ~
V ~ Z ~ V 'i ?
~ O u~j V = O t
o ~ a ~ W ~ z V z ~ N ~ ~ ~ h Q O ~ ~ ~ ~ ~ m ~ ~ m ~ ~ ~ J
p ~ ~ c c C7 ~ c f~j ~ ~ U ~ N ~ ~ ~ ~ U ~ v ~ Z ~ Z ~ ~ cn °o Y H L L cn ~ •L ~ O ~ ~ L W p o o z ~ o o ~ ~ o o~ L c ~ z ~ ~ con V1 ~ J o b X 0 0 ~L O~ rt e! O O V /~L ~ ~ n~ o~ ~ o~
^ L c a n a~ o ~ cn cn o 2 o a~ c ~
~r ~ ~ ~ L a LL Q~ C ~ L ~ LL 'L V Q~ L ~ O a ~ L L ~j O Q /1~ ~ L rV / C V Q O~ Cn L p 7 O~ O a~~ c Q a s 7 H a/ C a Q ~ fJWJ V~ (6 V_ Q z~ N o p z .C ~ L c •i a ~ w ~ c~~~~ c U O c
o w a c o 0.~ J~~ c a O m o U ~ c ~ ~ ~ a ca ~ ~ ~ ~ L m ~ ~ ~ ~ a a? m a a c o c}a ~ ~ a~ v~ a O c~ ~ ° ~
U~ U m H a~~ ~ o~ m c g~ c~ w co ~ w y°~~ o~ cn c`nn ~ 2 L c ~ H o' ~z ~ N~ az a a QNc~ a•~~ ~a ~oz w J o ~O o c ~ amxs oaC ~ c~ ca ~ ~ m m a cv
U U ~ N L ~ oZf ~ t0 oZf ~ ~ (6 ~ ~ L N W L ~ c C ~ !n C ~ ~ L ~ ~ ~ H (6 (6 (B ~ ~ of ~ ~ a L ~ ~ 7 ~ N C L6 L O J ~ ~ N N N ~ L ~ N U N U c 7 ,L a ~ ~ J ~ L ~ a ~ ~ ~ J ~ ~ ~ J N cn
> ~a ~ m ia~~ m~ o ca a cn ma L~~ cn cn ~ a ~
c ca a~ ~ o > x x a ~ o a •c ~ a~ ~ c ~ ~ ~ ~ ~ cco ~ ~ ~ ~ ~ ~ ~ N ~ ca ~ ~ ~ ~ 2 v=cn~ ~m~~Q~~aaavaza~~Uw~~i~~ Q~~~~av~~ ~ ~
~ CO f~ O ~ N M~ Lf) (O ~ N M~ LL') CO I~ ~ N M~ Lf) O~ 67 ~ N~ lC1 O ~ N M M~ LC) M M M ~ ~ ~ ~ ~ ~ N N N N N N N M M M M M M M M 00 00 00 00 00 67 67 67 N N N U N N N M M M M M M M
M M M M M M M M M M M M M M ~
zl
City of Auburn
Investment Portfolio Summary
As of April 30, 2010
Investment Purchase Purchase Maturity Yield to
Type Date Price Date Maturity
State Investment Pool Various $ 67,993,229 Various 0.22% KeyBank Money Market Various 7,470,950 Various 0.10%
US Treasury 05/04/1990 57,750 05/15/2016 5.72%
FHLB 7/24/2008 1,022,000 5/26/2010 4.520%
FHLB 2/2/2009 1,000,000 2/2/2011 1.540%
FHLB 2/2/2009 1,000,000 8/2/2011 1.840%
FHLB 8/11/2009 1,000,000 5/11/2012 1.240%
FHLB 11 /24/2009 1, 000, 000 11 /21/2012 1.000%
FHLB 12/29/2009 1,000,000 6/29/2012 1.375% FNMA 2/19/2010 1,000,000 2/19/2013 1.500%
FNMA 2/19/2010 1,000,000 2/19/2013 1.500%
FNMA 2/19/2010 1,000,000 2/19/2013 1.500%
FHLB 3/24/2010 2, 000, 000 12/24/2012 1.550%
FNMA 3/25/2010 2,000,000 3/25/2013 1.850%
Total Cash & Investments $ 88,543,929 0.000%
Investment Mix % of Total Summary State Investment Pool 76.8% Current 6-month treasury rate 0.24%
KeyBank Money Market 8.4% Current State Pool rate 0.24%
US Treasury 0.1 % KeyBank Money Market 0.10%
FHLB 9.1% Blended Auburn rate 0.00%
FNMA 5.6%
100.0%
16