The URL can be used to link to this page

Home My WebLink AboutApril 2012 AGENDA BILL APPROVAL FORM Agenda Subject: April 2012 Financial Report Date: 06/12/2012 Department: Finance Attachments: Monthly Financial Report Budget Impact: $0 Administrative Recommendation: Background Summary: The purpose of the monthly financial reports is to summarize for the City Council the general state of city- wide financial affairs and to highlight significant items or trends that the City Council should be aware of. The following provides a high level summary of the City’s financial performance. Further detail can be found within the attached financial report. The April status report is based on financial data available as of May 22, 2012. Sales tax information represents business activity that occurred in February 2012. General Fund: The general fund is the City’s largest fund and is used to account for the majority of City resources and services except those required by statute or to be accounted for in another fund. At the end of April, General Fund revenue collections totaled $18.4 million and compare to budget-to-date of $19.3 million. Intergovernmental revenues are below budget due to the timing of payments from the Muckleshoot Indian Tribe and lower revenue collections from the red light photo-enforcement program. General tax revenues, the largest category of revenue within the General Fund, totaled $15.3 million and compares to budget of $15.9 million. The City’s sales tax totaled $4.7 million and is running 1.7% below budget due primarily to two one-time adjustments by the State of Washington. Property tax collections totaled $4.8 million and compares to budget of $5.5 million due to the timing of property tax payments. Property taxes are expected to re-align with expectations with the receipt of May property taxes. General Fund expenses totaled $15.4 million and compare to budget of $17.3 million. Departmental expenditures are below budget due primarily to the timing of SCORE jail payments and salary savings from vacancies within the Police Department. Enterprise Funds: The City’s eight enterprise funds account for operations with revenues primarily provided from user fees, charges or contracts for services. At the end of April, the Water fund ended with a slight operating income of $49,000; the Sewer fund ended this period with a $455,000 operating loss; and the Stormwater fund ended with an operating income of $400,000. The Golf Course ended the period with an operating loss of $306,000. Financial performance for the Auburn Golf Course is expected to improve as play increases with better weather during the spring and summer months. Cemetery revenues at the end of April totaled $255,000 and were below expenses of $328,000. 1 Agenda Subject: April 2012 Financial Report Date: 06/14/2012 Internal Service Funds: Internal Service Funds provide services to other City departments and include functions such as Insurance, Facilities, Information Services, and Equipment Rental. At the end of the year, revenue from charges assessed to internal client departments was sufficient to meet expenses. Investment Portfolio: The City’s total cash and investments at the end of April was $99.4 million and compare to $97.7 million the previous month. Reviewed by Council & Committees: Reviewed by Departments & Divisions: Arts Commission COUNCIL COMMITTEES: Building M&O Airport Finance Cemetery Mayor Hearing Examiner Municipal Serv. Finance Parks Human Services Planning & CD Fire Planning Park Board Public Works Legal Police Planning Comm. Other Public Works Human Resources Information Services Action: Committee Approval: Yes No Council Approval: Yes No Call for Public Hearing ___/___/____ Referred to _________________________________ Until ____/___/____ Tabled ______________________________________ Until ___/___/____ Councilmember: Partridge Staff: Coleman Meeting Date: June 12, 2012 Item Number: 2 Monthly Financial Report April 2012 General Fund 2011 Summary of Sources and Uses Annual BudgetYTD BudgetYTD ActualYTD ActualAmountPercentage OPERATING REVENUES Property Tax 12,562,565 5,489,200 4,775,059 5,696,123 (714,141) -13.0% Sales Tax (1)14,295,000 4,740,500 4,661,723 4,785,180 (78,777) -1.7% Sales Tax - Annexation Credit 1,383,730 441,430 474,684 472,668 33,254 7.5% Criminal Justice Sales Tax 1,212,900 391,300 443,730 423,986 52,430 13.4% Brokered Natural Gas Tax 260,000 115,100 148,598 140,030 33,498 29.1% City Utilities Tax 2,620,200 817,300 856,941 757,270 39,641 4.9% Admissions Tax 360,000 125,100 116,867 115,159 (8,233) -6.6% Electric Tax 3,275,000 1,756,300 1,729,940 1,678,394 (26,360) -1.5% Natural Gas Tax 1,295,820 836,100 747,170 728,141 (88,930) -10.6% Cable TV Franchise Fee 703,600 352,200 400,941 403,943 48,741 13.8% Cable TV Franchise Fee - Capital 75,000 36,600 31,508 31,983 (5,092) -13.9% Telephone Tax 2,012,400 632,100 714,823 659,919 82,723 13.1% Garbage Tax (external)150,000 45,100 45,760 39,926 660 1.5% Leasehold Excise Tax 50,000 13,000 10,067 12,346 (2,933) N/A Gambling Excise Tax 331,500 155,100 125,731 68,531 (29,369) -18.9% Taxes sub-total 40,587,715 15,946,430 15,283,542 16,013,598 (662,888) -4.2% Business License Fees 200,000 51,200 110,015 94,275 58,815 114.9% Building Permits 700,000 180,800 362,082 257,926 181,282 100.3% Other Licenses & Permits 229,000 54,300 99,416 94,214 45,116 83.1% Intergovernmental (Grants, etc)3,925,105 1,349,700 1,032,519 1,280,132 (317,181) -23.5% Charges for Services: General Government Services 64,600 21,700 43,797 28,797 22,097 101.8% Public Safety 223,500 78,500 79,402 81,244 902 1.1% Development Services Fees 627,000 170,700 316,679 122,584 145,979 85.5% Culture and Recreation 920,000 345,000 303,483 296,223 (41,517) -12.0% Fines and Forfeits 2,208,500 865,300 562,180 763,412 (303,120) -35.0% Fees/Charges/Fines sub-total 9,097,705 3,117,200 2,909,574 3,018,807 (207,626) -6.7% Interests and Other Earnings 115,000 33,300 23,704 23,586 (9,596) -28.8% Rents, Leases and Concessions 311,000 117,800 99,589 144,673 (18,211) -15.5% Contributions and Donations 20,500 5,100 18,112 11,706 13,012 255.1% Other Miscellaneous 46,200 23,200 21,391 20,422 (1,809) -7.8% Transfers In 17,000 17,000 17,000 78,439 - 0.0% Insurance Recoveries- Capital & Operating 25,000 8,314 39,380 63,536 31,065 373.6% Other Revenues sub-total 534,700 204,714 219,176 342,362 14,462 7.1% Total Operating Revenues 50,220,120 19,268,344 18,412,292 19,374,767 (856,052) -4.4% Operating Expenditures Council & Mayor 869,890 285,290 308,836 244,989 (23,546) -8.3% Municipal Court & Probation 3,399,260 1,044,560 929,481 942,378 115,079 11.0% Human Resources 886,530 278,500 267,868 251,690 10,632 3.8% Finance 1,235,590 419,400 346,464 398,909 72,936 17.4% City Attorney 1,699,500 567,200 491,636 557,778 75,564 13.3% Planning 3,889,620 1,217,300 1,209,274 1,132,616 8,026 0.7% Community & Human Services 1,160,360 396,160 392,144 341,797 4,016 1.0% Jail - SCORE 4,764,750 1,486,350 286,979 450,518 1,199,371 80.7% Police 20,616,200 6,463,800 5,917,374 5,883,231 546,426 8.5% Engineering 2,643,870 856,370 811,752 724,849 44,618 5.2% Parks and Recreation 7,557,230 2,370,230 2,324,749 2,163,455 45,481 1.9% Streets 3,215,280 972,380 819,608 819,133 152,772 15.7% Non-Departmental 5,161,650 986,200 1,252,574 487,761 (266,374) -27.0% Total Operating Expenditures 57,099,730 17,343,740 15,358,740 14,399,104 1,985,000 11.4% 2012 2012 YTD Budget vs. Actual Favorable (Unfavorable) (1) The anticipated Streamlined Sales Tax for 2012 is $2 million. The year to date actual Sales Tax amount is adjusted to include $499,384 Streamlined Sales Tax Mitigation received from the State for the 1st quarter of 2012, and $167,151 estimated for April. 3 Monthly Financial Report April 2012 Overview This financial overview reflects the City’s overall financial position for the fiscal period ending April 30, 2012 and represents financial data available as of May 22, 2012. The budgeted year-to- date revenues and operating expenses are based on the collection/disbursement average for the same period of the two prior years. General Fund revenues totaled $18.4 million as of the end of April 2012 and were under budget by 4.4%, or $856,000. This period’s highlights include: - Tax revenues totaled $15.3 million and were $663,000 below budget, due primarily to timing of property tax collections. - Sales taxes totaled $4.7 million, or about $78,000 under budget. The lowered performance is due in part to two one-time adjustments totaling $94,000 by the Washington State Department of Revenue that occurred during the January and February sales tax distributions. - Revenue from Fees/Charges/Fines totaled $2.9 million and was under budget by $208,000, reflecting the timing of payments from the Muckleshoot Indian Tribe and lowered revenue from the City’s red-light photo enforcement program. - Other revenues totaled $219,000 and exceeded budget by $14,000, reflecting April insurance recoveries of $21,000. The 2012 approved State budget included two significant changes to the City’s share of liquor excise taxes and liquor profits effective June 2012. Liquor excise taxes will be temporarily suspended for a twelve month period and will be reinstated at a reduced level starting July 1, 2013. Liquor profit distributions will be frozen at 2011 levels. These changes were made following lengthy discussions in the State Legislature on ways to balance the State budget. General Fund expenses totaled $15.4 million and were $2 million below budget and compared to expenses of $14.4 million for the same period last year. The majority of budget savings were due to the timing of payments for SCORE jail services, and salary savings from vacancies within the Police Department. General Fund BudgetYTD Actual % of BudgetBudgetYTD Actual % of Budget Operating Revenues Taxes 40,587,715$ 15,283,542$ 37.7%39,363,950$ 16,013,598$ 40.7% Fees/Charges/Fines 9,097,705 2,909,574 32.0%8,663,735 3,018,807 34.8% Other Revenues 534,700 219,176 41.0%1,600,819 342,362 21.4% Total 50,220,120$ 18,412,292$ 36.7%49,628,504$ 19,374,767$ 39.0% Operating Expenses Council & Mayor 869,890$ 308,836$ 35.5%866,770 244,989 28.3% Municipal Court & Probation 3,399,260 929,481 27.3%3,291,120 942,378 28.6% Human Resources 886,530 267,868 30.2%833,070 251,690 30.2% Finance 1,235,590 346,464 28.0%1,165,540 398,909 34.2% City Attorney 1,699,500 491,636 28.9%1,645,650 557,778 33.9% Planning 3,889,620 1,209,274 31.1%3,789,730 1,132,616 29.9% Community & Human Services1,160,360 392,144 33.8%1,089,490 341,797 31.4% Jail - SCORE 4,764,750 286,979 6.0%6,287,470 450,518 7.2% Police 20,616,200 5,917,374 28.7%19,890,990 5,883,231 29.6% Engineering 2,643,870 811,752 30.7%2,400,460 724,849 30.2% Parks and Recreation 7,557,230 2,324,749 30.8%7,346,660 2,163,455 29.4% Streets 3,215,280 819,608 25.5%3,126,460 819,133 26.2% Non-Departmental 5,161,650 1,252,574 24.3%3,763,520 487,761 13.0% Total 57,099,730$ 15,358,740$ 26.9%55,496,930$ 14,399,104$ 25.9% 2012 2011 4 Monthly Financial Report April 2012 Revenues The combined total of property tax, sales/use tax, utility tax, gambling, and admissions tax provide approximately 80% of all resources supporting general governmental activities. The following section provides additional information on these sources. Property Tax collections to date total $4.8 million and is running below budget due to timing of property tax payments. Collections are expected to return to budgeted levels in the following month. The majority of property tax revenues are collected during the months of April and October, coinciding with the due date for County property tax billings. $0.0 $2.0 $4.0 $6.0 $8.0 $10.0 $12.0 $14.0 JanFebMarAprMayJunJulAugSepOctNovDec Mi l l i o n s Property Taxes 2012 budget 2012 actual to date 2011 actual Sales taxes totaled $4.7 million and were slightly under budget due to two one-time corrections totaling $94,000 by the State of Washington. Sales taxes include an estimate of $167,151 for April’s portion of the Streamlined Sales Tax Mitigation payments from the State of Washington. $0.0 $2.0 $4.0 $6.0 $8.0 $10.0 $12.0 $14.0 $16.0 JanFebMarAprMayJunJulAugSepOctNovDec Mi l l i o n s Sales & Use Tax 2012 budget 2012 actual to date 2011 actual 5 Monthly Financial Report April 2012 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. 20112012 Component GroupActualActualAmountPercentage New Construction 395,096 368,446 (26,650) -6.7% Manufacturing 221,315 75,317 (145,998) -66.0% Transportation & Warehousing19,115 15,618 (3,497) -18.3% Wholesale Trade 399,364 412,436 13,072 3.3% Automotive 856,909 897,434 40,525 4.7% Retail Trade 1,338,005 1,312,889 (25,116) -1.9% Services 905,318 936,160 30,842 3.4% Miscellaneous 22,559 12,697 (9,862) -43.7% YTD Total 4,157,681 4,030,997 (126,684) -3.0% Change from 2011 Year to Date through April Comparison of Sales Tax Collections by SIC Group As shown above, sales taxes by business sector totaled $4.0 million and are $127,000 less than the same period last year due in part to the adjustments by the Washington State Department of Revenue described above. $0.0 $1.0 $2.0 $3.0 $4.0 $5.0 $6.0 $7.0 $8.0 $9.0 $10.0 JanFebMarAprMayJunJulAugSepOctNovDec Mi l l i o n s Utility Tax 2012 budget 2012 actual to date 2011 actual Utility Taxes consists of City inter-fund utility taxes (Water, Sewer, Storm and Solid Waste) and external utility taxes (Electric, Natural gas, Telephone and Solid Waste). Year-to-date through April collections totaled $4.1 million which is on target with budget. The following table presents utility tax collections by source: 6 Monthly Financial Report April 2012 201120122012 Month ActualBudgetActualAmountPercentageAmountPercentage City Interfund Utility Taxes757,270 817,300 856,941 99,670 13.2%39,641 4.9% Electric 1,678,394 1,756,300 1,729,940 51,546 3.1%(26,360) -1.5% Natural Gas 728,141 836,100 747,170 19,029 2.6%(88,930) -10.6% Telephone 659,919 632,100 714,823 54,904 8.3%82,723 13.1% Solid Waste 39,926 45,100 45,760 5,834 14.6%660 1.5% YTD Total 3,863,650 4,086,900 4,094,634 230,984 6.0%7,734 0.2% Annual Total 8,890,614 9,353,420 Year to Date through April Utility Tax by Type 2012 vs. 20112012 vs. Budget Cable TV Franchise Fees exceed budget by $49,000 and are tracking 2011 collection levels. This revenue source is likely to outperform budget by the end of 2012 and end at levels similar to the previous year. $0 $100 $200 $300 $400 $500 $600 $700 $800 $900 1st Quarter2nd Quarter3rd Quarter4th Quarter Th o u s a n d s Cable TV Franchise Fee 2012 budget 2012 actual to date 2011 actual Licenses and Permits include business licenses, building permits, plumbing, electric and other licenses and permit fees. Building permit fees and Business licenses make up 80% of the annual budgeted revenue in this category. Total building permit revenues at the end of April were $362,000 and exceeded both budget and prior year levels of $181,000 and $258,000, respectively. Building permit activity has increased, reflecting the broader trend of increased construction activity in the region. 7 Monthly Financial Report April 2012 $0 $200 $400 $600 $800 $1,000 $1,200 JanFebMarAprMayJunJulAugSepOctNovDec Th o u s a n d s Building Permits 2012 budget 2012 actual to date 2011 actual Business License revenues totaled $110,000 and exceeded budget due to the timing of payments. The revenue for the year is billed out late in December and most payments are received between January and February. This revenue source is expected to level out for the remainder of the year until December when collections increase as payments for 2013 are received. $0 $50 $100 $150 $200 $250 JanFebMarAprMayJunJulAugSepOctNovDec Th o u s a n d s Business Licenses 2012 budget 2012 actual to date 2011 actual 8 Monthly Financial Report April 2012 Intergovernmental includes Grants (Direct & Indirect Federal, State and Local); State shared revenues and compact revenue from the Muckleshoot Indian Tribe. April collections were below budget by $317,000 or 24%, due primarily to the timing of reimbursements from the Muckleshoot Casino for public safety services and state shared Motor Vehicle Fuel Taxes. The 2012 budget for the Motor Vehicle Fuel Tax has not yet been adjusted to reflect the change in revenue recognition to the Arterial Street fund and Recreational Trails fund. This adjustment will be included in Budget Adjustment #8 for review and approval by the City Council in June. As discussed above, the City’s share of liquor excise taxes and liquor profits will be revised starting July 1. Liquor excise taxes will be suspended for a twelve month period and will be reinstated at a lowered level starting July 1, 2013 while liquor profits will be reduced to 2011 levels starting July 1. These changes were made as a result of the State Legislature’s effort to balance the State budget during the 2012 legislative session. 20112012 2012 Revenue ActualBudgetActual% Change% Change Federal Grants 5,951 75,700 128,732 2063.2%70.1% State Grants 19,656 12,900 36,314 84.7%0.0% Interlocal Grants 19,817 22,400 2,500 -87.4%-88.8% State Shared Revenue 887,743 877,800 697,842 -21.4%-20.5% Muckleshoot Casino Emerg.335,525 352,600 163,281 -51.3%-53.7% Intergovernmental Service11,440 - 3,850 -66.3%N/A YTD Total 1,280,132 1,341,400 1,032,519 -19.3%-23.0% Annual Total 3,432,394 3,925,105 YTD %37%34%26% Year to Date through April Intergovernmental 2012 vs. 20112012 vs. Budget 201120122012 Revenue ActualBudgetActualAmountPercentageAmountPercentage Trial Court Improvements11,234 12,300 5,658 (5,576) N/A(6,642) N/A Court Interpreter Program 4,931 5,200 7,307 2,376 N/A2,107 N/A Motor Vehicle Fuel Tax 457,062 466,200 306,233 (150,829) -33.0%(159,967) -34.3% Criminal Justice -High Crime75,325 - 71,399 (3,926) -5.2%71,399 N/A Criminal Justice -Population7,690 50,200 7,766 76 1.0%(42,434) -84.5% Criminal Justice -Spec. Prog.29,045 27,600 29,308 263 0.9%1,708 6.2% State DUI 6,262 3,200 6,777 514 8.2%3,577 111.8% Fire Insurance Premium Tax - - - - N/A - N/A Liquor Excise Tax 169,003 175,300 171,289 2,286 1.4%(4,011) -2.3% Liquor Profits 127,191 137,800 92,106 (35,085) -27.6%(45,694) N/A YTD Total 887,743 877,800 697,842 (189,900) -21.4%(179,958) -20.5% Annual Total 2,073,650 2,551,890 Year to Date through April State Shared Revenues 2012 vs. 20112012 vs. Budget 9 Monthly Financial Report April 2012 Charges for Services consists of general governmental services, public safety, development service fees and cultural & recreation fees and is above budget by $127,000. Development service fees and culture and recreation fees make up 81% of the revenue within this category. Development services revenues totaled $317,000 compared to budget of $171,000 due to stronger revenues from development plan-check fees. Culture & Recreation revenues totaled $303,000 and are running 12% below budget due to lower revenue from adult health & fitness classes and afterschool programs. 201120122012 Revenue ActualBudgetActualAmountPercentageAmountPercentage General Government 28,797 21,700 43,797 15,000 52.09%22,097 101.83% Public Safety 81,244 78,500 79,402 (1,842) -2.3%902 1.1% Development Services 122,584 170,700 316,679 194,095 158.3%145,979 85.5% Culture & Recreation 296,223 345,000 303,483 7,260 2.5%(41,517) -12.0% YTD Total 528,848 615,900 743,361 214,513 40.6%127,461 20.7% Annual Total 1,651,371 1,835,100 Year to Date through April Charges for Services by Type 2012 vs. 20112012 vs. Budget $0 $100 $200 $300 $400 $500 $600 $700 JanFebMarAprMayJunJulAugSepOctNovDec Th o u s a n d s Development Service Fees 2012 budget 2012 actual to date 2011 actual 10 Monthly Financial Report April 2012 $0 $100 $200 $300 $400 $500 $600 $700 $800 $900 $1,000 JanFebMarAprMayJunJulAugSepOctNovDec Th o u s a n d s Culture & Recreation 2012 budget 2012 actual to date 2011 actual Fines & Penalties totaled $562,000 compared to a budget of $865,000. Financial performance is $303,000 below budget due primarily to lower photo enforcement revenues and reduced parking infractions compared to 2011. Photo enforcement revenues will be revised as part of Budget Amendment #8, reflecting the lowered trend in collections. This amendment is scheduled for Council review and approval in June. 201120122012 Month ActualBudgetActualAmountPercentageAmountPercentage Civil Penalties 6,771 5,100 5,655 (1,116) -16.5%555 10.9% Civil Infraction Penalties 247,949 217,600 229,806 (18,143) -7.3%12,206 5.6% Red Light Photo Enforcement345,277 487,900 200,708 (144,569) -41.9%(287,192) -58.9% Parking Infractions 59,251 59,900 38,580 (20,671) -34.9%(21,320) -35.6% Criminal Traffic Misdemeanor30,048 38,500 34,748 4,699 15.6%(3,752) -9.7% Criminal Non-Traffic Fines32,108 34,300 33,593 1,484 4.6%(707) -2.1% Criminal Costs 5,006 3,500 5,596 590 11.8%2,096 59.9% Non-Court Fines & Penalties37,002 18,500 13,496 (23,505) -63.5%(5,004) -27.0% YTD Total 763,412 865,300 562,180 (201,231) -26.4%(303,120) -35.0% Annual Total 1,940,326 2,208,500 Year to Date through April Fines & Forfeits by Type 2012 vs. 20112012 vs. Budget 11 Monthly Financial Report April 2012 $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 JanFebMarAprMayJunJulAugSepOctNovDec Mi l l i o n s Fines & Penalties 2012 budget 2012 actual to date 2011 actual $0.0 $0.2 $0.4 $0.6 $0.8 $1.0 $1.2 $1.4 JanFebMarAprMayJunJulAugSepOctNovDec Mi l l i o n s Photo Enforcement 2012 budget 2012 actual to date 2011 actual Miscellaneous revenues include interest and other investment earnings, rents, leases & concessions, contributions & donations and other miscellaneous income. April revenues in this category totaled $163,000 and are below budget by $17,000 due primarily to lowered revenue from facility rentals. 201120122012 Month ActualBudgetActualAmountPercentageAmountPercentage Interest & Investments 23,586 33,300 23,704 117 0.5%(9,596) -28.8% Rents & Leases 144,673 117,800 99,589 (45,084) -31.2%(18,211) -15.5% Contributions & Donations 11,706 5,100 18,112 6,407 54.7%13,012 255.1% Other Miscellaneous Revenue20,422 23,200 21,391 969 4.7%(1,809) -7.8% YTD Total 200,387 179,400 162,797 (37,590) -18.8%(16,603) -9.3% Annual Total 649,927 492,700 Miscellaneous Revenues by Type Year to Date through April 2012 vs. 20112012 vs. Budget 12 Monthly Financial Report April 2012 Real Estate Excise Tax (REET) revenue is receipted into the Capital Improvement Projects Fund and is used for governmental capital projects. Revenue at the end of April totaled $428,000 and is in line with budget. $0.0 $0.2 $0.4 $0.6 $0.8 $1.0 $1.2 $1.4 $1.6 JanFebMarAprMayJunJulAugSepOctNovDec Mi l l i o n s Real Estate Excise Tax 2012 budget 2012 actual to date 2011 actual 13 Monthly Financial Report April 2012 Enterprise Funds The following table provides an analysis of the City’s Enterprise funds – showing 2012 revenues and expenditures by fund. WaterSewerStormSolid WasteAirportCemeteryGolf OPERATING REVENUES Charges for Services 2,801,650 1,522,458 2,429,631 3,747,941 5,316 255,178 167,068 Sewer Metro Service Revenue - 4,235,382 - - - - - Rents, Leases, Concessions & Other - - - - 201,434 - 72,178 TOTAL OPERATING REVENUES 2,801,650 5,757,840 2,429,631 3,747,941 206,750 255,178 239,246 OPERATING EXPENSES: Administration 799,657 635,967 791,008 246,670 197,563 96,308 74,022 Operations & Maintenance 1,226,750 813,561 874,004 418,748 47 189,538 365,623 Waste Management Payments - - - 2,325,984 - - - Sewer Metro Services - 4,172,056 - - - - - Depreciation & Amortization 726,141 591,051 424,660 6,273 130,696 19,687 105,464 TOTAL OPERATING EXPENSES 2,752,548 6,212,635 2,089,672 2,997,675 328,306 305,533 545,109 OPERATING INCOME (LOSS)49,102 (454,795) 339,959 750,266 (121,556) (50,355) (305,863) NON-OPERATING REVENUES & EXPENSES Interest Revenue 15,664 4,490 4,265 171 515 60 139 Other Non Operating Revenue 14,174 598 2,408 388 245 18 - Other Non Operating Expense - - - - - - - TOTAL NON-OPERATING REVENUES (EXPENSES)29,838 5,088 6,673 559 761 78 139 78,940 (449,707) 346,632 750,825 (120,795) (50,278) (305,723) Contributions 136,592 79,909 120,305 - - - - Transfers In - - - - - 200,000 8,354 Transfers Out (50,000) (50,000) (50,000) - - - - TOTAL CONTRIBUTIONS & TRANSFERS 86,592 29,909 70,305 - - 200,000 8,354 CHANGE IN FUND BALANCE 165,532 (419,798) 416,937 750,825 (120,795) 149,722 (297,369) BEGINNING FUND BALANCE January 1, 2012 63,028,695 73,274,006 47,772,204 760,681 9,731,158 814,709 5,144,962 ENDING FUND BALANCE April 30, 2012 63,194,227 72,854,208 48,189,141 1,511,506 9,610,363 964,432 4,847,593 INCOME (LOSS) BEFORE CONTRIBUTIONS & TRANSFERS 14 Monthly Financial Report April 2012 The following table presents the Working Capital Statements for the City’s Enterprise funds. Working capital is generally defined as the difference between current assets and current liabilities. WaterSewerStormSolid WasteAirportCemeteryGolf OPERATING REVENUES Charges for Services 2,801,650 1,522,458 2,429,631 3,747,941 5,316 255,178 167,068 Sewer Metro Service Revenue - 4,235,382 - - - - - Rents, Leases, Concessions & Other - - - - 201,434 - 72,178 TOTAL OPERATING REVENUES 2,801,650 5,757,840 2,429,631 3,747,941 206,750 255,178 239,246 OPERATING EXPENSES: Salaries & Wages 682,486 451,521 602,901 140,197 6,357 143,555 177,263 Benefits 301,249 194,816 264,981 61,101 2,142 72,715 88,389 Supplies 46,206 9,681 7,070 7,355 - 26,913 75,237 Other Service Charges 652,261 536,157 333,411 300,232 189,111 20,627 44,752 Intergovernmental Services - - 9,098 95,033 - - - Waste Management Payments - - - 2,325,984 - - - Sewer Metro Services - 4,172,056 - - - - - Interfund Operating Rentals/Supplies 344,206 257,353 443,842 61,500 - 22,036 54,004 Other Expenses - - 3,710 - - - - Depreciation & Amortization 726,141 591,051 424,660 6,273 130,696 19,687 105,464 TOTAL OPERATING EXPENSES 2,752,549 6,212,635 2,089,672 2,997,675 328,306 305,533 545,109 OPERATING INCOME (LOSS)49,101 (454,795) 339,959 750,266 (121,556) (50,355) (305,863) NON-OPERATING REVENUES & EXPENSES Interest Revenue 15,664 4,490 4,265 171 515 60 139 Other Non Operating Revenue 14,174 598 2,408 388 245 18 - Other Non Operating Expense - - - - - - - TOTAL NON-OPERATING REVENUES (EXPENSES)29,838 5,088 6,673 559 761 78 139 Plus Items Not Effecting Working Capital Depreciation 726,141 591,051 424,660 6,273 130,696 19,687 105,464 805,081 141,344 771,292 757,098 9,900 (30,590) (200,260) Increase in Contributions -System Development 136,592 79,909 117,098 - - - - Increase in Contributions -Area Assessments - - 3,206 - - - - Operating Transfers In - - - - - 200,000 8,354 Increase in Restricted Net Assets 3,680 8,119 - - (3,273) - Decrease in Long term Receivables - - - - - - - Increase in Deferred Credits - - - - (3,360) - - TOTAL RESOURCES OTHER THAN OPERATIONS 140,272 88,027 120,305 - (6,633) 200,000 8,354 Net Change in Restricted Net Assets 27,460 189 9,809 - (3,201) - (9,005) Increase in Fixed Assets - Salaries 43,031 38,426 14,214 - - - - Increase in Fixed Assets - Benefits 17,224 14,734 5,960 - - - - Increase in Fixed Assets - Site Improvements 27,699 - - - - - - Increase in Fixed Assets - Equipment 32,224 - - - - - - Increase in Fixed Assets - Construction 1,144,438 412,506 168,070 - - - - Operating Transfers Out 50,000 50,000 50,000 - - - - Debt Service Principal - - - - - - - TOTAL USES OTHER THAN OPERATIONS 1,342,076 515,856 248,054 - (3,201) - (9,005) NET CHANGE IN WORKING CAPITAL (396,724) (286,485) 643,543 757,098 6,469 169,410 (182,901) BEGINNING WORING CAPITAL January 1, 2012 16,945,811 12,806,527 9,102,000 632,263 961,633 71,820 68,320 ENDING WORKING CAPITAL April 30, 2012 16,549,086 12,520,043 9,745,543 1,389,361 968,102 241,229 (114,581) NET CHANGE IN WORKING CAPITAL (396,724) (286,485) 643,543 757,098 6,469 169,410 (182,901) NET WORKING CAPITAL FROM OPERATIONS 15 Monthly Financial Report April 2012 The Water Utility ended April 2012 with $49,000 in net income, reflecting increased water usage and rate revenue from the scheduled rate increase that took effect at the beginning of the year. - 200,000 400,000 600,000 800,000 1,000,000 1,200,000 JanFebMar Apr MayJunJulAugSepOctNovDec Water Revenues ($) vs Water Sold (ccf) 2011 -Present 2011 Water Sales ($) 2012 Water Sales ($) 2011 Water Sold (ccf) 2012 Water Sold (ccf) The Sewer Utility ended the period with a $455,000 net operating loss while the Stormwater Utility ended with $340,000 in net income. Auburn Golf Course (AGC) revenues from green fees increased in April to $113,000 as compared to $55,000 the previous month, reflecting an improvement the number of rounds played. The number of rounds played year-to-date totals 8,718 in 2012 compared to 7,644 in 2011. While the AGC ended April with a net operating loss of $306,000, its financial performance is expected to improve as play increases during the spring/summer season. $0 $50 $100 $150 $200 $250 $300 $350 JanFebMarAprMayJunJulAugSepOctNovDec Th o u s a n d s Golf Course Operating Revenues by Month (2012 vs 2011) 2012 Monthly Budget 2012 Actual 2011 Actual 16 Monthly Financial Report April 2012 The Cemetery Fund ended April 2012 with a $50,000 net operating loss. $0 $20 $40 $60 $80 $100 $120 $140 JanFebMarAprMayJunJulAugSepOctNovDec Th o u s a n d s Cemetery Operating Revenues by Month (2012 vs 2011) 2012 Monthly Budget 2012 Actual 2011 Actual 17 Monthly Financial Report April 2012 Internal Service Funds The following table provides an analysis of the City’s Internal Service funds – showing 2012 revenues and expenditures by fund. InformationEquipment InsuranceFacilities Services Rental OPERATING REVENUES: Interfund Charges for Services - 1,145,700 1,378,368 999,605 Rents, Leases, Concessions & Other - 34,169 31,274 - TOTAL OPERATING REVENUES - 1,179,869 1,409,642 999,605 OPERATING EXPENSES: Administration 731,157 - - 226,508 Operations & Maintenance - 685,849 1,402,822 482,766 Depreciation & Amortization - - 179,612 238,623 TOTAL OPERATING EXPENSES 731,157 685,849 1,582,434 947,897 OPERATING INCOME (LOSS)(731,157) 494,020 (172,792) 51,708 NON-OPERATING REVENUES & EXPENSES Interest Revenue 600 858 1,422 1,687 Other Non Operating Revenue (sale of fixed asset)- - - 38,214 Other Non Operating Expense - - - - TOTAL NON-OPERATING REVENUES (EXPENSES)600 858 1,422 39,901 INCOME (LOSS) BEFORE CONTRIBUTIONS & TRANSFERS (730,557) 494,878 (171,370) 91,609 Contributions - - - - Transfers In - 13,300 - - Transfers Out - (215,000) - (7,000) TOTAL CONTRIBUTIONS & TRANSFERS - (201,700) - (7,000) CHANGE IN FUND BALANCE (730,557) 293,178 (171,370) 84,609 BEGINNING FUND BALANCE January 1, 2012 2,184,680 1,570,419 4,350,183 10,135,919 ENDING FUND BALANCE April 30, 2012 1,454,123 1,863,596 4,178,813 10,220,528 18 Monthly Financial Report April 2012 The following table presents the Working Capital Statements for the City’s Internal Service funds. Working capital is generally defined as the difference between current assets and current liabilities. InformationEquipment InsuranceFacilities Services Rental OPERATING REVENUES: Interfund Charges for Services - 1,145,700 1,378,368 999,605 Rents, Leases, Concessions & Other - 34,169 31,274 TOTAL OPERATING REVENUES - 1,179,869 1,409,642 999,605 OPERATING EXPENSES: Salaries & Wages - 218,765 436,565 140,362 Benefits - 95,111 179,687 55,644 Supplies - 29,995 70,169 302,475 Other Service Charges 731,157 309,347 620,041 139,493 Interfund Operating Rentals/Supplies - 32,632 96,360 71,300 Depreciation & Amortization - - 179,612 238,623 TOTAL OPERATING EXPENSES 731,157 685,849 1,582,434 947,897 OPERATING INCOME (LOSS)(731,157) 494,020 (172,792) 51,709 NON-OPERATING REVENUES & EXPENSES Interest Revenue 600 858 1,422 1,687 Other Non Operating Revenue (sale of fixed asset)- - - 38,214 Other Non Operating Expense - - - - TOTAL NON-OPERATING REVENUES (EXPENSES)600 858 1,422 39,901 Plus Items Not Effecting Working Capital Depreciation - - 179,612 238,623 (730,557) 494,878 8,242 330,232 Increase in Contributions -Other Government - - - - Increase in Contributions -Other Funds - - - - Operating Transfers In - 13,300 - - TOTAL RESOURCES OTHER THAN OPERATIONS - 13,300 - - Net Change in Restricted Net Assets - - - - Increase in Fixed Assets - Site Improvements - - - 13,406 Increase in Fixed Assets - Equipment - - 232,047 326,543 Increase in Fixed Assets - Construction - 13,347 - - Operating Transfers Out - 215,000 - 7,000 TOTAL USES OTHER THAN OPERATIONS - 228,347 232,047 346,949 NET CHANGE IN WORKING CAPITAL (730,557) 279,831 (223,805) (16,717) BEGINNING WORING CAPITAL January 1, 2012 2,184,680 1,622,449 3,118,686 5,793,165 ENDING WORKING CAPITAL April 30, 2012 1,454,123 1,902,280 2,894,881 5,776,449 NET CHANGE IN WORKING CAPITAL (730,557) 279,831 (223,805) (16,717) NET WORKING CAPITAL FROM OPERATIONS 19 Monthly Financial Report April 2012 Operating expenses within the Insurance Fund represents the premium cost-pool that will be allocated monthly to other City funds over the course of 2012. As a result, this balance will gradually diminish each month throughout the entire year. The Information Services Fund ended April 2012 with a net operating loss – reflecting the timing of expenditures. No significant variances are reported in the Facilities Fund or Equipment Rental Fund. Both funds have had sufficient revenues to cover year-to-date expenses through April. Contact Information This report is prepared by the Finance Department. Additional financial information can also be viewed at our website: http://www.auburnwa.gov/. For any questions about the report please contact us at mchaw@auburnwa.gov or scoleman@auburnwa.gov. 20 Investment PurchasePurchaseMaturityYield to Type Date Price DateMaturity State Investment PoolVarious 79,126,069$ Various 0.15% KeyBank Money MarketVarious 12,190,629Various 0.15% US Treasury 05/04/1990 57,75005/15/20165.72% FFCB 6/6/20112,000,0006/6/20141.180% FHLB 6/13/20112,000,0006/13/20141.150% FHLMC 12/19/20112,000,00012/19/20141.000% FNMA 12/29/20112,000,00012/29/20140.900% Total Cash & Investments 99,374,448$ 0.225% Investment Mix% of Total State Investment Pool 79.6%Current 6-month treasury rate0.14% KeyBank Money Market 12.3%Current State Pool rate0.15% US Treasury 0.1%KeyBank Money Market0.15% FHLB 2.0%Blended Auburn rate0.22% FFCB 2.0% FHLMC 2.0% FNMA 2.0% 100.0% City of Auburn Investment Portfolio Summary April 30, 2012 Summary 21 SA L E S T A X S U M M A R Y AP R I L 2 0 1 2 S A L E S T A X D I S T R I B U T I O N S ( F O R N O V E M B E R - F E B R U A R Y 2 0 1 2 R E T A I L A C T I V I T Y ) 20 1 1 A n n u a l T o t a l 20 1 1 Y T D 20 1 2 Y T D YT D 2011AnnualTotal2011YTD2012YTDYTD NA I C S CO N S T R U C T I O N (N o v ' 1 0 - O c t ' 1 1 ) (N o v ' 1 0 - F e b ' 1 1 ) (N o v ' 1 1 - F e b ' 1 2 ) %D i f f NA I C S AU T O M O T I V E (Nov'10-Oct'11)(Nov'10-Feb'11)(Nov'11-Feb'12)%Diff 23 6 C o n s t r u c t i o n o f B u i l d i n g s 58 2 , 8 4 0 16 0 , 2 8 3 13 3 , 7 6 6 -1 6 . 5 % 4 4 1 M o t o r V e h i c l e a n d P a r t s D e a l e r 2,560,962786,913824,7424.8% 23 7 H e a v y a n d C i v i l C o n s t r u c t i o n 10 8 , 7 2 7 29 , 4 8 9 48 , 4 8 1 64 . 4 % 4 4 7 G a s o l i n e S t a t i o n s 224,45969,99672,6923.9% 23 8 S p e c i a l t y T r a d e C o n t r a c t o r s 60 4 , 2 4 5 20 5 , 3 2 4 18 6 , 1 9 9 -9 . 3 % TO T A L A U T O M O T I V E 2,785,421$856,909$897,434$4.7% TO T A L C O N S T R U C T I O N 1, 2 9 5 , 8 1 3 $ 39 5 , 0 9 6 $ 36 8 , 4 4 6 $ -6 . 7 % Ov e r a l l C h a n g e f r o m P r e v i o u s Y e a r 40,524$ Ov e r a l l C h a n g e f r o m P r e v i o u s Y e a r (2 6 , 6 5 1 ) $ 2011AnnualTotal2011YTD2012YTDYTD 20 1 1 A n n u a l T o t a l 20 1 1 Y T D 20 1 2 Y T D YT D NA I C S RE T A I L T R A D E (Nov'10-Oct'11)(Nov'10-Feb'11)(Nov'11-Feb'12)%Diff NA I C S MA N U F A C T U R I N G (N o v ' 1 0 - O c t ' 1 1 ) (N o v ' 1 0 - F e b ' 1 1 ) (N o v ' 1 1 - F e b ' 1 2 ) %D i f f 44 2 F u r n i t u r e a n d H o m e F u r n i s h i n g s 218,33572,77076,2444.8% 31 1 F o o d M a n u f a c t u r i n g 2, 6 7 4 66 5 1, 1 4 9 72 . 7 % 4 4 3 E l e c t r o n i c s a n d A p p l i a n c e s 126,87046,11449,9438.3% 31 2 B e v e r a g e a n d T o b a c c o P r o d u c t s 3, 8 6 4 1, 2 1 9 1, 2 7 3 4. 4 % 4 4 4 B u i l d i n g M a t e r i a l a n d G a r d e n 382,504100,114111,80811.7% 31 3 T e x t i l e M i l l s 95 9 74 41 -4 4 . 3 % 4 4 5 F o o d a n d B e v e r a g e S t o r e s 330,776109,613109,383-0.2% 31 4 Te x t i l e P r o d u c t M i l l s 2, 6 2 5 49 2 1, 9 0 1 28 6 . 4 % 44 6 He a l t h a n d P e r s o n a l C a r e S t o r e 148,38752,54254,7134.1% 31 4 Te x t i l e P r o d u c t M i l l s 2, 6 2 5 49 2 1, 9 0 1 28 6 . 4 % 44 6 He a l t h a n d P e r s o n a l C a r e S t o r e 148,38752,54254,7134.1% 31 5 A p p a r e l M a n u f a c t u r i n g 2, 5 1 9 2, 3 6 6 16 0 -9 3 . 2 % 4 4 8 C l o t h i n g a n d A c c e s s o r i e s 754,407270,213264,812-2.0% 31 6 L e a t h e r a n d A l l i e d P r o d u c t s 17 5 12 45 26 5 . 6 % 4 5 1 S p o r t i n g G o o d s , H o b b y , B o o k s 126,04248,77446,237-5.2% 32 1 W o o d P r o d u c t M a n u f a c t u r i n g 24 , 0 7 5 7, 7 2 6 5, 9 0 2 -2 3 . 6 % 4 5 2 G e n e r a l M e r c h a n d i s e S t o r e s 967,627382,064353,511-7.5% 32 2 P a p e r M a n u f a c t u r i n g 11 , 0 2 6 4, 8 5 5 1, 3 5 5 -7 2 . 1 % 4 5 3 M i s c e l l a n e o u s S t o r e R e t a i l e r s 489,259167,036153,978-7.8% 32 3 P r i n t i n g a n d R e l a t e d S u p p o r t 38 , 5 1 1 15 , 4 8 5 11 , 8 8 6 -2 3 . 2 % 4 5 4 N o n s t o r e R e t a i l e r s 235,92388,76492,2603.9% 32 4 P e t r o l e u m a n d C o a l P r o d u c t s 9, 7 7 1 90 5 2, 3 1 6 15 6 . 0 % TO T A L R E T A I L T R A D E 3,780,129$1,338,005$1,312,889$-1.9% 32 5 C h e m i c a l M a n u f a c t u r i n g 7, 9 3 7 1, 7 8 4 1, 6 8 3 -5 . 7 % Ov e r a l l C h a n g e f r o m P r e v i o u s Y e a r (25,116)$ 32 6 P l a s t i c s a n d R u b b e r P r o d u c t s 9, 7 7 7 3, 5 3 7 3, 3 3 7 -5 . 7 % 32 7 N o n m e t a l l i c M i n e r a l P r o d u c t s 16 , 2 1 8 3, 4 1 1 4, 0 0 1 17 . 3 % 33 1 P r i m a r y M e t a l M a n u f a c t u r i n g 45 2 39 1, 1 1 1 27 2 6 . 0 % 2011AnnualTotal2011YTD2012YTDYTD 33 2 F a b r i c a t e d M e t a l P r o d u c t M a n u f 19 , 6 6 1 7, 3 9 4 4, 0 3 9 -4 5 . 4 % NA I C S SE R V I C E S (Nov'10-Oct'11)(Nov'10-Feb'11)(Nov'11-Feb'12)%Diff 33 3 M a c h i n e r y M a n u f a c t u r i n g 14 , 2 4 2 4, 6 8 3 4, 7 4 1 1. 2 % 5 1 * I n f o r m a t i o n 481,043135,414129,286-4.5% 33 4 C o m p u t e r a n d E l e c t r o n i c P r o d u c 16 , 7 7 6 4, 6 6 4 2, 5 1 8 -4 6 . 0 % 5 2 * F i n a n c e a n d I n s u r a n c e 65,51820,3344,649b-77.1% 33 5 E l e c t r i c E q u i p m e n t , A p p l i a n c e s 78 0 84 19 2 12 9 . 7 % 5 3 * R e a l E s t a t e , R e n t a l , L e a s i n g 303,75094,461106,46212.7% 33 6 T r a n s p o r t a t i o n E q u i p m e n t M a n 36 2 , 1 4 9 14 8 , 9 0 7 16 , 2 3 5 a -8 9 . 1 % 5 4 1 P r o f e s s i o n a l , S c i e n t i f i c , T e c h 174,71860,45757,379-5.1% 33 7 F u r n i t u r e a n d R e l a t e d P r o d u c t s 13 , 1 3 5 3, 1 3 9 4, 9 9 2 59 . 0 % 5 5 1 C o m p a n y M a n a g e m e n t 351464-91.1% 33 9 M i s c e l l a n e o u s M a n u f a c t u r i n g 25 , 5 3 1 9, 8 7 4 6, 4 3 7 -3 4 . 8 % 5 6 * A d m i n . S u p p . , R e m e d S v c s 294,60382,50185,1283.2% TO T A L M A N U F A C T U R I N G 58 2 , 8 5 8 $ 22 1 , 3 1 5 $ 75 , 3 1 7 $ -6 6 . 0 % 61 1 E d u c a t i o n a l S e r v i c e s 52,56315,83715,480-2.3% TO T A L M A N U F A C T U R I N G 58 2 , 8 5 8 $ 22 1 , 3 1 5 $ 75 , 3 1 7 $ -6 6 . 0 % 61 1 Ed u c a t i o n a l S e r v i c e s 52,56315,83715,480-2.3% Ov e r a l l C h a n g e f r o m P r e v i o u s Y e a r (1 4 5 , 9 9 8 ) $ 62 * H e a l t h C a r e S o c i a l A s s i s t a n n c e 40,7375,04612,753152.8% 71 * A r t s a n d E n t e r t a i n m e n t 148,62976,22577,5131.7% 72 * A c c o m o d a t i o n a n d F o o d S v c s 838,924258,362285,28710.4% 20 1 1 A n n u a l T o t a l 20 1 1 Y T D 20 1 2 Y T D YT D 81 * O t h e r S e r v i c e s 389,241127,873126,652-1.0% NA I C S TR A N S P O R T A T I O N A N D W A R E H O U S I N G (N o v ' 1 0 - O c t ' 1 1 ) (N o v ' 1 0 - F e b ' 1 1 ) (N o v ' 1 1 - F e b ' 1 2 ) %D i f f 92 * P u b l i c A d m i n i s t r a t i o n 92,16328,76135,56823.7% 48 1 A i r T r a n s p o r t a t i o n 24 24 - -1 0 0 . 0 % TO T A L S E R V I C E S 2,882,241$905,318$936,160$3.4% 48 2 R a i l T r a n s p o r t a t i o n 17 , 8 3 1 6, 0 1 6 2, 8 9 7 -5 1 . 8 % Ov e r a l l C h a n g e f r o m P r e v i o u s Y e a r 30,842$ 48 4 T r u c k T r a n s p o r t a t i o n 36 , 2 6 1 5, 7 0 7 4, 8 2 5 -1 5 . 5 % 48 5 T r a n s i t a n d G r o u n d P a s s e n g e r s 68 39 21 5 45 5 . 7 % 48 8 T r a n s p o r t a t i o n S u p p o r t 18 , 0 8 3 5, 5 8 7 5, 3 5 3 -4 . 2 % 2011AnnualTotal2011YTD2012YTDYTD 49 1 P o s t a l S e r v i c e 20 2 75 78 4. 6 % NA I C S MI S C E L L A N E O U S (Nov'10-Oct'11)(Nov'10-Feb'11)(Nov'11-Feb'12)%Diff 49 2 C o u r i e r s a n d M e s s e n g e r s 1, 4 9 2 61 6 24 3 -6 0 . 5 % 0 0 0 U n k n o w n 1,958-1N/A 49 3 W a r e h o u s i n g a n d S t o r a g e 3, 1 2 1 1, 0 5 1 2, 0 0 8 90 . 9 % 1 1 1 - 1 1 5 A g r i c u l t u r e , F o r e s t r y , F i s h i n g 7,3551,906506-73.5% TO T A L T R A N S P O R T A T I O N 77 , 0 8 3 $ 19 , 1 1 5 $ 15 , 6 1 8 $ -1 8 . 3 % 21 1 - 2 2 1 M i n i n g & U t i l i t i e s 21,8304,3726,32544.7% Ov e r a l l C h a n g e f r o m P r e v i o u s Y e a r (3 , 4 9 7 ) $ 99 9 U n c l a s s i f i a b l e E s t a b l i s h m e n t s 192,49616,2815,866-64.0% TO T A L S E R V I C E S 223,639$22,559$12,697$-43.7% Ov e r a l l C h a n g e f r o m P r e v i o u s Y e a r (9,862)$ 20 1 1 A n n u a l T o t a l 20 1 1 Y T D 20 1 2 Y T D YT D NA I C S WH O L E S A L E T R A D E (N o v ' 1 0 - O c t ' 1 1 ) (N o v ' 1 0 - F e b ' 1 1 ) (N o v ' 1 1 - F e b ' 1 2 ) %D i f f NA I C S WH O L E S A L E T R A D E (N o v ' 1 0 - O c t ' 1 1 ) (N o v ' 1 0 - F e b ' 1 1 ) (N o v ' 1 1 - F e b ' 1 2 ) %D i f f 42 3 W h o l e s a l e T r a d e , D u r a b l e G o o d s 1, 0 9 5 , 9 0 5 34 6 , 4 4 6 36 2 , 9 9 3 4. 8 % GR A N D T O T A L 12,887,267$4,157,682$4,030,997$ 42 4 W h o l e s a l e T r a d e , N o n d u r a b l e 15 0 , 4 8 0 51 , 1 7 8 47 , 8 5 8 -6 . 5 % Ov e r a l l C h a n g e f r o m P r e v i o u s Y e a r (126,685)$-3.0% 42 5 W h o l e s a l e E l e c t r o n i c M a r k e t s 13 , 6 9 8 1, 7 4 1 1, 5 8 5 -8 . 9 % TO T A L W H O L E S A L E 1, 2 6 0 , 0 8 3 $ 39 9 , 3 6 4 $ 41 2 , 4 3 6 $ 3. 3 % Ov e r a l l C h a n g e f r o m P r e v i o u s Y e a r 13 , 0 7 2 $ a. W a . S t a t e D e p t o f R e v e n u e a u d i t a d j u s t m e n t t o s a l e s t a x r e t u r n s f o r p e r i o d N o v 2 0 1 1 ( a d j u s t m e n t : - $ 7 3 , 9 7 1 ) . b. W a . S t a t e D e p t o f R e v e n u e a u d i t a d j u s t m e n t t o s a l e s t a x r e t u r n s f o r p e r i o d D e c 2 0 1 1 ( a d j u s t m e n t : - $ 2 0 , 0 1 4 ) . 04 / 2 3 / 1 2 file:MonthlySalesTaxReport.xls Pr e p a r e d b y A u b u r n F i n a n c i a l P l a n n i n g 22