HomeMy WebLinkAboutNovember 2011 AGENDA BILL AP PROVAL FORM Agenda Subject: November 2011 Financial Report Date: 01/17/2012 Department: Finance Attachments: November Monthly 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 financial affairs throughout the City and to highlight signi ficant items or trends that the City Council should be aware of. The following provides a high level su mmary of the City’s financial performance. Further detail can be found within the attached financial report. The November 2011 status report highlights City revenues and expenditures and is based on financial data available as of December 22, 2011. Sales tax r eported in November is for business activities that occurred in September 2011. General Fund : The general fund accounts for all of the City’s financial resources except those required by statute or to be accounted for in another fund. The General Fund is the City’s largest fund and is used to account for the majority of City services. As of the end of November, General Fund revenue collections totaled $48.8 million, and compares to year-to-date budget of $47.2 million and were sufficient to meet expenses of $44.3 million. Total General Fund revenues for the City at the end of November are $1.6 million higher than budget due to relatively stronger than anticipated collections in property and sales taxes, electric utility taxes and building permit fees. The City’s sales taxes totaled $13.5 million and are 1.5% higher than last year. Improvement in retail activity was noted in all areas with the exceptio n of construction and services which remain weak, reflecting continued weakness in the housing market. Expenditures for the General Fund were $5.5 million below budget at the end of November. This is primarily due to unspent budget for retirement and lo ng term care along with timing of payments for SCORE, savings due to staff vacancies, interfund transfers and under expenditures in professional services. Enterprise Funds : The City’s eight enterprise funds ac count for operations with revenues primarily provided from user fees, charges or contracts for services. At the end of November the Water fund recognized a m odest operating income as a result of a back bill adjustment along with seasonal increase in irrigation usage during the late summer months. The Sewer fund ended this period with an operating loss due to declining revenues as a result of lower water consumption during the first half of the year and ti ming of payments to Metro for sewer services. Stormwater revenues are on target and are sufficient to meet expenses. 1
Agenda Subject: November 2011 Financial Report Date: 01/17/2012 Despite improved revenues during the summer months t he Golf Course ended October with slightly less revenues compared to the same period in 2010 due to less favorable weather conditions; and is projected to experience operating losses for the remainder of the year. Cemetery program revenues were higher than the same period last year but were not sufficient to erase a year-to-date operating loss. To addr ess the current year cash flow needs of this fund, the Council approved a transfer of $200,000 from the Cumulative Reserve fund (Budget Amendment #5, Ordinance #6378) to the Cemetery fund. Internal Service Funds : Internal Service Funds provide services to ot her City departments and include functions such as Insurance, Facilities, Information Services, and Equipment Rental. At the end of the November, revenue from charges as sessed to internal client departments was sufficient to meet expenses. Year to date expenses for the insurance fund included payment of the annual insurance premium and will be offset by allocations to various departments that will occur throughout the remainder of the year. Investment Portfolio : The City’s total cash and investments at the end of November was $100 million and compares to $102 million in October. 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: January 17, 2012 Item Number: 2
Monthly Financial Report Monthly Financial Report Monthly Financial Report Monthly Financial Report November 2011 November 2011 November 2011 November 2011 (1) The anticipated Streamlined Sales Tax for 2011 is $1,965,470. The year-to-date actual sales tax amount is adjusted t o include $1,493,061 SST Mitigation the City received from the State through the 3 rd quarter of 2011 plus $327,578 a l location for October & November that will be received in December. General Fund General Fund General Fund General Fund 2010 20102010 2010 Summary of Sources and Uses Summary of Sources and Uses Summary of Sources and Uses Summary of Sources and Uses Annual Budget Annual Budget Annual Budget Annual BudgetYTD Budget YTD Budget YTD Budget YTD BudgetYTD Actual YTD Actual YTD Actual YTD ActualYTD Actual YTD Actual YTD Actual YTD ActualAmount AmountAmount AmountPercentage Percentage Percentage Percentage OPERATING REVENUES OPERATING REVENUES OPERATING REVENUES OPERATING REVENUES Property Tax 12,022,340 11,956,940 12,436,989 12,589,826 480,049 4.0%Sales Tax (1)14,295,000 13,185,900 13,537,143 13,338,537 351,243 2.7%Sales Tax - Annexation Credit 1,356,600 1,251,500 1,343,269 1,294,863 91,769 7.3%Criminal Justice Sales Tax 1,177,600 1,084,000 1,240,245 1,148,308 156,245 14.4%Brokered Natural Gas Tax 260,000 238,400 278,289 248,334 39,889 16.7%City Utilities Tax 2,522,800 2,347,700 2,293,310 2,190,598 (54,390) -2.3%Admissions Tax 350,000 349,200 357,583 361,539 8,383 2.4%Electric Tax 2,850,000 2,850,000 3,092,930 2,995,902 242,930 8.5%Natural Gas Tax 1,270,410 1,270,410 1,120,789 989,346 (149,621) -11.8%Cable TV Franchise Fee 689,800 689,800 800,068 794,731 110,268 16.0%Cable TV Franchise Fee - Capital 75,000 75,000 63,678 - (11,322) -15.1%Telephone Tax 1,972,900 1,828,000 1,876,946 1,937,455 48,946 2.7%Garbage Tax (external)150,000 138,100 140,638 143,631 2,538 1.8%Leasehold Excise Tax 45,000 36,400 29,711 28,019 (6,689) -18.4%Gambling Excise Tax 326,500 307,700 252,805 253,529 (54,895) -17.8%Business License Fees 200,000 104,700 131,956 123,039 27,256 26.0%Building Permits 700,000 607,800 1,043,959 679,816 436,159 71.8%Other Licenses & Permits 229,000 205,500 446,806 294,573 241,306 117.4%Intergovernmental (Grants, etc)4,008,745 3,518,145 3,208,205 3,401,298 (309,940) -8.8%Charges for Services: General Government Services 64,600 59,600 78,331 77,775 18,731 31.4% Public Safety 216,000 195,800 221,564 203,578 25,764 13.2% Development Services Fees 627,000 546,900 478,700 577,973 (68,200) -12.5% Culture and Recreation 877,500 830,200 750,340 814,032 (79,860) -9.6%Fines and Forfeits 2,208,500 2,005,800 1,813,989 2,274,223 (191,811) -9.6%Interests and Other Earnings 110,000 101,200 82,069 127,508 (19,131) -18.9%Rents, Leases and Concessions 315,000 285,300 302,193 565,721 16,893 5.9%Contributions and Donations 17,900 16,400 51,483 54,223 35,083 213.9%Other Miscellaneous 48,980 46,480 109,787 109,205 63,307 136.2%Proceeds of Gen. Long Term Debt-Refi Valley Com - - - 1,069,000 - N/A Transfers In 1,078,439 1,078,439 1,078,439 61,300 - 0.0%Insurance Recoveries- Capital & Operating 25,000 22,900 150,069 101,643 127,169 555.3%Total Operating Revenues Total Operating Revenues Total Operating Revenues Total Operating Revenues 50,090,614 47,234,214 48,812,279 48,849,523 1,578,065 3.3%Operating Expenditures Operating Expenditures Operating Expenditures Operating Expenditures Council & Mayor 863,420 791,220 712,355 613,424 78,865 10.0%Municipal Court & Probation 3,281,520 2,953,620 2,745,617 2,481,426 208,003 7.0%Human Resources 830,710 765,310 722,126 641,455 43,184 5.6%Finance 1,162,900 1,048,500 1,020,479 990,727 28,021 2.7%City Attorney 1,640,480 1,509,980 1,413,664 1,442,414 96,316 6.4%Planning 3,749,540 3,463,040 3,262,432 2,975,403 200,608 5.8%Community & Human Services 1,088,430 1,002,830 901,259 783,671 101,571 10.1%Jail - SCORE 6,087,470 5,443,370 4,199,912 - 1,243,458 22.8%Police 19,843,980 17,706,280 16,378,664 19,540,471 1,327,616 7.5%Engineering 2,380,410 2,167,510 2,031,591 2,219,274 135,920 6.3%Parks and Recreation 7,325,570 6,665,670 6,441,113 6,029,609 224,557 3.4%Streets 3,125,960 2,830,060 2,435,826 2,473,597 394,234 13.9%Non-Departmental 4,500,620 3,461,820 2,022,182 4,616,754 1,439,638 41.6%Total Operating Expenditures Total Operating Expenditures Total Operating Expenditures Total Operating Expenditures 55,881,010 49,809,210 44,287,220 44,808,224 5,521,990 11.1%2011 20112011 2011 2011 YTD Budget vs. Actual 2011 YTD Budget vs. Actual 2011 YTD Budget vs. Actual 2011 YTD Budget vs. Actual Favorable (Unfavorable)Favorable (Unfavorable)Favorable (Unfavorable)Favorable (Unfavorable)3
Monthly Financial Report Monthly Financial Report Monthly Financial Report Monthly Financial Report November 2011 November 2011 November 2011 November 2011 Overview Ov erviewOverview Overview This financial overview reflects the City’s overall financial position for the fiscal year through November 30, 2011. The report represents financial data available as of December 22, 2011. The budgeted year-to-date revenues and operating expenses are primarily based on the collection/disbursement average for the same period of the two prior years. The table on the previous page summarizes the General Fund revenues and expenditures. At the end of November, General Fund revenues totaled $48.8 million and are nearly equal to the same period of 2010. General Fund revenue highlights include: - Property taxes totaled $12.4 million and are slightly lower than the level collected for the same period last year. - Sales taxes totaled $13.5 million, are $198.6K higher compared to collections as of November 2010. Review of sales tax activity by sector show improvements in all sectors with the exception of construction and services, which is below the same period last year due to a one-time sales tax adjustment in 2010. - Development service fees (engineering, zoning, sub-division and plan check), culture and recreational charges for services and fines and penalties, primarily from photo enforcement showed declines over the previous year. General Fund expenses at the end of November totaled $44.3 million compared to $44.8 million for same period 2010. When compared to budget, General Fund expenses were 11.1% below expectations. Highlights include: - Timing of intergovernmental payments for SCORE accounted for the majority of the variance against budget. Currently there is an estimated $1.4 million billing from SCORE for September through November and additional $27,800 from King County for October and November services that will be posted in December. When these payments are processed in December the SCORE expenses will be in line with the budget. - Police expenditures are low compared to budget due to savings from staff vacancies. - Streets expenditures were below budget due to savings from staff vacancies and unspent budget for repairs & maintenance. - Non departmental was below budget primarily due to unspent budget for retirement benefits, SCORE start up transition costs and the timing of transfers out that are anticipated to occur during December of 2011. Revenues RevenuesRevenues Revenues The combined total of property tax, sales/use tax, utility tax, gambling, and admissions tax provide 80% of all resources supporting general governmental activities. The following section provides detail information on these sources. Property Tax Property Tax Property Tax Property Tax Year-to-date collection at the end of November is $12.4 million, reflecting the majority of the second half 2011 property tax payments, and is $480K higher than targeted revenues. 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. 4
Monthly Financial Report Monthly Financial Report Monthly Financial Report Monthly Financial Report November 2011 November 2011 November 2011 November 2011 $0.0 $2.0 $4.0 $6.0 $8.0 $10.0 $12.0 $14.0 JanFebMarAprMayJunJulAugSepOctNovDec Millions Millions Millions Millions Property Taxes Property Taxes Property Taxes Property Taxes 2011 budget 2011 actual to date 2010 actual Sales Tax Sales TaxSales Tax Sales Tax Sales taxes are running slightly ahead of the previous year’s pace. Year-to-date sales tax revenue totaled $13.5 million and compares to a year-to-date budget of $13.2 million. Sales taxes include Streamlined Sales Tax Mitigation payments of $1,493,061 received through the end of 3 rd quarter pl us $327,578 allocation for October and November. Total estimated Streamlined Sales Tax Mitigation for 2011 is $1,965,470 but the actual amount 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. While sales tax returns have improved slightly over the previous year, reflecting the decrease in unemployment, and slight increase in existing home sales; the debt crisis in Europe continue to dampen overall consumer sentiment and the pace of the economic recovery in the short term. $0.0 $2.0 $4.0 $6.0 $8.0 $10.0 $12.0 $14.0 $16.0 JanFebMarAprMayJunJulAugSepOctNovDec Millions Millions Millions Millions Sales & Use Tax Sales & Use Tax Sales & Use Tax Sales & Use Tax 2011 budget 2011 actual to date 2010 actual ****In cludes Sales Tax Mitigation prorated monthly. 5
Monthly Financial Report Monthly Financial Report Monthly Financial Report Monthly Financial Report November 2011 November 2011 November 2011 November 2011 The following table breaks out the City’s base sales tax excluding Criminal Justice, Annexation Cr edit and Streamlined Sales Tax Mitigation by major business sectors. 2010 20102010 20102011 20112011 2011 Component Group Component Group Component Group Component GroupActual ActualActual ActualActual ActualActual ActualAmount AmountAmount AmountPercentage Percentage Percentage Percentage New Construction 1,206,933 1,184,356 (22,577) -1.9%Manufacturing 386,340 533,379 147,039 38.1%Transportation & Warehousing26,896 70,870 43,974 163.5%Wholesale Trade 1,077,576 1,149,727 72,151 6.7%Automotive 2,338,783 2,550,466 211,683 9.1%Retail Trade 3,305,820 3,470,372 164,552 5.0%Services 3,094,924 2,580,962 (513,962) -16.6%Miscellaneous 116,192 212,110 95,918 82.6%YTD Total 11,553,464 11,752,242 198,778 1.7%Change from 2010 Change from 2010 Change from 2010 Change from 2010 Year to Date through November Year to Date through November Year to Date through November Year to Date through November Comparison of Sales Tax Collections by SIC Group Comparison of Sales Tax Collections by SIC Group Comparison of Sales Tax Collections by SIC Group Comparison of Sales Tax Collections by SIC Group Utility Tax Utility TaxUtility Tax Utility Tax This revenue source consists of City inter-fund utility taxes (Water, Sewer, Storm and Solid Waste) and external utility taxes (Electric, Natural gas, Telephone and Solid Waste). Year-to-date collections is in line with expectations, totaling $8.5 million or 3.2% more than 2010, due primarily to higher revenues from the City inter-fund utility taxes, electric and natural gas utility taxes which have offset lower than anticipated revenues from telephone and solid waste utility taxes. $0.0 $1.0 $2.0 $3.0 $4.0 $5.0 $6.0 $7.0 $8.0 $9.0 $10.0 JanFebMarAprMayJunJulAugSepOctNovDec Millions Millions Millions Millions Utility Tax Utility TaxUtility Tax Utility Tax 2011 budget 2011 actual to date 2010 actual 6
Monthly Financial Report Monthly Financial Report Monthly Financial Report Monthly Financial Report November 2011 November 2011 November 2011 November 2011 The following table presents utility tax collections by source: 2010 20102010 20102011 20112011 20112011 20112011 2011 Month MonthMonth Month Actual ActualActual ActualBudget BudgetBudget BudgetActual ActualActual ActualAmount AmountAmount Amount Percentage Percentage Percentage Percentage Amount AmountAmount AmountPercentage Percentage Percentage Percentage City Interfund Utility Taxes2,190,598 2,347,700 2,293,310 102,712 4.7%(54,390) -2.3%Electric 2,995,902 2,850,000 3,092,930 97,028 3.2%242,930 8.5%Natural Gas 989,346 1,270,410 1,120,789 131,443 13.3%(149,621) -11.8%Telephone 1,937,455 1,828,000 1,876,946 (60,509) -3.1%48,946 2.7%Solid Waste 143,631 138,100 140,638 (2,993) -2.1%2,538 1.8%YTD Total 8,256,932 8,434,210 8,524,613 267,681 3.2%90,403 1.1%Annual Total 8,591,258 8,766,110 Year to Date through November Year to Date through November Year to Date through November Year to Date through November Utilty Tax by Type Utilty Tax by Type Utilty Tax by Type Utilty Tax by Type 2011 vs. 2010 2011 vs. 2010 2011 vs. 2010 2011 vs. 2010 2011 vs. Budget 2011 vs. Budget 2011 vs. Budget 2011 vs. Budget Cable TV Franchise Fees, which is fully collected for the year, totaled $800,067 has outpaced the previous year and current year budget. $0 $100 $200 $300 $400 $500 $600 $700 $800 $900 1st Quarter2nd Quarter3rd Quarter4th Quarter Thousands Thousands Thousands Thousands Cable TV Franchise Fee Cable TV Franchise Fee Cable TV Franchise Fee Cable TV Franchise Fee 2011 budget 2011 actual to date 2010 actual Licenses and Permits Licenses and Permits Licenses and Permits 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 November, the City has collected $493,720 more than the annual projected revenue from licenses and permits. Building permit fees and Business licenses make up 80% of the annual budgeted revenue in this category. Total building permit revenues at the end of November were $1,043,959; this was $436.2K or 71.8% more than the 2011 budgeted year-to-date revenues. The increase in November is primarily due to permits related to Auburn 40 PUD and Lakeland East developments. 7
Monthly Financial Report Monthly Financial Report Monthly Financial Report Monthly Financial Report November 2011 November 2011 November 2011 November 2011 2010 20102010 20102011 20112011 20112011 20112011 2011 Month MonthMonth MonthActual ActualActual ActualBudget BudgetBudget BudgetActual ActualActual ActualAmount AmountAmount AmountPercentage Percentage Percentage PercentageAmount AmountAmount AmountPercentage Percentage Percentage Percentage Jan 88,175 59,900 78,928 (9,246) -10.5%19,028 31.8%Feb 49,731 38,300 53,862 4,131 8.3%15,562 40.6%Mar 43,796 37,500 40,897 (2,899) -6.6%3,397 9.1%Apr 44,422 56,800 84,239 39,817 89.6%27,439 48.3%May 96,244 61,500 104,495 8,252 8.6%42,995 69.9%Jun 74,701 94,500 151,177 76,476 102.4%56,677 60.0%Jul 72,745 64,300 178,330 105,585 145.1%114,030 177.3%Aug 61,216 50,600 124,922 63,706 104.1%74,322 146.9%Sep 55,073 42,600 92,413 37,339 67.8%49,813 116.9%Oct 62,522 63,500 87,970 25,447 40.7%24,470 38.5%Nov 31,192 38,300 46,726 15,534 49.8%8,426 22.0%Dec 89,861 92,200 0.0%0.0%YTD Total679,816 607,800 1,043,959 364,142 53.6%436,159 71.8%Annual Total769,678 700,000 Year to Date through November Year to Date through November Year to Date through November Year to Date through November Building Permits Building Permits Building Permits Building Permits 2011 vs. 2010 2011 vs. 2010 2011 vs. 2010 2011 vs. 20102011 vs. Budget 2011 vs. Budget 2011 vs. Budget 2011 vs. Budget Business License revenues at the end of November were $4.6K more than 2010 and $27.3K or 26% more than the 2011 year-to-date budget. Revenues are higher compared to year-to-date budget and 2010 for the same period primarily due to increased outreach efforts to educate and contact businesses regarding licensing applications and renewals. $0 $50 $100 $150 $200 $250 JanFebMarAprMayJunJulAugSepOctNovDec Thousands Thousands Thousands Thousands Business License Business License Business License Business License 2011 budget 2011 actual to date 2010 actual 8
Monthly Financial Report Monthly Financial Report Monthly Financial Report Monthly Financial Report November 2011 November 2011 November 2011 November 2011 Intergovernmental Int ergovernmental Intergovernmental Intergovernmental Revenues in this category include Grants (Direct & Indirect Federal, State and Local); State shared revenues and compact revenue from the Muckleshoot Indian Tribe. At the end of November intergovernmental revenues were 5.7% less than 2010 and 8.8% less than budget mainly due to the timing of grant reimbursements. Intergovernmental Service revenues of $24.9K represents reimbursement from the Valley Regional Fire Authority for 9/11 Commemoration expenses, reimbursement from Washington State for Crisis Intervention Training and reimbursement from City of Algona & City of Pacific for Emergency Management division VISTA project expenses. 2010 20102010 20102011 20112011 20112011 20112011 2011 Revenue RevenueRevenue Revenue Actual ActualActual ActualBudget BudgetBudget BudgetActual ActualActual Actual% Change % Change % Change % Change% Change % Change % Change % Change Federal Grants 424,868 490,100 412,864 -2.8%-15.8%State Grants 128,231 12,600 116,040 -9.5%821.0%Interlocal Grants 138,996 35,900 3,151 -97.7%-91.2%State Shared Revenue2,340,972 2,384,445 1,938,976 -17.2%-18.7%Muckleshoot Casino Emerg.368,231 595,100 712,294 93.4%19.7%Intergovernmental Service - - 24,880 N/A N/A YTD Total 3,401,298 3,518,145 3,208,205 -5.7%-8.8%Annual Total 4,089,803 4,008,745 YTD %83%88%80%Year to Date through November Year to Date through November Year to Date through November Year to Date through November Intergovernmental Intergovernmental Intergovernmental Intergovernmental 2011 vs. 2010 2011 vs. 2010 2011 vs. 2010 2011 vs. 20102011 vs. Budget 2011 vs. Budget 2011 vs. Budget 2011 vs. Budget Total state shared revenues are $402K lower than the same period 2010 and $445.5K less than 2011 budget due to the change in revenue recognition of the Motor Vehicle Fuel tax (MVFT). Beginning in 2011, the MVFT allocation for Arterial Street fund and Recreational Trails fund will be posted directly to each fund instead of the General Fund. This change in accounting, which equates to a $537,100 budget reduction for MVFT in the General Fund was requested in Budget Amendment #5 and will be reflected in the December report. 2010 20102010 20102011 20112011 20112011 20112011 2011 Revenue RevenueRevenue Revenue Actual ActualActual ActualBudget BudgetBudget BudgetActual ActualActual ActualAmount AmountAmount AmountPercentage Percentage Percentage PercentageAmount AmountAmount AmountPercentage Percentage Percentage Percentage Trial Court Improvements22,638 24,500 22,468 (170) -0.8%(2,032) -8.29%Court Interpreter Program 4,518 6,640 6,643 2,125 N/A3 0.04%Motor Vehicle Fuel Tax1,334,589 1,336,710 906,172 (428,417) -32.1%(430,538) -32.2%Criminal Justice -High Crime74,525 148,975 146,442 71,917 96.5%(2,533) -1.70%Criminal Justice -Population41,688 15,200 15,470 (26,218) -62.9%270 1.8%Criminal Justice -Spec. Prog.56,884 55,300 58,404 1,520 2.7%3,104 5.6%State DUI 12,510 7,000 14,720 2,209 17.7%7,720 110.3%Fire Insurance Premium Tax63,545 65,000 66,375 2,830 4.5%1,375 2.12%Liquor Excise Tax 327,709 338,990 335,127 7,418 2.3%(3,863) -1.1%Liquor Profits 402,365 386,130 367,156 (35,209) -8.8%(18,974) -4.91%YTD Total 2,340,972 2,384,445 1,938,976 (401,995) -17.2%(445,469) -18.7%Annual Total 2,594,749 2,624,945 Year to Date through November Year to Date through November Year to Date through November Year to Date through November State Shared Revenues State Shared Revenues State Shared Revenues State Shared Revenues 2011 vs. 2010 2011 vs. 2010 2011 vs. 2010 2011 vs. 20102011 vs. Budget 2011 vs. Budget 2011 vs. Budget 2011 vs. Budget 9
Monthly Financial Report Monthly Financial Report Monthly Financial Report Monthly Financial Report November 2011 November 2011 November 2011 November 2011 Charges for Services Ch arges for Services Charges for Services Charges for Services This revenue source consists of general governmental services, public safety, development service fees and cultural & recreation fees. Development services and culture & recreation revenues make up approximately 84% of the $1.78 million annual budget for this category and are presented following the Charges for Service table below. At the end of November, revenue from charges for services totaled $1.5 million and was 6.3% below budget due to lower than anticipated revenues from development services and culture & recreation programs. General government services include passport services, administrative fees, court duplicating costs and sale of maps & publications. This income category is higher compared to 2010 primarily due to an $11.6K write off of prior years debit balance in October 2010 for City of Algona court services. Public Safety consists of law enforcement services, probation and prisoner lodging fees; overall this revenue source is $25.8K or 13.2% more than budget at the end of November due to increased receipts from probation fees. 2010 20102010 20102011 20112011 20112011 20112011 2011 Revenue RevenueRevenue Revenue Actual ActualActual ActualBudget BudgetBudget BudgetActual ActualActual ActualAmount AmountAmount AmountPercentage Percentage Percentage PercentageAmount AmountAmount AmountPercentage Percentage Percentage Percentage General Government 77,775 59,600 78,331 556 0.71%18,731 31.43%Public Safety 203,578 195,800 221,564 17,986 8.8%25,764 13.2%Development Services577,973 546,900 478,700 (99,273) -17.2%(68,200) -12.5%Culture & Recreation 814,032 830,200 750,340 (63,692) -7.8%(79,860) -9.6%YTD Total 1,673,358 1,632,500 1,528,935 (144,423) -8.6%(103,565) -6.3%Annual Total1,861,204 1,785,100 Year to Date through November Year to Date through November Year to Date through November Year to Date through November Charges for Services by Type Charges for Services by Type Charges for Services by Type Charges for Services by Type 2011 vs. 2010 2011 vs. 2010 2011 vs. 2010 2011 vs. 20102011 vs. Budget 2011 vs. Budget 2011 vs. Budget 2011 vs. Budget Development services include engineering fees, zoning & subdivision fees and plan check fees. At the end of November, revenues totaled $478.4K and are 17.2% less than the same period in 2010. Total development service revenue is less than the budget for the year by $68.2K or 12.5% primarily due to lower than anticipated engineering and zoning & subdivision fees. $0 $100 $200 $300 $400 $500 $600 $700 $800 JanFebMarAprMayJunJulAugSepOctNovDec Thousands Thousands Thousands Thousands Development Service Fees Development Service Fees Development Service Fees Development Service Fees 2011 budget 2011 actual to date 2010 actual 10
Monthly Financial Report Monthly Financial Report Monthly Financial Report Monthly Financial Report November 2011 November 2011 November 2011 November 2011 Culture & Recreation revenues totaled $750.3K and consist of theater ticket sales, recreational cl asses, arts commission and senior citizen program fees. Collections are running below budget and previous year’s performance due to lower revenue from adult health & fitness classes and afterschool programs. $0 $100 $200 $300 $400 $500 $600 $700 $800 $900 $1,000 JanFebMarAprMayJunJulAugSepOctNovDec Thousands Thousands Thousands Thousands Culture & Recreation Culture & Recreation Culture & Recreation Culture & Recreation 2011 budget 2011 actual to date 2010 actual Fines & Penalties Fines & Penalties Fines & Penalties Fines & Penalties This revenue category includes traffic and parking infraction penalties, criminal (traffic, non traffic and costs) and false alarm fines. Revenue from the City’s photo enforcement program makes up nearly half of total revenues from this category. Year-to-date collections totaled $1.8M or 9.6% lower than the projected budget, due primarily to lower photo enforcement revenues. $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 $3.0 JanFebMarAprMayJunJulAugSepOctNovDec Millions Millions Millions Millions Fines & Penalties Fines & Penalties Fines & Penalties Fines & Penalties 2011 budget 2011 actual to date 2010 actual 11
Monthly Financial Report Monthly Financial Report Monthly Financial Report Monthly Financial Report November 2011 November 2011 November 2011 November 2011 2010 20102010 20102011 20112011 20112011 20112011 2011 Month MonthMonth Month Actual ActualActual ActualBudget BudgetBudget BudgetActual ActualActual ActualAmount AmountAmount Amount Percentage Percentage Percentage Percentage Amount AmountAmount AmountPercentage Percentage Percentage Percentage Civil Penalties 20,969 13,700 17,388 (3,582) -17.1%3,688 26.9%Civil Infraction Penalties 666,802 504,900 610,696 (56,105) -8.4%105,796 21.0%Red Light Photo Enforcement1,106,187 1,084,400 775,954 (330,233) -29.9%(308,446) -28.4%Parking Infractions 174,149 153,500 162,276 (11,873) -6.8%8,776 5.7%Criminal Traffic Misdemeanor80,850 98,200 77,516 (3,334) -4.1%(20,684) -21.1%Criminal Non-Traffic Fines 99,124 82,900 83,688 (15,436) -15.6%788 1.0%Criminal Costs 8,590 9,900 14,234 5,644 65.7%4,334 43.8%Non-Court Fines & Penalties117,553 58,300 72,238 (45,315) -38.5%13,938 23.9%YTD Total 2,274,223 2,005,800 1,813,989 (460,234) -20.2%(191,811) -9.6%Annual Total 2,472,411 2,208,500 Year to Date through November Year to Date through November Year to Date through November Year to Date through November Fines & Forfeits by Type Fines & Forfeits by Type Fines & Forfeits by Type Fines & Forfeits by Type 2011 vs. 2010 2011 vs. 2010 2011 vs. 2010 2011 vs. 20102011 vs. Budget 2011 vs. Budget 2011 vs. Budget 2011 vs. Budget $0.0 $0.2 $0.4 $0.6 $0.8 $1.0 $1.2 $1.4 JanFebMarAprMayJunJulAugSepOctNovDec Millions Millions Millions Millions Photo Enforcement Photo Enforcement Photo Enforcement Photo Enforcement 2011 budget 2011 actual to date 2010 actual Miscellaneous Miscellaneous Miscellaneous Miscellaneous This revenue source is comprised of interest and other investment earnings, rents, leases & concessions, contributions & donations and other miscellaneous income. The 2011 budget for this revenue category is $491,880 and interest & investment and rentals & leases make up 86% of the annual budget. Decreased interest earnings reflect the impact of timing of investment activity and the low interest rates; the Local Government Investment Pool interest has decreased from 0.28% in January 2010 to 0.15% in November 2011. 12
Monthly Financial Report Monthly Financial Report Monthly Financial Report Monthly Financial Report November 2011 November 2011 November 2011 November 2011 Re venue from rentals & leases increased over 2011 year-to-date budgeted levels, reflecting greater park facility rentals. Other miscellaneous revenue is budgeted conservatively. Other miscellaneous revenues in 2010 reflect a one-time $95.7K reimbursement from the Crisis Clinic that was received in March. 2010 20102010 20102011 20112011 20112011 20112011 2011 Month MonthMonth Month Actual ActualActual ActualBudget BudgetBudget BudgetActual ActualActual ActualAmount AmountAmount AmountPercentage Percentage Percentage PercentageAmount AmountAmount AmountPercentage Percentage Percentage Percentage Interest & Investments 127,508 101,200 82,069 (45,439) -35.6%(19,131) -18.9%Rents & Leases 565,721 285,300 302,193 (263,528) -46.6%16,893 5.9%Contributions & Donations54,463 16,400 51,483 (2,980) -5.5%35,083 213.9%Other Miscellaneous Revenue109,205 46,480 109,787 582 0.5%63,307 136.2%YTD Total 856,896 449,380 545,531 (311,365) -36.3%96,151 21.4%Annual Total 899,378 491,880 Miscellaneous Revenues by Type Miscellaneous Revenues by Type Miscellaneous Revenues by Type Miscellaneous Revenues by Type Year to Date through November Year to Date through November Year to Date through November Year to Date through November 2011 vs. 2010 2011 vs. 2010 2011 vs. 2010 2011 vs. 20102011 vs. Budget 2011 vs. Budget 2011 vs. Budget 2011 vs. Budget Real Estate Excise Tax Real Estate Excise Tax Real Estate Excise Tax Real Estate Excise Tax The Real Estate Excise Tax (REET) revenue is received into the Capital Improvement Projects Fund and is used for governmental capital projects. Total revenue at the end of November is $1.3M or 20.1% more than 2010 and $161 K or 13.8.2% more than budget. The increase in year to date revenue is primarily due to a large commercial property transaction in March and increases in multi-family and commercial transactions from July through September. $0.0 $0.2 $0.4 $0.6 $0.8 $1.0 $1.2 $1.4 JanFebMarAprMayJunJulAugSepOctNovDec Millions Millions Millions Millions Real Estate Excise Tax Real Estate Excise Tax Real Estate Excise Tax Real Estate Excise Tax 2011 budget 2011 actual to date 2010 actual 13
Monthly Financial Report Monthly Financial Report Monthly Financial Report Monthly Financial Report November 2011 November 2011 November 2011 November 2011 Enterprise Funds En terprise Funds Enterprise Funds Enterprise Funds The following table provides an analysis of all City Enterprise funds and shows the year-to-date revenues and expenditures for each enterprise fund. WaterSewer StormSolid WasteAirportCemeteryGolf OPERATING REVENUES Charges for services 8,248,662 15,116,924 6,344,312 8,682,721 23,853 708,117 1,085,292 Rents, Leases, Concessions & Other - - - - 559,312 1,338 260,343 TOTAL OPERATING REVENUES 8,248,662 15,116,924 6,344,312 8,682,721 583,166 709,455 1,345,635 OPERATING EXPENSES:Administration 2,131,965 1,728,050 2,493,305 693,229 484,413 258,526 215,843 Operations & Maintenance 3,733,792 14,175,569 2,332,169 7,647,956 9,054 619,246 1,042,256 Depreciation & Amortization 1,908,025 1,472,106 1,173,341 17,251 361,491 53,191 295,276 TOTAL OPERATING EXPENSES 7,773,783 17,375,725 5,998,815 8,358,436 854,958 930,963 1,553,375 OPERATING INCOME (LOSS)474,879 (2,258,801) 345,497 324,285 (271,792) (221,508) (207,739) NON-OPERATING REVENUES & EXPENSES Interest Revenue 51,089 39,025 26,202 560 1,996 102 765 Other Non Operating Revenue 827,687 839,103 63,464 44,841 93,135 30 - Other Non Operating Expense (32,037) (21,983) - - (54,475) (22,267) (190,802) TOTAL NON-OPERATING REVENUES (EXPENSES)846,739 856,145 89,666 45,402 40,656 (22,135) (190,037) 1,321,618 (1,402,656) 435,162 369,686 (231,136) (243,643) (397,776) Contributions 261,816 215,293 447,999 - - - - Transfers In 31,300 447,453 Transfers Out (50,000) (50,000) (96,800) - - - - TOTAL CONTRIBUTIONS & TRANSFERS 211,816 165,293 351,199 - - 31,300 447,453 CHANGE IN FUND BALANCE 1,533,434 (1,237,363) 786,361 369,686 (231,136) (212,343) 49,678 BEGINNING FUND BALANCE, January 1, 201159,674,990 67,629,064 40,956,334 923,810 9,705,318 865,780 5,210,529 ENDING FUND BALANCE, November 30, 201161,208,424 66,391,701 41,742,695 1,293,496 9,474,182 653,437 5,260,207 INCOME (LOSS) BEFORE CONTRIBUTIONS & TRANSFERS 14
Monthly Financial Report Monthly Financial Report Monthly Financial Report Monthly Financial Report November 2011 November 2011 November 2011 November 2011 The following table presents the Enterprise funds working capital statements. Working capital is ge nerally defined as the difference between current assets and current liabilities. WaterSewer StormSolid WasteAirportCemeteryGolf OPERATING REVENUES Charges for services 8,248,662 15,116,924 6,344,312 8,682,721 23,853 708,117 1,085,292 Rents, Leases, Concessions & Other - - - - 559,312 1,338 260,343 TOTAL OPERATING REVENUES 8,248,662 15,116,924 6,344,312 8,682,721 583,166 709,455 1,345,635 OPERATING EXPENSES:Salaries & Wages 1,854,637 1,268,208 1,646,439 377,917 17,424 428,319 509,337 Benefits 755,107 518,949 681,921 154,011 4,649 187,638 227,368 Supplies 206,680 60,339 46,392 40,927 - 150,517 211,766 Other Service Charges 2,116,924 1,601,626 1,190,108 7,385,632 471,393 47,762 147,741 Intergovernmental Services - 11,762,815 69,429 211,285 - - - Interfund Operating Rentals/Supplies 932,410 691,683 1,191,184 171,413 - 63,536 161,887 Depreciation & Amortization 1,908,025 1,472,106 1,173,341 17,251 361,491 53,191 295,276 TOTAL OPERATING EXPENSES 7,773,783 17,375,725 5,998,815 8,358,436 854,958 930,963 1,553,375 OPERATING INCOME (LOSS)474,879 (2,258,801) 345,497 324,285 (271,792) (221,508) (207,739) NON-OPERATING REVENUES & EXPENSES Interest Revenue 51,089 39,025 26,202 560 1,996 102 765 Other Non Operating Revenue 827,687 839,103 63,464 40,423 892 30 - Other Non Operating Expense (32,037) (21,983) - 4,418 (54,475) (22,267) (190,802) TOTAL NON-OPERATING REVENUES (EXPENSES)846,739 856,145 89,666 45,402 (51,587) (22,135) (190,037) Plus Items Not Effecting Working Capital Depreciation 1,908,025 1,472,106 1,173,341 17,251 361,491 53,191 295,276 3,229,643 69,451 1,608,503 386,937 38,112 (190,452) (102,500) Increase in Contributions -System Development261,816 203,337 438,355 - - - - Increase in Contributions -Area Assessments - 11,956 9,644 - - - - Increase in Contributions -FAA Grants - - - - 92,243 - Operating Transfers In - - - - - 31,300 447,453 Increase in Restricted Net Assets 13,041 29,925 - - (4,831) - Decrease in Long term Receivables - 45,000 - - - - - Increase in Deferred Credits - - - - 21,617 - - TOTAL RESOURCES OTHER THAN OPERATIONS274,857 290,218 447,999 - 109,029 31,300 447,453 Net Change in Restricted Net Assets 905,480 273,360 326,850 - (103,267) - (70,932) Increase in Fixed Assets - Salaries 168,492 97,542 88,135 - - - - Increase in Fixed Assets - Benefits 62,163 36,826 34,952 - - - - Increase in Fixed Assets - Site Improvements 139,113 - - - 22,012 - - Increase in Fixed Assets - Equipment 24,980 30,367 - - - 9,487 - Increase in Fixed Assets - Construction 5,267,797 2,345,200 2,440,963 - 328,452 54,916 - Operating Transfers Out 50,000 50,000 96,800 - - - - Debt Service Principal 435,568 288,262 - - 100,000 - 264,375 TOTAL USES OTHER THAN OPERATIONS 7,053,594 3,121,557 2,987,701 - 347,197 64,403 193,443 NET CHANGE IN WORKING CAPITAL (3,549,093) (2,761,889) (931,199) 386,937 (200,056) (223,555) 151,510 BEGINNING WORING CAPITAL, January 1, 201121,606,067 16,021,979 9,795,538 775,690 969,009 124,129 3,752 ENDING WORKING CAPITAL, November 30, 201118,056,974 13,260,090 8,864,339 1,162,628 768,954 (99,426) 155,262 NET CHANGE IN WORKING CAPITAL (3,549,093) (2,761,889) (931,199) 386,937 (200,056) (223,555) 151,510 NET WORKING CAPITAL FROM OPERATIONS 15
Monthly Financial Report Monthly Financial Report Monthly Financial Report Monthly Financial Report November 2011 November 2011 November 2011 November 2011 The Water Utility ended November with a slight operating gain due primarily to a decrease in pr ofessional service expenses and a one-time back bill adjustment. The growth in sales for the month of October is due to increased summer water usage as a result of drier weather conditions compared to October of 2010. As revenue from summer water usage tapers off with the winter months, the Water Utility is expected to end 2011 at nearly break even or with a slight operating loss, despite a 7% rate increase that became effective January 1, 2011. Finance is in the process of reviewing rate revenue requirements and will present the results of this analysis to the Council in early 2012. -200,000 400,000 600,000 800,000 1,000,000 1,200,000 JanFebMarAprMayJunJulAugSepOctNovDec Water Revenues ($) vs Water Sold (ccf)Water Revenues ($) vs Water Sold (ccf)Water Revenues ($) vs Water Sold (ccf)Water Revenues ($) vs Water Sold (ccf)2010 2010 2010 2010 ----Present PresentPresent Present 2010 Water Sales ($)2011 Water Sales ($)2010 Water Sold (ccf)2011 Water Sold (ccf) The cumulative decline in water usage during 2011 is also affecting the Sewer fund. The Sewer fu nd operating loss at the end of November is due to a combination of lower revenues associated with decreased water consumption and increased expenses related to the Metro sewer treatment services. Year-to-date Metro billings for 2011 totaled $11.8M and compares to $10M for the same period 2010. Billings for sewer treatment services are based on the average number of residential customer equivalents for the previous 12 months and include adjustments for Boeing and GSA during 2010. Billings for sewer treatment services are not expected to normalize until the 4 th quarter 2011 when the effects of the timing of these adjustments are worked through th e rolling 12 month Metro billing cycle. Solid Waste operating expenses are low due to timing of invoices form Waste Management. November billing of $652,196 was posted in December. Golf Course operating revenues at the end of November totaled $1.35M and is almost equal for the same period in 2010. This revenue is low compared to year-to-date budget of $1.6 million, due to a decline in the level of golfing activity during the first half of the year. Total number of rounds played at the end of November is currently running about 3.8% below 2010 levels (44,462 compared to 46,220 for the same period in 2010). Despite the improvement in activity 16
Monthly Financial Report Monthly Financial Report Monthly Financial Report Monthly Financial Report November 2011 November 2011 November 2011 November 2011 during the summer, Golf Course operating losses are expected to continue for the remainder of 201 1. $0 $50 $100 $150 $200 $250 $300 $350 JanFebMarAprMayJunJulAugSepOctNovDec Thousands Thousands Thousands Thousands Golf Course Operating Revenues by Month Golf Course Operating Revenues by Month Golf Course Operating Revenues by Month Golf Course Operating Revenues by Month (2011 vs 2010)(2011 vs 2010)(2011 vs 2010)(2011 vs 2010)2011 Monthly Budget 2011 Actual 2010 Actual Ce metery operating revenues totaled $709.5K at the end of November and compares to $647.5K for the same period last year. While 2011 collections are up over last year, the Cemetery ended November with a year-to-date operating loss. To address the current year cash flow needs of this fund, the Council approved a transfer of $200,000 from the Cumulative Reserve fund (Ordinance #6378) to the Cemetery fund. $0 $20 $40 $60 $80 $100 $120 JanFebMarAprMayJunJulAugSepOctNovDec Thousands Thousands Thousands Thousands Cemetery Operating Revenues by Month Cemetery Operating Revenues by Month Cemetery Operating Revenues by Month Cemetery Operating Revenues by Month (2011 vs 2010)(2 011 vs 2010)(2011 vs 2010)(2011 vs 2010)2011 Monthly Budget 2011 Actual 2010 Actual 17
Monthly Financial Report Monthly Financial Report Monthly Financial Report Monthly Financial Report November 2011 November 2011 November 2011 November 2011 Internal Service Funds Int ernal Service Funds Internal Service Funds 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. InformationEquipment InsuranceFacilities ServicesRental OPERATING REVENUES:Interfund Charges for services - 3,463,163 3,812,809 585,488 Rents, Leases, Concessions & Other - 94,557 43,824 2,028,477 TOTAL OPERATING REVENUES - 3,557,720 3,856,633 2,613,965 OPERATING EXPENSES:Administration 273,629 - 226,050 641,375 Operations & Maintenance - 1,968,007 3,116,637 1,199,169 Depreciation & Amortization - - 428,897 749,357 TOTAL OPERATING EXPENSES 273,629 1,968,007 3,771,584 2,589,901 OPERATING INCOME (LOSS)(273,629) 1,589,713 85,049 24,064 NON-OPERATING REVENUES & EXPENSES Interest Revenue 2,965 2,437 7,027 8,608 Other Non Operating Revenue - 46,439 51,234 33,587 Other Non Operating Expense - - - TOTAL NON-OPERATING REVENUES (EXPENSES)2,965 48,876 58,261 42,195 INCOME (LOSS) BEFORE CONTRIBUTIONS & TRANSFERS(270,664) 1,638,589 143,310 66,259 Contributions - - 10,538 Transfers In Transfers Out - (590,975) (500,000) (507,000) TOTAL CONTRIBUTIONS & TRANSFERS - (590,975) (500,000) (496,462) CHANGE IN FUND BALANCE (270,664) 1,047,614 (356,690) (430,203) BEGINNING FUND BALANCE, January 1, 2011 2,366,832 661,686 4,918,922 10,611,968 ENDING FUND BALANCE, November 30, 2011 2,096,168 1,709,300 4,562,232 10,181,765 18
Monthly Financial Report Monthly Financial Report Monthly Financial Report Monthly Financial Report November 2011 November 2011 November 2011 November 2011 The working capital statements for the Internal Service funds are presented on the table below. InformationEquipment InsuranceFacilities ServicesRental OPERATING REVENUES:Interfund Charges for services - 3,463,163 3,812,809 585,488 Rents, Leases, Concessions & Other - 94,557 43,824 2,028,477 TOTAL OPERATING REVENUES - 3,557,720 3,856,633 2,613,965 OPERATING EXPENSES:Salaries & Wages - 598,155 1,155,675 345,447 Benefits 181,397 242,129 404,533 127,619 Supplies - 73,089 168,470 787,499 Other Service Charges 92,233 971,770 1,320,859 365,595 Interfund Operating Rentals/Supplies - 82,863 293,150 214,384 Depreciation & Amortization - - 428,897 749,357 TOTAL OPERATING EXPENSES 273,629 1,968,007 3,771,584 2,589,901 OPERATING INCOME (LOSS)(273,629) 1,589,713 85,049 24,064 NON-OPERATING REVENUES & EXPENSES Interest Revenue 2,965 2,437 7,027 8,608 Other Non Operating Revenue - 22,023 526 33,587 Other Non Operating Expense - - - - TOTAL NON-OPERATING REVENUES (EXPENSES)2,965 24,460 7,553 42,195 Plus Items Not Effecting Working Capital Depreciation - - 428,897 749,357 (270,664) 1,614,173 521,500 815,616 Increase in Contributions -Other Government - 24,417 50,708 - Transfers In - - - TOTAL RESOURCES OTHER THAN OPERATIONS - 24,417 50,708 - Net Change in Restricted Net Assets - 1,800 - (25,630) Increase in Fixed Assets - Equipment - - 325,385 121,641 Increase in Fixed Assets - Construction - - 85,894 5,072 Operating Transfers Out - 590,975 500,000 507,000 TOTAL USES OTHER THAN OPERATIONS - 592,775 911,280 608,083 NET CHANGE IN WORKING CAPITAL (270,664) 1,045,814 (339,072) 207,533 BEGINNING WORING CAPITAL, January 1, 2011 2,366,832 714,944 3,949,793 5,826,195 ENDING WORKING CAPITAL, November 30, 2011 2,096,168 1,760,758 3,610,721 6,033,729 NET CHANGE IN WORKING CAPITAL (270,664) 1,045,814 (339,072) 207,533 NET WORKING CAPITAL FROM OPERATIONS The Insurance Fund expenses include an $88.6K balance of the annual insurance payment. This amount will be decreasing throughout the year as the expense is being allocated to various departments and funds on a monthly journal entry. The Facilities Fund revenues of $3.6M cover expenses totaling $2.6M (including $590,975 in debt service related to the annex building). Expenses are low compared to budget due to 19
Monthly Financial Report Monthly Financial Report Monthly Financial Report Monthly Financial Report November 2011 November 2011 November 2011 November 2011 professional services, utilities and repairs and maintenance that are anticipated to be spent later in th e year. Equipment rental fund balance of $10.2M includes $4.2M in fixed assets net of depreciation which primarily consists of the City’s fleet vehicles. Contact Information Contact Information Contact Information 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
SALES TAX SUMMARY NOV 2011 SALES TAX DISTRIBUTIONS (FOR SEP 2011 RETAIL ACTIVITY )10 Total10 YTD11 YTD Y TD 10 Total10 YTD 11 YTD Y TD NAICS CONSTRUCTION (NOV-OCT)(NOV-SEP)(NOV-SEP)% Dif f NAICS A UTOMOTIV E (NOV-OCT)(NOV-SEP)(NOV-SEP)% Dif f 236Construction of Buildings 607,355 559,453 549,108 -1.8%441Motor Vehicle and Parts Dealer 2,346,944 2,146,441 2,343,781 9.2%237Heavy and Civil Construction 121,822 116,474 91,692 -21.3%447Gasoline Stations 210,961 192,342 206,685 7.5%238Specialty Trade Contractors 594,645 531,006 543,556 2.4%TOTAL AUTOMOTIV E 2,557,905 $ 2,338,783 $ 2,550,466 $ 9.1%TOTAL CONSTRUCTION 1,323,822 $ 1,206,933 $ 1,184,356 $ -1.9%Overall Change from Previous Year 211,683 $ Overall Change from Previous Year (22,577)$ 10 Total10 YTD 11 YTD Y TD 10 Total10 YTD11 YTD Y TDNAICS RETAIL TRAD E (NOV-OCT)(NOV-SEP)(NOV-SEP)% Dif f NAICS MANUFACTURIN G (NOV-OCT)(NOV-SEP)(NOV-SEP)% Dif f 442Furniture and Home Furnishings 193,852 179,359 202,540 12.9%311Food Manufacturing 2,062 1,990 2,454 23.3%443Electronics and Appliances 120,703 110,211 117,956 7.0%312Beverage and Tobacco Products 3,610 3,269 3,635 11.2%444Building Material and Garden 389,137 358,636 353,566 -1.4%313Textile Mills 121 114 951 731.2%445Food and Beverage Stores 351,329 322,937 304,417 -5.7%314 TextileProductMills 1,682 1,591 2,319 45.8%446 HealthandPersonalCareStore 143,820 131,655 137,105 4.1%314 Textile Product Mills 1 ,682 1 ,591 2 ,319 45 .8%446 Health and Personal Care Store 143 ,820 131 ,655 137 ,105 4 .1%315Apparel Manufacturing 2,202 2,140 2,498 16.8%448Clothing and Accessories 730,903 674,267 696,014 3.2%316Leather and Allied Products 45 42 167 293.6%451Sporting Goods, Hobby, Books 116,615 109,621 118,312 7.9%321Wood Product Manufacturing 30,078 28,682 21,918 -23.6%452General Merchandise Stores 801,501 737,017 894,056 21.3%322Paper Manufacturing 10,842 9,946 10,540 6.0%453Miscellaneous Store Retailers 504,303 466,703 428,152 -8.3%323Printing and Related Support 43,243 40,064 35,969 -10.2%454Nonstore Retailers 234,807 215,413 218,255 1.3%324Petroleum and Coal Products 3,320 3,090 8,842 186.1%TOTAL RETAIL TRAD E 3,586,970 $ 3,305,820 $ 3,470,372 $ 5.0%325Chemical Manufacturing 8,684 7,691 7,332 -4.7%Overall Change from Previous Year 164,552 $ 326Plastics and Rubber Products 9,254 8,171 8,779 7.4%327Nonmetallic Mineral Products 19,031 16,778 14,964 -10.8%331Primary Metal Manufacturing 189 189 282 49.3%10 Total10 YTD 11 YTD Y TD 332Fabricated Metal Product Manuf 17,110 15,696 18,255 16.3%NAICS SERVICES (NOV-OCT)(NOV-SEP)(NOV-SEP)% Dif f 333Machinery Manufacturing 13,445 12,245 12,725 3.9%51*Information (see footnote)978,115 946,029 361,148 -61.8%334Computer and Electronic Produc 12,773 10,467 15,802 51.0%52*Finance and Insurance 68,357 60,685 60,120 -0.9%335Electric Equipment, Appliances 192 174 773 343.5%53*Real Estate, Rental, Leasing 288,013 264,036 277,691 5.2%336Transportation Equipment Man 186,247 186,555 329,518 76.6%541Professional, Scientific, Tech 188,696 174,495 163,239 -6.5%337Furniture and Related Products 12,784 11,326 12,106 6.9%551Company Management 165 149 108 -27.1%339Miscellaneous Manufacturing 27,899 26,118 23,548 -9.8%56*Admin. Supp., Remed Svcs 234,384 215,846 276,788 28.2%TOTAL MANUFACTURIN G 404,813 $ 386,340 $ 533,379 $ 38.1%611Educational Services 55,877 52,200 50,187 -3.9%,,,,,,Overall Change from Previous Year 147,039 $ 62*Health Care Social Assistannce 37,475 35,157 37,378 6.3%71*Arts and Entertainment 153,918 148,825 143,590 -3.5%72*Accomodation and Food Svcs 806,733 738,112 767,921 4.0%10 Total10 YTD11 YTD Y TD 81*Other Services385,105 355,957 357,132 0.3%NAICSTRANSPORTATION AND WAREHOUSIN G (NOV-OCT)(NOV-SEP)(NOV-SEP)% Dif f 92*Public Administration 109,678 103,434 85,661 -17.2%481Air Transportation - - 24 N/A TOTAL SERVICE S 3,306,516 $ 3,094,924 $ 2,580,962 $ -16.6%482Rail Transportation 4,500 4,342 13,937 221.0%Overall Change from Previous Year (513,962)$ 484Truck Transportation 7,660 6,870 35,585 418.0%485Transit and Ground Passengers 57 57 68 20.4%488Transportation Support 13,207 12,029 16,721 39.0%10 Total10 YTD 11 YTD Y TD 491Postal Service 194 181 184 2.0%NAICS MISCELLANEOUS (NOV-OCT)(NOV-SEP)(NOV-SEP)% Dif f 492Couriers and Messengers 993 953 1,457 52.8%000Unknown 754 754 1,958 159.6%493Warehousing and Storage 2,574 2,464 2,893 17.4%111-115Agriculture, Forestry, Fishing 2,839 2,304 7,249 214.6%TOTAL TRANSPORTATIO N 29,185 $ 26,896 $ 70,870 $ 163.5%211-221Mining & Utilities 22,364 20,360 20,523 0.8%Overall Change from Previous Year 43,974 $ 999Unclassifiable Establishments 102,180 92,773 182,380 96.6%TOTAL SERVICE S 128,138 $ 116,192 $ 212,110 $ 82.6%Overall Change from Previous Year 95,919 $ 10 Total10 YTD11 YTD Y TD NAICS WHOLESALETRADE (NOVOCT)(NOVSEP)(NOVSEP)%Diff NAICS WHOLESALE TRAD E (NOV-OCT)(NOV-SEP)(NOV-SEP)% Dif f 423Wholesale Trade, Durable Goods 1,020,802 927,470 998,555 7.7%GRAND TOTA L 12,522,789 $ 11,553,464 $ 11,752,242 $ 424Wholesale Trade, Nondurable 160,317 145,958 139,320 -4.5%Overall Change from Previous Year 198,778 $ 1.7%425Wholesale Electronic Markets 4,320 4,148 11,852 185.7%TOTAL WHOLESAL E 1,185,440 $ 1,077,576 $ 1,149,727 $ 6.7%Overall Change from Previous Year 72,151 $ 11/23/2011 file:Monthly Sales Tax Report.xls Prepared by Auburn Financial Planning Footnote: NAICS 51* 2010 data NOT adjusted for Comcast audit adjustment of $339,470, as received for Feb 2010.21
Investment PurchasePurchaseMaturityYield to Type Date Price DateMaturity State Investment PoolVarious 84,070,792 $ Various 0.15%KeyBank Money MarketVarious 9,800,754Various 0.13%US Treasury 05/04/1990 57,75005/15/20165.72%FHLB 3/28/20112,000,0003/28/20141.300%FHLB 6/13/20112,000,0006/13/20141.150%FFCB 6/6/20112,000,0006/6/20141.180% Total Cash & Investments 99,929,296 $ 0.190%Investment Mix% of Total State Investment Pool 84.1%Current 6-month treasury rate0.05%KeyBank Money Market 9.8%Current State Pool rate0.15%US Treasury 0.1%KeyBank Money Market0.13%FHLB 4.0%Blended Auburn rate0.19%FFCB 2.0%100.0%City of Auburn Investment Portfolio Summary November 30, 2011 Summary 22