HomeMy WebLinkAboutITEM IV-C
ca~nr oF
AGENDA BILL APPROVAL fORM
WASHINGTON
Agenda SubJect May 2010 Fnanaal Report Datec 7/14/2010
Department finance Attachments: May Monthly Report Budget impact: 0
Administrative Recommendation: Background Summary:
The May 2010 status report highlights City revenues and expenditures and is based on financial
data available as of June 23, 2010. Sales tax reported in May is for business activities ttiat.
occurred in March 2010.
Total General Fund revenues for the City at the end of May were $23,284,129 which is
ap~roximately 47% of the annual budgeted revenues. Streamlined Sales Tax mitigation for #he
2" quarter of 2010 was posted in June 2010 and the yeac to date sales tax amount was
adjusfed to include $325,542 total SST mitigation for April 8 May. Compared to budgeted year-
tadate revenues, total General Fund revenue is $1.11 M(5%) more due to timing of receipts of
intergovernmental revenues coupled with increases in traffic infraction & photo enforcement
revenues.
Expenditures for the General Fund totaled $19,635,610 which is $2.68 M(12 under budget
at the end of May. 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
intergovemmental services are paid out in later periods.
Revlewed by Council 8 Committees: Reviewed by Departmerrts & Divisions:
❑ Arts Commission COUNCIL COMMITTEES: ❑ Building ❑ M&O
❑ Airport ~ Finance ❑ Cemetery p Mayor
❑ Hearing Ecaminer ❑ Muniapal Serv. 0 Finance ❑ Parks
❑ Human Services ❑ Flanning & CD p Fire ❑ Planning
❑ Park Board ❑Public Works ❑ Legal ❑ Police
❑ Planning Comm. ❑ Ofher ❑ Public Works ❑ Human Resources
❑ Infermation Servioes
Action: "
Committee Approval: ❑Yes ❑No
Caunal Approval: DYes ❑No Call for Public Hearing
Referred to _ Urrtil ~
Tabled Until
Councilmember: Backus Staff: Coleman
Meetin Date: Jul 19, 2010 Item Number.
uBj)RN:*NIORE THAN YOU iMAGINED
~
Monthly Financial Report May 2010
. ' C+"efleral Eurni` iQ a 2,atD~YF1El~. . e~VS:, Sou , , Fevoi ri+ WW.cLfd~ro~We '
r.
OPERATING RFlENUES
Properly Tax 12.357,309 6,310,200 6,531.141 220.941 72.4%
Sales Tax Q) 14,255.000 5,986;700 6.129,887 143,187 Sales Tax - Annexation Credit 1,453,500 616,500 ' 563,175 . (53,325) -8.6%
Criminal Justice Sales Tax 1.143,300 484.600 521,619 37,019 7.6%
Brokered Natural Gas Tax 260,000 142,400 141.226 (1,174) -0.8%
City Utilities Tax 2,140,200 908.200 984,010 75.810 8.3%
Admissions Tax 400.000 178.000 143.800 (34:200) -19.2%
ElectricTax , 2.794,100 1.526,200 1.586,935 60,735 4.0%
Naturel Gas Tax 14245,500 834,200 633,305 (200,895) -24.1°Yo
Cable N Franchise Fee 676,300 337,700 . 387,036 49.336 14.6°ib
Telephone Tax 1.734.200 718,600 888,861 170.261 23:70/o
Garbage Tax (extemal) 100,000 40.200 63,470 23.270 ' 57.9%
Leasehold Excise Tax 80,000 43,600 10,397 (33,203) -76:2%
GamWing Excise Tax 766,500 375,800 178,662 (197,138) -52.5%
Business Ltcense Fees 200.000 22.900 18,248 (4.653) -20.3%
Builcring Pertnits 700,000 283,200 322,367 39,167 13.8%
Other Ucenses & Permiis 188.000 70,000 157,301 87.301 124.7%
lntergovemmentai (Grents, etc) 4,388,740 1.358,800 1,667,543 308,743 22J0k
Chacges for Services:
Generel Govemment Services 113,000 52.200 41,860 (10,340) -19.8%
Public Safety 244.000 - 116,500 103;332: . (13,168) -11.3%
Development Services Fees 857,000 340,400 223.168 (117.232) -34.4%
Culture and Recreation 821,000 399.600 397,803 (1.797) -0.4%
Fnes and Forfeits 1.870,700 769,400 1,181,167 411,767 53.5%
lnterests and Other Earnings 170,000 95.900 68,514 (27:386) ' -25.6%
Rents. Leases and Concessions 223.000 93,400 130,962 37.562 40.2%
CoMributions and Donations 26,600 7,700 22,803 15,103 196.1%
Other Miuellaneous 46,200 20.800 , 137,811 117,011 562.6%
Transfers in 17.000 17.000 ' 17.000 - 0_0%
lnsurence Recoveries- Ca ital & O rati 55,000. 22,900 30;729 7,829 34.2%
TotaL Operatirig Revenuet 49,326.149 22.173.600 ' 23;284,129 1,110,529 5.0%
Operating Eitpenditures
` Council & Mayor 738.900 323,700 277.293 46,407 14.3%
Municipal CouR & Probation 3,055,280 1.250.880 1.056.065 194.815 15.6%
Human Resources 736,150 311,250 279,845 31,402 10.1610
Finance 1.170,960 484.860 479,868 4,992 1.0%
City Attomey 1.636,050 764,450 726.559 37,591 5.0%
Planning . 3,081,470 1,415,570 1,329,973 85,597 6.0%
Community & Human Services 1.050.400 399,900 391,034 7.866 2_00k
Police 23,429,315 9,680,015 8.687,885 992.130 102%
Engineering 2.941.610 1,306.310 1.011,410 294,900 22.6%
Parks and Recreation 6,766,200 2,802,200 2.663;252 138,948 5.0010
Stre ets 3,093.500 1.273;700 1,100,768 172,932 13.60/a
Non-De rtmentaL 5,821.200 2.307.000 1.631,655 675,345 29:3%
Total O ratl bc enditures 53,521,035 22.318,835 19,635,610 2.683.225 12.0°/a
(i) The anticipated 3treamlined Sales Tax Mitigation for 2010 is $1.966,755. The year to date actual sales tax amount
is adjusted to indude .$489.227 SST Mitigation the City received from the State for lrt the. quarter of 2010 and
$325,542 SST Mitigation for April & May based on $488,313 2nd quarter revenue received in June.
2
I •
Monthly Financial Report MaY 2010
Overview
This financial overview reflects the City's ovetall financial position for the fiscal year through May
31.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 IMay, the.combined collection of property.,tax; sales/use tax; utility tax, gambling, and
admissions tax .represents 80% of, all resources supporting general governmental aetivities. The
followingsection provides detail information on properly and sales taxes.
ProPerhf Tax _
Year to date collection at the, end of May.is,$6,531,141 or'52.9% of the $12,357,509 annual
budget. Compared.to 2009..the City.collected $1.117,449 or 20.6% morefor the same period....
..At the end of the May, property tax revenue is $220,941 or 3.5%more than the year to date
-'budget and is in line with -the budget. -
fi
' 2009 2010 2010 2010 vs. 2009 ; 2010 vs. Bud" et
Month Actua! Bud et Actual Amount Percenta e Amount Percenta e
Jan 38.602 45,000 27.735 10,867) . -28.2% 17,265 -38.4%
Feb " 111,495 930;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%
A r. 4,188,834 4,882,400 41877,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 441000` : -
Jul 21,078 24.600 .
Au 32;632: , 38,000 '
Se 196.787 _ 229.400
Oct 31836.015 ` 4.471;109
' Nov 1,017.258 ' ' 1:185.700
Dec 46:566 54;300 "
YTDTotal _ 5.413.692_ 6.310 200-_-, 6.531,141 11117:449 20.6°k . 220.941 3.5%
Annual Total. .10,601.791 12.357.309 . . : .
3
Monthly Financial Reporf May 2010
Sales Tax
As of the end of May, the. year to date sales tax revenue of $6,129,887 is $354.3K more tfian.
2009 and $143.2K more.than the current YTD budget. At the end of the ln quarter the City has
received $489,227 of the.totalantiapated SST mitigation of $1,966,775 for 2010. Total
Streamlined Sales Tax mitigation for2^d quarter of $488;313 was posted.in June and actual
monthly totals for April and May was. adjusted to include each month's, prorated share. The
actual amount of SST mitigation the City will receive from the Sfate is redueed by taxes received
from companies that have voluntarily complied with the new destination based sales tax.
2004 2010 .2010. ~ 2010 vs:.2009 2010 vs: Bud ef .
Month Actual Bud et * Actual * Amount Percenfa`e : Amount Percenta e , ~
Jan ` 1;232,999 1,213,000 1.128,608 (104.391) -8.501o (84.342): 7.0%
Feb 1,279,532 1,372;300 11303.518 23,985 109% (68,782) -5.0%
, Mar . 1,0594642 1.085,700 1,012.173 (47.469 - -4:5% 3,527 =6:8%
A r 1,041,972 1,066.300 1,495;567 453,595 43.5% 429.267 40.3%
M 1,161,471 1,249,400 1,190>02T 28,550 2.5% (59,379) -4.8%
Jun = 1.098.038 1,144.900
Jul _ 1:152;738 1;180.300
Au . 1.250,264 -1,302,700 •
Se . 1,148,525 1.14Z,700
Oct . 1,254,457 1,200,400
Nov 1,197,153 1,175,200
Dec 1,065,935 1,117,100 _
YTD Total 5,775,616 , 5,986,7_00 6.129,887 ` 354,271 6.17, 143.,187 2:40/o
Annual Total 13,942,728 14,255,000
*Indudes 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.
CO~~EGt~ C1S°~Z5~ _
Year~a
l,~
2009 2010 - Chan e from 2009 :
•.Com onent Grou --._Actual Actual Amount. Percenta- e
New_Construction _ _ ~ 546,256 515.109 (31,147) -5:7%
Manufacturin 177,168 155,115 (22,053) -12.4%
Trans ortation.& Warehousin 13,102 13.009 _ (93) - -0.7% . : .
Wholesale Tracle : 428,433 468,659 40,226 9.4%
_ Automotive . 962,037 985,420 ' ' 23,383 2:4% .
Retail Trade " - 1,559.352 1,532,967 (26.385) -1.7%
Services 1,249,498 1,606,334 356,836 28.6%
Miscellaneous . 16,368 72,621 56,253 343.7%0
_
YTD Total 4,952,214 5,349,234: 397,020 8.0%
Utilitv Tax
4
Monthly Financial Report May 2010
Thir revenue source consists of City inter-fund utility taxes (Water; Sewer, Storm and Solid Waste)
and external utility taxes (Electric. Nafural gas, Telephone and Solid Waste). Year to date u#i.lity
tax revenue is $4,156,580 which is $556.2K (11.801b) less than 2009 primarily due to the City
Interfund, utility taxes and`a decrease in the Natural Gas utility taic. 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
Natu. ral Gas utility tax. Overall, the 2010 adual revenues are greater by $129.2K or 3.26/o more
than budge#ecl #ax revenues. The main source of this increase is attributed to higher revenues in
the telephone utility tax. An acijustment to increase estimated revenues for telephone utility tax
by $200K is included in the mid year 6udge# amen.d.ment and will be reflected in June.
. ~ :
ea~ to Date~t oug„ lvt~y
G 2009 _ 2010 2010 2010 vs: 2009 2010 vs. Bud et
Month Actual Bud et - Adual_ 'Amount Peccen e:. Amounf _ Percenta e-.
1an 1.329.027 1;188,200- 1;258,792 0,236 =5.3% 70.592 . 5.9°k
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%
A r 1,911,964 1.738.100 1,505.874 (406.090 -21.20% 232,226 -13.4%
Ma 575,114 436,000 492,247 (82,867) -14.4% ' 56.247 129%
Jun 441,229 325,200
-Jul 1,340,355 1,195,700 -
Au 621,691 469.600
Se 453,881 336,100 Oct 1,123,629 980.000
Nov 516.516 397,200
Dec 376.459 282.800
Yl'D Total 4,712,787 ' 4,02Z,400 4,156,580 (556,207) -11.8% 12.9,180 3.2%
Annual Total 9.586,547 8,014.000
The following table presents utility tax by source:
tlttl
~ ~ IIIINT
~
' 2009 2010- 2010 2010vs. 2009 2010 vs. Budget
Morrth _ Actual B et Adual Amount Percenta e. Ainount - Percmtage
Ci Interfund Utili 'Taxes 1,303,326 908,200 984,010 (319:316) -24.5% 75,810 8.33/o
Eledric 1,639,293 1,526,200 1,5.86,935 (52,358) -3.2% 60,735 4.0°k
Na#ural Gas 828,684 834:200 633,305 95,379) -23.6% 00,895 ' -24.1%
Tele hone 880.546 718,600 888,861 8,315_ 0.9% . 170.261 23:70/o
Solid Waste 60,938 40,200 63.470 2,532 4.2% 23,270, 57.9°!0
YTDTotal 4,712,787 4,027.400 .4,156.580 (556.207) =11.8% _ 129,180 3.2%
. .
Annual Total 9,586,547 8,014,000 -
Cable N Franchise Fees are received quarterly and are shown on the.table below. This is $14.4K
or 3.9% more than the previous year for the same period and is $49:3K or 14.6% greater than
the 2010 year to date budget.
5
Monthly,Financial Report May 2010
- -
~~'ab~l`e~T7TV
Fr chiwFee " ear f ,a~a t u
2009 _.2010 2010 4 _ 2010 vs. 2009. 7 ..2010; vs. Bud et
Month` . Actual Bu et Actual . Amount Peitiefte _:-Amount . Percenta e
r- .
. Jan ~ - _ _ 188,592 ' 170,900 ` . , . . _ . . _
- (1$8;592) -100.00/6 (170,900) -100:00/0
Feb - - 193,004 193.004 N/A 193.004 N/A
. IVlar - - WA - N/A
- A- r 194,032 194,032 N/A 194.032 N/A
Ma 184.011 166.800 - (184,011) -100.0% (166.800) -100.0%
_ Jun _
1u1 186,766 169,200
Au - -
Se
Oct 186.910 169,400
Nov _ _
Dec .
"YTD Total 372;604 337,700: 387;03614,433 _ 3..93/7o49.336
~MnualTotal' -7461280- ~ ~676.300 ~ licenses and Permits
This revenue source is comprised of business licenses, building permits, plumbing, electric and
other Iicenses and permit fees. At the end of May, the City has collected.31% of the annual
projected _revenue from licenses and permits. Building permit fees and Business Jicenses make up
83% of the annual budgeted revenue in this category and.the following tables present detail
information for each.
~ U .r ~l'~ O BE1il f~FC~1~81'R1ItS
~ q fi ka"a~ 8tE~II ~ r~~~~ `l. ..sA :
2009 2010. 2010 2010 vs. 2009 _ p. 2010 vs. Bu et
Month " Actual Bud et Actual Amount Percenta e Amount Peraenf e
Jan 17,047 69,800 88.175 71.128 417.20/o 18,375 26:3%
' Feb 30,070 30,500 49,731 19.661 65:4% 19.231 -63.1% ,
Mar. 34.273 84,000 43J96 9,523 27.8% (40.204 -47.9%
' A r 85.717 51,800 44.422 41.295) -48.2% (7,378) , -143%
Ma 44,732' 47,100 96,244 51,512 115:2% 49,144 ' 104.3%
, Jun 158.105 49.800
Jul 90.765 62,900
' Au 54,856 = 96,200
Se 42,615. 68.300
Od: 83,041 ' 45.300
Nov 56,606 38.200 "
_ Dec . 137.651 56,100 -
I YTD_Total_ - -
I, 211,.839- „_283,200, 322,367 110.528 52.2% 39,167 13.80
._Annual Total 835,478 700.000
Total buitding permit revenues at the end of May were $322,367. This was $52K greater than
2009 for the same period and $39.2K oe 13.8% more than budgeted revenues. The increase
from 2009 is primarily due to the developments at Trail Run and North Tapps Estates.
6
IVlontF~ly--Financial Report _ May 2010
Business License revenues at the end of May are $5.6K or 23.4% less than 2009 and $4.7K or
20.30/o 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 in June.
JWAaM~a'
e g E111MUNIM ~ y . 2009 . . 2010 . 2010 . ^ 2010 vs. 2009 ` . 2010 vs. Bud et
Manth :Adual Bud et -`.Actual Amount- Pircentake, Amounf Percenta
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.00/o
Mar 4,706 4.500, _ 3,627_ (1,079). -22.9% (873) -19.4%
A r 3.952 3,800 4,342 390 9.9% 542 14.3%
Ma 4,289 4.200 1,987 (2,303 -53.7% (2,214) -52.7%
Jun 102,500 98.000
Jul 49,110. 47.000
Au 12.061 11,500
Se 6.271 6.000
Od 6;277 6,000
Nov 5,229 ' 5,000
Dec ' 3:810 ' 3.600
_ .
YTD Total 23,831 22,900 18.248 (5,584) -23.4% (4.653) -203%
Annual Total 209,089 200,000
Intergovernmental
Revenues in this category include Grants. (Dired & Indirect Federal, State and Local) State shared
revenues and,compact revenue from the Muckleshoot Indian Tribe. May receipts are greater
than budgeted revenue mainly due to the Muckleshoot compact that is budgetecl conservatively._
Timing of grant revenue varies as they are processed on a reimbursement basis.
' r ~ • kr WYea flt@F, it1' 1;[OU~ c~...F:'. 20092010 ~2010 2009Vs 2010 2010 vs.Bud et
Revenue Aciual Bud et Actual °Jo Chan e % Cfian e
Federal Grants 21,737 63,900 ' 133,264 513.1% 108.6%
State Grants 28.032 20.100 38,636 37.8% 92:2%
Inferlocal Grants 16,667 46,200. 88,425 N/A 91.4%
State Shared Revenue 968,301 1,002;200 1.038,987 73% 3J0/o
. Mucklesfioot Ca3ino_ Eme . 323.222 - 226,400_ 368,231 13.9% 62.6%
_ , . . _ . _ _ . .
YTD Total 1,357,958 1,358,800. 1,667.543 22.8% 22J%
xa.., , , , .».,,..,,...P . . ,w. . . .,R
Annual Total 4.499.411 4,388,740
IYTD % ~.w 30% 31% 380%
Total state shared revenues are greater than 2009 for the same period due to the increased
Motor Vehicle Fuel Tax revenues and #he timing of Trial Court lmprovements revenue. This
revenue was not received until:June in 2009. Compared to budget, revenues are greater by
$36,787 or 3.7%. Income from Crimina! Justice-Special programs and Liquor profits were
budgeted conservatively and contributed to the.overall increase.
7
Monthly Finanaal Report May 2010
state SE►ared Revenues
Year tu Daie thrmough
MayY
2009 2010 2010 2010 vs. 2009 2010 vs. Bud et
Revenue Actual Bu et Adual Amount Percent e Amount PerceMa e
Trtal Court lm rovements 6,000 11,360 11,360 N/A 5.360 89.3399
Court Inte reter Pro am 10,205 - 0,205 JA - N/A
Motor Vehide Fuel Tax 564,131 590,100 574,857 10,726 1.9% 5,243 -2.6%
Crtminal Jurtice -Po ulation 32,452 33,600 34,040 1,588 4.9% 440 1.3%
Criminal Justice -Spec, Pro . 26,876 16,100 28,009 1,132 4.2% 11,909 74.0%
State DUl 5,964 2,000 6,288 324 5.4% 4,258 214.4%
Li uor Exdse Tax 162.338 162.900 167,432 5,094 3.1% 4,532 2.8%
Li or Proftts 106,658 131.500 153.457 46,799 43.9% 21.957 16.79
YTD Totai 968,301 1,002,200 1,038,987 70,686 7.3% 36,787 3.7°rb
Annual Total 2.465,986 2.594 740
Charges for Services
i This revenue source consist of general governmental services, public safety, developiment 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 May $766,162 or 37.6% 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 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.
Probation fees account for $86K of the $103.3K received to date for this category and is 11.3%
less than budgeted revenues as of the end of May.
Chacgex for Setvices by Type
Year to Date thmugh May
2009 2010 2010 2010 vs. 2009 2010 vs. Bu et
Revenue Actual Bud et Adual Amount Percent e Amount Percenta e
General Govemment 55,457 52,200 41.860 (13,597 -24.52% 0,340 -19.81%
Public Safety 120,004 116,500 103.332 6,672 -13.9°0 3,168 -11.3%
Develo ment Services 196,486 340,400 223.168 26,682 13.6°rb (T17,232 -34.4%
Culture & Recreation 404,989 399.600 397,803 ,186 -1.8% (1.797 -0.4%
YTD Total 776,936 908,700 766.162 (10.773) -1.40k (142,538) •15.70/a
Annual Total 1,683,495 2.035,000
D
eveIopment Services include Engmeering fees, zornng & subdivision fees and plan check fees.
Year to date revenues total $223,168 and is 13.6% or $26.7K greater than 2009 for the same
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, total development service revenue is less than the budget for the year by $117.2K
or 34.40/o due to lower than anticipated engineering fees revenue. The mid year budget
amendment includes a redudion of $155K for engineering fees to reflect actual receipts.
8
Monthly Finanaal Report May 2010
. _ ~ etop e c"e'Fees -
2009. 2010 2010 ' 2010 vs. 2009 2010 vs. Budget,
Month Actual Bu et Actual . Amount Percenta e' - Amount Percenf--e
- Jen-- : - 51.833 -89.800 - 39.755 (12.078) -23.3% . 50.045 -5567% ~
. Feb 46.818 - 81:100 53.677 . 69859 14J0/o (27,423) - -318%
. Mar 29,147: 5OS00 82.904 - 53.757 184.40/o 329404 64.2%
A r, 45.2381"78.400 28.762 ` (16,476) -36.4% 49,638 -63.30/o
Ma 23;450 . 40.600 18,069 5;381 -22.90/o 22,531 .-55.5%
Jun 86,974 150.800
Jul , , . 42.644 73.900 .
Au 53,060 929000.
Se 32,404 56.200
Od. 15.079 26.100 '
Nov 26,650 46.200
Dec 41.227 71.400 .
Yl'DTotal_. _ _196,486 340:400_ . 223.168 _ .26.682 13.6% 017,232)_ -34.4%
. Annual Total 494,524 ~ 857,000~
Culture & Recreation revenues consist of theater ticket sales, recreational classes, arts commission
and senior,citizen program fees.. Revenue for #he month of May shows a decrease from 2009
and is mainly due to decrease in the Bravo ticket sales.
N" CWturew&~eaeaeon~
Datett~rocegh Maj+
2009 2010 2010 2010 vs. 2009 2010 vs. Bud et
Month ` Actual Budget Actual AmouM Percent e Amount Percenta e
7ari .711561 70,600 659917 - (51644) -7.9% (4.683 =6.6%
Feb 51;878 51,200 57,959 6;081 11J0/o 6,759 13.2%
' Mar 124.525 122.900 133,930 9:405 7.6% 11,030 9.0%
A r 81,520 80,400 ` 69,877 1.643 -14.3% 0,523 =13.1%
Ma -75,505 74.500 70,119 5;386 -7.1% 4,381 -5.90/o
'
Jun 90,011 - 88,800 -
Jul 77,622 76,600
Au 66,639 65,700
Se 61,305 60,500
Od 41,086 40,500 '
Nw 44,066 43,500
Dec 46,428 45,800
YfD Total 404,989 399700 397,803 (7,186) -1.8% (1,797) -0.4%
~ _ . .
Annual Tota! 8329146 821,000
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 $371,570 or 45.9% greater
than 2009 for the same period and $411.767 or 53.5% higher than the projected year to date
budget. The overall increase is primarily due :to the rise in the traffic infradion and Photo
enforcement revenues. Traffic and parking infradions revenue are budgeted conservatively and
contributed to the overall increase between the year to date adual revenues and budget.
9
Monthly Financial Report , May 2010
SOWFc ' `
Rig
2009 ' 2010 . 2010 2010 vs. 2009 2010vs. Bud et
_ Month Actual __Bu et Actuai,_ Amounf__ Percenta e . Amount . , Percenta e
Jan 148.141 140.800. 236.675 88153459:8% 95.875 68.1°k
Feb. ~ 153,213 145,600 223,295_ 70.08245.7% 77.695 53.40/o
Mar 168,348 160.000 252,739 84.391 " 50.1% 92.739 58.0%
r 165.420 157,200 239,856 74,436 -45.0% " 82,656 ' 52.6%
Ma 174.475 ' 165:800 228.603 54,128 31:0% 62.803 37.9%
Jun 168,280 159,900 - Jul -159.112 151,200
Au 144.593 137.500
Se 163,212 155.200 . ,
Od ` 143;517 136,500
Nov 167.497 159,200
Dec 212:349 201.800 _ _
YTDxfotal . " . 809.597-: 769.400 . 1;181.167 ' 371;570. . 45.9% - -417;767 53.5%
Annual Total 1.968.157 1.870.700 '
Fin s &~_.ocfetts`~byT~~:~~ ~ A
~
_vY ar~to Daie~ttuo~. itay,
2009 2010 .2010 2010 vs. 2009 2010 vs. Bud et Month Aciual Bud et Adual Amount Percent e Amount Percent ke
Civil Penalties 8,216 51800 10,324 2,108 25J% 4:524 78.00/o
.
Civil Infraction Penalties 266:919 193,100 354,430 87,512 32.80/o 161,330 83:5%
Red Li ht Photo Enforcement - 352,410 480,800 595,926 243,516 : 69.1% 115,126 _.__23.9%
Parkin Infractions 63,718 19,700 83,383 19,665 30.9% 63,683 ` 323.3%
Criminal Traffic Misdemeanor_ 41,705 49,000 44.629 ' 2,924 7.0% (4,371) -8.90/o
.
Criminal Non-Traffic Fines 57,438 44,500 _ 53,736 (3.702) -6.40/o 9,236 20.8%
Crirtiinal Costs 5.837 9,600 - 4.981 (856 -14.7% (4.619 -48.1%
Non-Court Fines & Penalties 13,353 9,200 . 33,759 20.406 , 152.8% 24559 266.9%
YTD.Total _ 809,596 811,700 1,181,167 371.571 45.9% 369,467 45.5%
..~~__W_
Annual Total 1;920343 1,870,700 10
Monthly Finanaal Report May 2010
t~o ~n ccein t
t
2009 2010 2010 2010 vs. 2009 2010 vs. Bud et
Month Actual . Bud et Actual Amount Percent e' Amount Percent e
Jan , 73,432 101;000 134.182 . 60.751 82.79i6 33,182.. 32.90k
Feb 62.632 91,900 103.153 40.521 64.7% 11,253 12.29/0
Mar 67,543 93,300 118,358 50.815 75.2% 25,058 26.9%
A r 70.057 91;600 122,490 52,433 74.8% 30.890 33.7% ,
Ma 78,746 ' 103.000. 117.742 38,996 49.5°k 14.742 14.3°k
Jun 76,980 100.700
1ul 79,382 103.800.
Au 63,225 82.700
Se 47.897 67.700
_Oct 44,010 ' 62,600 -
- Nov. 74.239 ' 97:100
Dec - 102,895 104.600
YTD Total . 352,410 48P.8001 595,926 243.516 69.1% 115,126 219%
Annual Total 841.038 _1,100,000
titiscellaneous
This revenue source is comprised of interest and other investment eamings, rents, leases &
concessions, contributionr & 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 Investrnent Poot, interest has decreased from 1.27% in January 2009 to
0.27% in May 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.
F k~ib ~t^+ ~t3C ~ "S. '~F Y 3.i. 3.-C ~r a
~SCE~~B ~#'11l25 j,}Ip~~~~~~~
Year~to Date,throu8h
2009 2010 2010 2010 vs. 2009 ~ 2010 vs. Bu et
Month Actual Bud et Adual Amount Percenf e Amount Percenf e.
lnterest & Investment's 100,680 95,900 68,514 (32,166) -31.9% (27,386 -28.6%
Rents & l.eases 118,791 93,400 130,961 12,170 10.2% 37,561 40.2%
Contributions & Donations 20,069 7,700 22,803 2,734 13.6% 15,103 196J%
Other Miscellaneous Revenue 35,749 20,800 137.811 102.062 285.5% _ 117:011 562:6°/a •
YfD Total , 275.289 217.800 360.089_ _ 84.800 30.8% 142._2.89
65.3%
Annual Total 664.307 465,800
Monthly Financial Report May 2010
Real Estate Exdse Tax '
The Real Estate Excise Tax (REEf) reyenue is received' in the Capital Improvement Projects Fund
and is used for governmental capital projects. At the end of May, year to date revenue of
$473,329 is $22,871 or 4:6°k less than the projected budget. This is $43.7K or 10.2% more than
2009 forthe same period and reflects the slow recovery in the commercial and residentaal - , market. -
f
R a__Est ta Exd011i'VT Rev~ae s
1~ear~~o Dat gh,~May_'-
2009 2010 2010" 2010 vs. 2009 - 2010 vs: 6udief--
. : .
Month Actual Bud et Actual Amount Percei►ta" e Amount Percent e
~ . ~ . ~ ; : • ; ~
1an 55,308 63.900 44,219 11;088 -20:0% °
) (19,681) _ _-30:$/0
Feb 1159443 133,300 56,636 58,807) =50.9% (76,664). _ -57.5%
Mar 114,240 1319900 74.986 39.254 =34.4% - 56;914 _ _-43.1%
_-A r,-~ 75.831 87,600 89.679 139848 18:3% " 2,079_-~~~ =2:40/o
Ma 689846 79.500 207;808 ' 138.962 201.8% 128.308 161.40/o
Jun 141,704 ` 163.600 ' Jul 106,672 123.200 !
Au 115.268 133,100 '
Se 179,067 2069700
Oct 314,172 362.700
Nov 184,935 213,500
Dec 87.440 101,000
YfD Total. 4299668
` 496,200 473.,329 : 43.661 10.2% (22.871) 4.6%
. _ w_ e ._.a_.~..~_w,,....___..__.~,~
Annual Total1.5589926 1,800.000 .
1z
Monthly Finanaal Report May 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 Sewa Stortn i Solid Waste ~ Airport Cenetay Golf . Comm Retail
OPERATING REVENUES
C es for sevices 3.601.491 ! 6.526.422 2.674.385 ; 3.833.702 # 10.946 305.652 . 446.295
ReGS, Leazes, Concasions & Other 255,659 5,265
TOTAL OPERATING REVENUES 3.601.491 i 6.526.422 2,674.385 ~ 3.833J02 266,605 305,852 451.50 .
~
I
OPERATING EXPENSES: €
AdminisRation 917.814 ; 718.819 867.533. 294.441 ~ 208,268 ~ 109,389 87,429
Opeatiora & Mairuenmxe 1.834,262 i 5.409.052 922,875 ; 3.069.626 61 ~ 274,943 495.164
.
Depreciation&Mnortization 882,466:~ 576,297 458.057_; . B.SSfi 9Q637 1 23.833 141.450 25.417
TOTAL OPERATING EXPENSES 3.634.542 ; 6,704,168 2,248.465 ~ 3:372,623 298,966 i 408.165 724.042 25.417
OPERATING INCOME (LOSS) (33.051) 1 077.746) 425.920 461.079 ~ (32.361); (102,313) (272,482) (25.417)
4 a ~
" NON-0PER,4TING REVENUES 6 EXPENSES
Irrterest Rev-ue 19,922 ; 26.123 10.091 ; 1.004 1; 1.178 ~ 302 i 148
_
~ Other Non Operating RevPnue 15 635 3,831 42,173 568 ; 113,559 ~ 267 11,008' ~
_
. , . . . _ . . . _ . ,
1___ _
Other Non Ex se s ~
~'ms a~+ 000.000): (1oo,ooo)° poo.ooo); E !
TOTAL NON-0PERATING REVENUES (EXPENSES) ~ (64.443); (70.046) (47.736); 1S71 ; 114.737 3 570 € 11.1571
.
. ~ ~
INCOME (LOSS) BEFORE CONTRIBUTIONS
. TRANSFERS, ; (97.493); (247.792) 378,184 ; 462.650 ~ 82.376 > 001.743); (261.325) (25.417)
~
.
1CoMributions ? 185.848 122484; 134578
~..w ~ E
~ iTransfen In 36.433
....~u.._._ . ; ~ V...
~ 3Transfes Out ~ (58.600} ! _ (58.200) (62.800I i . (900); i `
~ TOTAL CONTRIBUTIONS 6. TRANSfERS I 127;248 ' 64,284 71,778 (900) . 36,433
~
CHANGE IN FUND BALANCE 29,755 ' (183,508) 449,962 : 461,750 ; 82,376 ? (101,743); (224.892) (25.417)
BEGINNING FUND &4LANCE. Janu~ 1, 2010 58,580.941 ~ 64,391,028 ~ 39,620,492, ; 1,576,367 : 9,687.653 : 1.114.0741 _ 5.501,774 1,473.941
_ . .
ENDING EUND BALANCE, May 31.2010 3 58.610.696; 64,207,520 40.070.454. ; 2,038.137 ! 9,770.@9 ? 1.012,331 € 5.276.883 1,448,524
Solid Waste operating expenses are low due to timing of invoices form Waste Management.
May billing of $631,557 was posted in June. .
lntemal Service Funds
13
Monthly Finanaal Report . May 2010
The table below p'rovides an analysis of all City Internal Service funds and shows the year to dete,
revenues.and expenditures for each fund.
Infortnation Equipment
7 - Insurance Faalities - Services Rental
OPERAtING REVENUES:
lnterfund Charges for services - 1,082,310 1,625,865 1.026,051
Rents. Leases, Concessions & Otfiec - 52.709 44,672
TOTAL OPERATING REVENUES . 1,135.019 1,670,537 1,026.051
OPERATiNG EXPENSES:
Administration 816,779 - 61,695 231,075
Operations & Maintenance - 819J64 1.349,080 491,071
Depreuation &Arriortization - - • 211,777 440,717
TOTAL OPERATING IXPENSES ' 816,779 819,164 1.622,552 1.162.863
OPERATING INCOME (LOSS) - (816.779) 315.855 47.985 036:812)
NON-OPERATING REVENUES & EXPENSES
1nterest Revenue . 1,543 538 4.090 5,323
` Other Non Opereting Revenue - - - 23;372
Other Non Operating 6cpense - - -
TOTAL NON-OPERATING REVENUES (EXPENSES) 1,543 538 4.090 28,695
INCOME (LOSS) BEFORE CONTRIBUTIONS & TRANSFERS (815,236) 316,393 52,075 ` (108,117)
Confibutions - - 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 (576,636) 316,393 33.525 (130,517)
BEGWNING FUND BALANCE, January 1. 2010 2,234,469 207.637 4,914.846 10,892,939
ENDWG FUND BALANCE. May 31, 2010 1,657,833 524.030 " 4;948;370 10,762,422
The Insuranee. Fund expenses include $816,779 that was paid at the beginning of the year. This
amount wilF_be deereasing.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,762,422 includes over $5.2 million in fixed assets net of
depceciation. Which primarity consist of the City's fleet vehicles.
Contad Information
This report is prepared by the Finance Department. Additional financiat information can also be
viewed at our website: http://www.auburnwa.gov/. For any questions about the reportplease
contact us at kiesterPauburnwa.gov or scolemanC@,auburnwa.gov.
14
SALES TAX SUMMARY
Ma 2010 March Recei ts '
YfD YTD
NAICS CONSTRUCTION 09TOTAL WYTD 10`liD %Di(f NAICS AUTOMOTIVE 09TOTAL 09YfDlOYTD. 96D'rfF
236 ConstructlmdBuiidings 825,1N 258,930 237.000 -8.596 441 1MtmVehideBPaRsDealar 2,388,443 895,252; 8p6,767; 1.3%
237 Fleavy 8 CNiI Conahucdon 140.889 53.244 58.982 10.8% 447 Gawfine Stalians 189,821 88 788 . 78.G53! 17.8%
238 SpeclaQy Trede ContrecEore 802,218 234,082 218,127 -8.4% TOTAL AUTOb10TNE $ 2,558,064 1 96;,03T - f B&5,920 i
TOTALCONSTRUC710N $ 1,368,217 $ 546,256 f 516,109 ONerapAutomolireChargeFramPreriousYear f2,;J83i 1.1%
Overa/l CansUUtfion Chartge ham Revious Year (j31, tt7) -d 7%
NAICS RETAILTRADE 08TOTAL 09YfD~ 10YTD%Difl
YTD 642 Fumihue 8 Hare Fumishoiga 21B,P5 102,Y8B ; 60.541; •11A%
MANUFACNRING OSTOTAL 09 YM 10 YTD % Ditf d13 Eleetraiics 6 AppBences 131,718 64,9551 53,0.58; •18.3%
311 Food MenufacNring 2,877 1,495 1,095 -26.7% d44 BWdhg MaWial &(ierden 368,228 129.088;^ 147.228; 14.116
312 Baverepe & Tabacco Praducfs 3,890 1,878 1,475 •25.0% 445 Food d Bereiage SEwea 352,401 141,812 i 143,05; 1.4%
313 TextilaNfOs 215 76 87 -01.8% 146 HeeAhBPersanelCere 140,758 68,171! 6b3* -7.0%
314 Texfile Product MOs 1,354 318 548 45.9% 448 Cbthing 8 Acaesemies 781,938 348.808 "6105Ti -0.5%
315 Ayperel Manufacturiig 219 2,238: 885 •70.3% 451 3pa6np Goode, Hobby, Booke 45,215 26,850 i.. d4.218` 88.046
316 LeaUier 8 A6ed Pioducte 81 35 23 -53.9% 452 Cianeial Mendhmdfw SOwes 832,811 377.578; 758,A18; 5.1%
321 WoodPiaductManutecLimg 31,411 12.481 18,984 98.9% 453 MsoegmeauaSEmaRetOars 481,958 212,189! 7A8.847; -1.1%
322 Paper AknufaeMdp 8,987 4,493 4,788 8.5% 454 tbnatare Retmlers 228,0.18 102,824 ; tOQ,571,l -2.2%
323 Printiip 8 Rehted Suppwl 41,517 17,385 17,889 9.0% TOTAL RETAIL iRADE f 3.580.729 f 1.559639 ! 1 1,63w `
324 Peboleum&CoelPmducffi 10,708 4,891 1,084 -71.3% Owere/lGerwalRMailChangehnmftmusYar 47%
325 Chemical Manufecpuinp 8,905 2,011 2,435 21.1%
326 Plaatlc 6 Rubber Producta 8,883 3,384 9,820 729% yTp
327 NonmetalEcWffwiralProdWis 15,270 3,895 5,375 37.096 SERVICES 08TOTAL 09YiDa 10 YTD %Dbf
391 Primary AAeMI MmwlacWring 592 530 59 -88.9% 51' Intannedan 458,588 1M14 j S34,90 220.5%
332 Fabrica0ed MkW Mlg Roducb 12,232 5,912 7.780 46.5% 52* Finama 3 Inwmp» 82,939 35,037; 20.070! -17.0%
333 Nlachinery Manufachrtiig 8,788 3,535 5,130 62.1% 53' Real Estata, Rental, Leasiig Nb 304,200 141,288: 114,529' -18.2%
334 Computer 8 Elec6onb Producb 8,595 3,433 4,389 27.9% 541 Protesabnal, Sdentifx, Tech 188,772 87,252 @7,014' -0.3%
335 Elec6ic Equipmant, AypBaixea 2,218 1,043 874 35.4% 551 Conyrany Management 418 231 Ti; -89.5%
336 Trenaporta6on Equipment Mig 177,978 83,083 81,579 •73.9% 58' Admin, Supp, Ramed S\a;e 260,887 118,707 88,140! -24.8%
337. Fumilure 8 Related Producb 12,187 5,175 5,507 8.4% 811 Educafional Servprea 42,182 31,082 2J,3* -24.7%
339 b6scellaneoue ManufacWring 21,923 10,551 13,210 25.2% 82' Heaph Cere Sodal Assistemos 81,157 31,017 ( 29,542' J4.8%
TOTAL IAAUUFACTURWG f 187,469 f 177.168 f 155,115 71' Me 8 EntmfainmeM 141,103 82,841 j 60.730, -23%
OvtrallAfamdacMirtgCharyehmnPreviousYear /lZZafJ) •f1.1% 72' AaomrtndationdFaadSYcs 827,347 338.784j 321,809; S.0%
81• oem Senicea 423,20.7 178,0071 168.328; -3.8%
YTD 92' Pu66eAdministre6on 81,553 8082 34,842' 288.8%
TRANSPORTATION 6 WAREHOUSING 09 TOTAL 09 YM 10 YM %Diff TOTAL SERVICES $ $861,488 { 1,249,498 I f 1.1106.334 d
4e1 k rranworMw o 0 o wa ove.auservkes cmw uwn vrev;ous rear t~ate ! ze.ess
482 RailTrenaporfetion 8,577 2,298 2,588 17.1%
484 TNCk Trenspate6on 7,090 2,981 3,205 8.296
, 485 Transit and Cxrnmd Passeiqers 5 5 52 822A% yTp
488 Transpata6onSupport 13,080 6,882 5,378 -22.4% MISCELLANEOUS 09TOTAL 09Y10 10YTD': %Dil(
OBt PostelServicea 190 105 87 WA 000 Unkirown 272 268' 49: -81.7%
492 Coudero 8 Meseengen 1,114 734 819 -15.796 111-115 AgriwlWre, Fweatry, Fiahing 1'827 1,015 ; 1:15f 19.7%
493 Werehousing 6 Smrape 728 118 1,10 834.4°6 711-221 M6ning 8 U66tiee 27,452 8,572! 81787: 3.496
TOTAL TRANSP 6 WHSING f 30,791 f 13,102 f 13,008 998 Undasefiable Estab6shmanffi 18,908 8,485! 84,524: 860.79i
Overe/lTianspmtetianChangehomPmiousYear (f9N 47% WSCELLANEOUSTOTAL t 48,458 f 16,368f 7Z621i
OYerallMiscellaneousCharyphomPrsviousYeer SSk153' 3A17%
YTD
WHOLESALETRADE 09TOTAL 09YTD 10YTD %Di(1
423 Whls Trede-Dwabla Gooda 818,970 380,575 408,883 12.8% YM
424 WhlsTrade-NaidurabkGoods 149,252 66,935 60,922 -9.0l6 09TOTAL 09YTD' 10Yip; %DiB
425 Whobsak Becbonk Mmkeb 3.704 922 854 -7.4% GRAN0.TOTALS 511,808,119 S4,952,213 ~ 55,249 235
WHOLESALETItADETOTAL f 1,07Z965 $ 428,431 f 468,658 Gw+dTaValCAmr hommerbus aer ; 7,OA1 ; d102%
OwemU Nfidesale prange Iran Previaus Yesr i401Y6 14%
15
env2010 Pege 7 iosde.r-ROA
City of Auburri
- Investment Portfolio Summary
As of May 31; 2010
Investment Purchase Furchase Maturity Yeld to
Type Date Price Date Maturity
State Investment Pool Various $ 63,783,407 Various 0.27%
KeyBank Money Market Various 20,681,258 Various 0.10%
US Treasury 05/04/1990 , 57,750 05%15/2016 5.72%
FHLB 2/212009 1,000,000 2%2/2011 1.540%
FHLB 2/2/2009. 11000,000 ' 8/2/2011 1.840% '
FHLB 12/29/2009 1,000,000 6/29/2012 1_375%
FNMA , "2J19/2010 1,000,000 2/19/2013. 1.500%
FNMA 2/1912010 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% .
FNMA 5/13/2010 1,725,000 - 11/13/2011 1.550%
" FHLB 5/20/2010 2,600,000 ~ 2/20/2013 - 1.625%
Total Cash & Investments $ 98;747,415 0.430%
Investment Mix % of Total Summary
$fate Investment Pool 64.6% Currenf 6-month treasury rate 0.22%
KeyBank Money Market 20.9% Current State PooF rate 0.27% -
US.Treasury 0.1 % KeyBank Money. Market 0.10%
FHLB 7.6% Blended Auburn rate 0.43%
FNMA 6:8%
100.0% .
16