The URL can be used to link to this page

Home My WebLink About2012-04-23 Board of Selectmen Agenda Packet TOWN OF NORTH ANDOVER BOARD OF SELECTMEN 120 MAIN STREET NORTH ANDOVER,MASSACHUSETTS 01845 Tracy M. Watson, Chairman William F. Gordon Rosemary Connelly Smedile TEL.(978)688-9510 Donald B. Stewart FAX(978)688-9556 Richard M.Vaillancourt BOARD OF SELECTMEN& LICENSING COMMISSIONERS AGENDA APRIL 23,2012—7:00 PM TOWN HALL MEETING ROOM 120 MAIN STREET I. CALL TO ORDER II. EXECUTIVE SESSION A. To discuss matters involving the possible acquisition of land III. RECONVENE AND PLEDGE OF ALLEGIANCE IV. APPROVAL OF MINUTES A. Open Session Minutes as written April 2,2012 V. COMMUNICATIONS AND ANNOUNCEMENTS A. Audit Committee Report B. Facilities Master Plan Committee Report i VI. CONSENT ITEMS A. Request to Conduct Memorial Parade&Ceremony on May 28,2012 B, Request from the Museum of Printing to close a portion of Mass. Avenue on June 17, 10:00 a.m.to 4:00 p.m. C. Stevens Pond 2012 Fees D. Appoint Lyne Savage as Town Accountant for a term of 5 years, commencing on July 1,2012 E. Vote to borrow notes and bonds for School Repair Green Project F. Bond Counsel Vote for assets being borrowed with useful Lives in excess of 5 years G. Acceptance of Donations to Library H. Vote to reopen the Annual Town Meeting Warrant I. Vote to close the Annual Town Meeting Warrant VII. LICENSING COMMISSIONERS A. Request for One-Day Wine&Malt License from Camelot, 505 Sutton Street on May 6,2012, 10:00 a.m.to 7:00 p.m, B. Request for One Day Wine&Malt License from Merrimack College, 315 Turnpike Street on April 26,2012, 5:00 p.m.to 9:00 p.m. VIII. PUBLIC COMMENT IX. TOWN MANAGER'S REPORT A. Arbor Day Tree Planting B. FYI Budget Update C. Appointments a. Fire Fighter—Christopher Long b. Fire Fighter—Andres Mencia I X. ADJOURNMENT I �I BOARD OF SELECTMEN MINUTES APRIL 2, 2012 CALL TO ORDER: Chairman Tracy Watson called the meeting to order at 7:05 PM at Town Hall Meeting Room. ATTENDANCE: The following were present: Tracy Watson, Chairman; William F. Gordon, Clerk; Rosemary Smedile, Licensing Chairman; Donald Stewart, Richard Vaillancourt, Ray Santilli, Assistant Town Manager; and Andrew Maylor, Town Manager. PLEDGE OF ALLEGIANCE APPROVAL OF MINUTES: William Gordon made a MOTION, seconded by Rosemary Smedile, to approve the Open Session Minutes of March 12, 2012, as written. Vote approved 4-0-1. COMMUNICATIONS ANNOUNCEMENTS, AND PUBLIC COMMENT: ; The Board welcomed the new elected selectman Richard Vaillancourt and re-elected selectman William Gordon. Town Common Tree Planting Program A group of Town Employees, members of the Historical District Commission and two residents met and are recommending the following improvements to the Old Center Common which includes plantings, benches and trash receptacles. The first phase will be tree planting and this will go out to bid in April, the contract will be awarded in May with work starting in June 2012. Donald Stewart made a MOTION, seconded by Rosemary Smedile, to accept the recommendations for phase 1 tree plantings at the Old Center Common. Vote approved 5-0. Energy Performance Contracting Last May, the Board of Selectmen and the School Committee gave approval for Ameresco, Inc. to perform an investment grade audit of all municipal and school buildings. Ameresco presented their initial recommendations of various projects to undertake. The cost of the projects would be offset by the anticipated energy savings over a prescribed number of years. Ameresco will provide both the design and build services portion of the projects. The Board and the Town Manager discussed the projects savings and how this audit would be financed. CONSENT ITEMS: Approval of the Motion to Intervene Attorney Bill August who represents the town in matters involving cable licenses with Comcast and Verizon is recommending that the Board of Selectmen authorize him to file a Motion to Intervene with the State DTC in a matter where we believe the Town was overcharged for certain costs by Comcast Cable. William Gordon made a MOTION, seconded by Richard Vaillancourt, acting as the License Issuing Authority, to authorize Assistant Town.Counsel William August.to file a Motion to intervene with the DTC on behalf of the Town in a matter involving Comcast Cable. Vote approved 5-0. Acceptance of Wheelabrator Grants As part of a settlement with the Commonwealth of MA over alleged environmental law violations, Wheelabrator is obligated to provide Supplemental Environmental Projects grants to communities that host waste-to-energy facilities to support programs that protect the environment. Three projects were accepted,by Wheelabrator and approved by the Massachusetts Department of Environmental Protection: Surface Water(Cochichewick) Overflow Engineering Study $50,000 Phyto-Pollution Reduction Project (tree planting) $25,000 Trash Truck Monitoring Project $75,000 $150.000 Rosemary Smedile made a MOTION, seconded by Donald Stewart, to accept the three Supplemental Environmental Projects grants approved by the Massachusetts Department of Environmental Protection and Board of Selectmen Minutes April 2, 2012 2 Wheelabrator as outlined in the March 28, 2012 letter from Assistant Town Manager Ray Santilli to Town Manager Andrew Maylor. Vote approved 4-0-1. William Gordon abstained. First Right of Refusal Affordable Housing Resales CHAPA has notified the Town that two affordable units are up'for sale. CHAPA manages the resale of affordable units for Oakridge Village and Kittredge Crossing, The Board of Selectmen has to determine if they want to exercise their right of first refusal. Rosemary Smedile made a MOTION, seconded by William Gordon, hereby votes not to exercise its right of first refusal as it relates to the following affordable housing units that are for sale: 3 Harvest Drive, Unit 105 at Oakridge Village and 109 Chickering Road, Unit 109D at Kittredge Crossing. Vote approved 5-0. Boston MedFlight"Every Second Counts" Cycling Event Diane Malcolmson of Boston MedFlight requests permission to hold the cycling event on July 29, 2012, from 7:00 a.m. —3:00 p.m. on North Andover town roads. William Gordon made a MOTION, seconded by Rosemary Smedile, to approve the"Every Second Counts" road cycling time trial event to be held on July 29, 2012 from 7 am to 3 pm beginning at the Boston MedFlight Hanger at the Lawrence Municipal Airport and traveling on roadways in North Andover. Vote approved 5-0. Selectmen Appointments Donald Stewart made a MOTION, seconded by Rosemary Smedile, to appoint resident Karin Rhoton to the Audit Committee. Vote approved 5-0. William Gordon made a MOTION, seconded by Donald Stewart, to appoint resident Roger Lawson, to the Board of Trustees of the Affordable Housing Trust Fund. Vote approved 5-0. NEW BUSINESS: FY13 Town Manager Recommended Stevens Estate Enterprise Fund Budget The Town Manager Andrew Maylor presented a detailed summary of the Stevens Estate Budget and entertained questions from the Board regarding specifics of the plan. The Board was directed to forward this immediately to the Finance Committee. The Board discussed exploring options for the future of the Estate with restrictions of protecting the watershed. The Town Manager suggested having a workshop with the Board of Selectmen in the future. William Gordon made a MOTION, seconded by Donald Stewart;to accept the Town Manager's FY13 Recommended Stevens Estate Enterprise Fund Budget and forward to the Finance Committee. Vote approved 5-0. Vote to Close Warrant The Town Manager gave the Board of list of possible Articles to be placed on the Town Warrant for the Annual Town Meeting. The deadline for placing articles on the warrant closed on Friday March 30, 2012. The Board was asked to vote to close the Warrant. William Gordon made a MOTION, seconded by Donald Stewart, to close the Warrant for Town Meeting Articles. Vote approved 5-0. TOWN MANAGER'S REPORT: Town Manager Appointments The Town Manager Andrew Maylor and Selectman William Gordon interviewed Ms. Lynne Rudnicki. She is being appointed to the Planning Board. The Town Manager appointed Maureen McAuley on March 28, 2012, to fill a vacant position as a Departmental Assistant within the Public Works Department. Board of Selectmen Minutes April 2, 2012 3 Employee Recognition The Town Manager Andrew Maylor recognized the excellent work of employee Angela Ciofolo. A resident wrote a letter commending Ms. Ciofolo for an outstanding job and her efforts in assisting him with his project. Five Year Forecast The Town Manager prepared a spreadsheet which projects the financial situation over the next five years. It assumes very little growth and both discretionary and non-discretionary expenses increasing at rates greater than inflation. The presumed health insurance increase represents making no changes to the benefit design currently offered and assumes the average increases during the last several years (28% total for FY12 and FY13)will continue. During the next several months health insurance will be front and center in many of our discussions as we hear back from our consultant with the options under the Health Insurance Reform Act. The Town Manager would like to start the annual practice of having a five year financial forecast presentation in October or November. That presentation would be a joint meeting of the selectmen, school committee and finance committee. Municipal Government Change in Hours The Town Manager and Human Resources Director having been working on changing the hours of operation for most of the municipal departments (excluding the Library, Senior Center and Youth Center) to allow for greater access for those who jobs or other circumstances make it difficult to do business with us. Based on the input from selectmen, residents, departments heads and other staff we will begin a pilot program on April 30, 2012 with the following hours of operation: Monday, 8:00—4:30; Tuesday, 8:00-6:00; Wednesday, 8:00 4:30, Thursday, 8:00—4:30, Friday, 8:00— 12:00 Prior to the end of the summer, this will be evaluated on how the new schedule is working prior to making a more permanent decision regarding hours of operation. ADJOURNMENT: Richard Vaillancourt made a MOTION, seconded by Donald Stewart, to adjourn the meeting at 9:00 p.m. Vote approved 5-0. Adele J. Johnson Administrative Secretary William Gordon, Clerk of the Board Johnson, Adele From: Crowell Freeman [crowtuck @aol.com] Sent: Monday, April 23, 2012 11:55 AM To: Johnson, Adele; Watson, Tracy Cc: LarsonML @aol.com Subject: Announcement tonight at BOS Hi Tracy and Adele, I hope it is not too late to add an annoucement to tonights BOS meeting. Thank you for whatever help you can provide. Book sale raises over$5,000/sale which pays for museum passes, summer reading program, DVD purchases, and special events. Kathy stevens Marty Larson The Library Book Sale Week End begins on Friday, May 4, from 4 p.m. to 7 p.m;. On Saturday, May 5 sale is 9 a.m. to 4 p.m.. On Sunday, May 6 hours are noon until 3 with all books and media priced by the bag. Donations may be left at the library at the staff room door at any time the library is open. Volunteers are needed to help with publicity and book sorting. For information or to volunteer, contact: Marty Larson, President of the Friends of the Library, at Larsonmlkaol.com or 978-686-1557 Please note'ftle Massachusetts secretary of State's office ha,-,det£.nine£that most em ails to and from£lunic'ipal offices and officials are public,rEe£a)ids,I"'£3 more e information please refer to,http://www.sec.state.ma.us/pre/preidx.htm, Plp:ase cmisider the r.nvim n'tent before printing ft)is email. i 1 it Executive Summary This Municipal Facilities Master Plan aims to provide North Andover with a comprehensive approach to municipal facilities planning that will improve and consolidate general municipal and school offices while enhancing the town's delivery of services to the public.The plan describes different ways to achieve these ends,taking into consideration past decisions and current conditions regarding the leasing of private space for town offices; the vacating of the old Police Station and former Bradford Street School;the increasing demand for senior services;and the distribution of public works and public safety facilities. This plan did not consider all municipal buildings or all municipal offices in the community, The scope of this plan was in strict accordance with North Andover's request for quota- tion and specifically addressed the buildings noted below.This plan does address what are considered the most vital changes in needs for offices and services and the disposition of vacant municipal buildings. Project Goals Based on feedback from meetings with department heads and the general public as well as a review of previous facilities reports and deliberations with the community's Facilities Master Plan Committee,this plan set the following goals: • Promote municipal efficiency in the delivery of public services; • Move the School Administration and Community Development offices to new loca- tion in municipally-owned properties,thereby eliminating rental costs. • Rehabilitate and reuse existing municipally-owned buildings to the extent possible, particularly for public service delivery; • Remain within Capital Program financial expenditure guidelines; • Utilize Community Preservation Act funds for historic preservation of renovated buildings; • Promote economic activity in Downtown North Andover while consistent with mu- nicipal building reuse goals; • Keep the Senior Center with its associated facility activities in the Downtown. Assessments of Buildings and Department Needs The initial stages of the study entailed a comprehensive review of certain municipal buildings. This included building walk-throughs with a complement of building architects and engineers to assess building conditions using non-invasive techniques.The buildings reviewed were: • Bradstreet School • Former Police Station • Fire Station Headquarters • Public Works Facility In addition,the team's architects reviewed the Senior Center and the School Department's capital improvement program and enrollment projections for the public schools. What were gleaned from these evaluations were certain key observations: • The Bradstreet School is in reasonable condition for renovation and reuse and could provide a significant area of floor space within the Downtown; NORTH ANDOVER Recnmmer ded Facilities.Mastei Flan • The former Police Station has an open floor plan on a good-sized site located near to several schools and is suitable for municipal offices; • Fire Station Headquarters is an historic building in an important location on Main Street,but it requires significant upgrades for continued-or re-use; • The Public Works Facility garage is in reasonable condition, but the attached of- fices spaces and the site are in need of a number of improvements for safety and access; • The Senior Center provides good quality space that could be converted into other municipal spaces; • The Town's public schools are appropriately programmed for spaces, and while improvements and potential expansions may be needed, a new, separate school is not required. In addition,Needs Assessments were completed for certain departments and agencies that were considered likely to require a move or improved space based on existing conditions and information provided to the study team.The assessments included written surveys, in- terviews,and existing space utilization evaluations.These assessments were used to deter- mine how much space was needed for the following entities and their programs: • Elder Services/Senior Center o North Andover Thrift Shop • Community Development Division U Health Planning Building :> Conservation • School Department Offices • Public Works • Fire Department • Emergency Management • Information Technology The Recomrr?ended Scenexio After considering the opportunities and alternatives presently available together with their costs,a recommended scenario was formulated for the realignment of spaces,offices and buildings that best meets the project goals. The recommended scenario is a program of renovation, relocation and new construction extended over a period of years organized as a phased implementation of the plan.It builds off of four alternative scenarios and factors in financial considerations,including the Town's Capital Improvement Plan projections and the amount of non-excluded debt available each year based on Town policies.The recommend- ed scenario strives to address the Town's most critical needs first,such as the need to find a new home for the School Department Offices,which currently leases space at approximately $100,000 per year and the Planning and Community Development Division which only has a few more years of free rent remaining per North Andover's agreement with Ozzie Properties. NORTH ANDOVER Reco �m«uuieo Ptacl!ities Maste, Plan I I Subsequently, Planning and Community Development will be subject to market lease costs The major elements of the recommended scenario are as follows:. Table ESA Recommended Scenario Phase Action Future Use Initial Cost Estimate 1't Renovation of former Police Station School Administration $2,695,000 .. .. 2nd Construction of new Gym at Existing Use $ 900,000 Kittredge School 3d Construction of new Fire Station Fire Department and $6,600,000 Emergency Management 4th Renovation of former Fire Community Development Office $4,377,670 Headquarters 111.11 ......_...... . 5th Expansion of Senior Center Senior Center(and Thrift Shop) $4,321,000 ........_.., 6th Renovation or new school classrooms Existing Use $1,000,000 7th Improvements to Public Works Existing Use $4,595,800 Garage site and Offices ...... .. .......... . Total:Project Cost Estimate $24,489,470 Phase Cost Recovery Future Use Value Terminate lease of space for Lease cost reduction 1st School Department offices at 1600 Commercial office space and Tax base increase Osgood Street Terminate lease of space for Lease cost reduction 4'h Community Development offices at Commercial office space and Tax base increase 1600 Osgood Street While this scenario is recommended, there are other options to consider while making these long-lasting decisions. One option is to renovate Bradstreet School instead of expanding the existing Senior Center for a total cost of$29,179,533. This report provides further detail on the alternatives. NORTH ANDOVER Hecamn-ended Facilities Master Plan III TOWN OF NORTH ANDOVER Fire Department � Fire Prevention Office Central Fire Headquarters 124 MAIN STREET NORTH ANDOVER, MASSACHUSE'I-I'S 01845 Andrew Melnik:as Telephone(978) 688-9593 Fire Chief FAX (978) 688-9594 mnelnikas @townofnOrtl.anclover.cony .Lt Frederick NIcC:arthv PYre 1'rcvcntirin (>ffr`.ccr Ir11IcCrrrlh7(� towraofnorthcrndover.coin Mr. Christopher Long 200 Chickering Rd Apt# 103 B North Andover , Mass 01845 Dear Mr. Long: It is my pleasure to inform you that you have been selected for appointment as a probationary Firefighter for the Town of North Andover. Your employment will begin on Friday, May 4, 2012. You are to report to the Chief s Office at the Main St Fire Station at 0800 hrs. Permanent status as a Firefighter is contingent upon successful completion of a one year probationary period. During that time frame, you will be evaluated by the Fire Lieutenants to ascertain if you meet our standards of conduct and demonstrate a good employment history. Be advised that, during this probationary period, you may be required to submit to certain tests including, but not limited to, laboratory analysis of urine and/ or hair samples for the purpose of determining whether you have unlawfully used any prescription drug, controlled substance, narcotic or hallucinogen. Your signature on the enclosed notice is deemed to be acceptance of this and any other conditions of employment. In order to complete all the appropriate paperwork, please contact Cathy Darby at 978- 688-9526 to arrange for a convenient time to meet. In order to complete all the paperwork, you will need to bring with you a birth certificate along with a driver's license and a social security card or a U.S. passport. If you are married, you will also need to bring a copy of your marriage license and a copy of your spouse's birth certificate. All the proper paperwork must be completed prior to the commencement of your employment. 2 Congratulations on your paperwork:_I am;confident that your service and career in this most important and demanding position will be exemplary. Should you have any questions, please contact me at 978 6889593. Sincerely, Andrew Melnikas, Fire Chief cc Board of Selectmen Andrew Maylor, Town Manager Cathy Darby, Human Resources ti TOWN OF NORTH ANDOVER Fire Departnnent Fire Prevention Office Central Fire headquarters 124 MAIN STREET NORTH ANDOVER, MASSACHt.JSETTS 01845 Andrew Meinikas Telephone(978) 688-9593 Fite Chief FAX (978) 688-9594 cxrrrc l�tikcstr to}�rtnfytcn thcrYtclr�ver.c.ot?t .Lt Frederick tllfcCartlty Tire Prevention Officer ,A leCctrth7,C(.�),tovvnof7orth(.tndo77er.coin Mr. Andres Mencia 256 Turnpike St Unit B North Andover , Mass 01845 Dear Mr. Mencia It is my pleasure to inform you that you have been selected for appointment as a probationary Firefighter for the Town of North Andover. Your employment will begin on Friday, May 4, 2012. You are to report to the Chief s Office tat the Main St Fire Station at 0800 hrs. Permanent status as a Firefighter is contingent upon successful completion of a one year probationary period. During that time frame, you will be evaluated by the Fire Lieutenants to ascertain if you meet our standards of conduct and demonstrate a good employment history. Be advised that, during this probationary period, you may be required to submit to certain tests including, but not limited to, laboratory analysis of urine and/or hair samples for the purpose of determining whether you have unlawfully used any prescription drug, controlled substance, narcotic or hallucinogen. Your signature on the enclosed notice is deemed to be acceptance of this and any other conditions of employment. In order to complete all the appropriate paperwork, please contact Cathy Darby at 978- 688-9526 to arrange for a convenient time to meet. In order to complete all the paperwork, you will need to bring with you a birth certificate along with a driver's license and a social security card or a U.S. passport. If you are married, you will also need to bring a copy of your marriage license and a copy of your spouse's birth certificate. All the proper paperwork must be completed prior to the commencement of your employment. 2 Congratulations on your paperwork. I am confident that your service and career in this most important and demanding position will be exemplary. Should you have any questions, please contact me at 978 6889593, Sincerely, Andrew Melnikas, Fire Chief cc Board of Selectmen Andrew Maylor, Town Manager Cathy Darby, Human Resources 0 TOWN OF NORTH ANDOVER, MASSACHUSETTS MANAGEMENT LETTER JUNE 30, 2011 100 Quannapowitt Parkway Suite 101 Wakefield,MA 01880 T.781-914-1700 F.781-914-1701 To the Honorable Board of Selectmen www.powersandsullivan.com Town of North Andover, Massachusetts: In planning and performing our audit of the financial statements of the governmental activities,the business-type activities, each major fund, and the aggregate remaining fund information of the Town of North Andover, Massachusetts' (the Town) as of and for the year ended June 30, 2011, in accordance with auditing standards generally accepted in the United States of America,we considered the Town's internal control over financial reporting (internal control)as a basis for designing our auditing procedures for the purpose of expressing our opinions on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of the Town's internal control. Accordingly,we do not express an opinion on the effectiveness of the Town's internal control. However, during our audit we became aware of other matters that are opportunities for strengthening internal controls and enhancing operating efficiency. The memorandum that accompanies this letter summarizes our comments and suggestions concerning those matters. We will review the status of these comments during our next audit engagement. We have already discussed these comments and suggestions with various Town personnel, and will be pleased to discuss them in further detail at your convenience, to perform any additional study of these matters, or to assist you in implementing the recommendations. This communication is intended solely for the information and use of management of the Town of North Andover, Massachusetts, and is not intended to be and should not be used by anyone other than these specified parties. The Town of North Andover's written response to the matters identified in our audit has not been subjected to the audit procedures applied in the audit of the financial statements and, accordingly, we express no opinion on it. December 19, 2011 TOWN OF NORTH ANDOVER, MASSACHUSETTS MANAGEMENT LETTER JUNE 30,2011 TABLE OF CONTENTS PAGE PRIORYEAR COMMENTS................................................................................................................................1 Other Postemployment Benefits Actuarial Valuation.......................................................................................2 Government Accounting Standards Board (GASB) Statement#54................................................................2 Fraud Risk Assessment and Monitoring..........................................................................................................2 Consider Online Payments for Real Estate, Excise Tax and Other Revenues...............................................3 PreschoolRevolving Funds.............................................................................................................................3 Treasurer/Collector's Office—Old Outstanding Checks..................................................................................4 PerformanceBonds.........................................................................................................................................4 Treasurer's Financial Policies and Procedures Manual ..................................................................................5 Integration of Accounts Receivable Software..................................................................................................6 Auditof Student Activity Funds........................................................................................................................6 Conduct Periodic Inventory of Fixed Assets....................................................................................................7 CURRENTYEAR COMMENTS..........................................................................................................................8 BankDeposit Slips...........................................................................................................................................9 Timeliness of School Department Turnovers...................................................................................................9 AmbulanceReceivables................................................................................................................................10 TOWN OF NORTH ANDOVER, MASSACHUSETTS MANAGEMENT LETTER JUNE 30,2011 TABLE OF CONTENTS PAGE PRIORYEAR COMMENTS................................................................................................................................1 Other Postemployment Benefits Actuarial Valuation.......................................................................................2 Government Accounting Standards Board (GASB) Statement#54................................................................2 Fraud Risk Assessment and Monitoring..........................................................................................................2 Consider Online Payments for Real Estate, Excise Tax and Other Revenues...............................................3 PreschoolRevolving Funds.............................................................................................................................3 Treasurer/Collector's Office—Old Outstanding Checks..................................................................................4 PerformanceBonds.........................................................................................................................................4 Treasurer's Financial Policies and Procedures Manual ..................................................................................5 Integration of Accounts Receivable Software..................................................................................................6 Auditof Student Activity Funds........................................................................................................................6 Conduct Periodic Inventory of Fixed Assets....................................................................................................7 CURRENTYEAR COMMENTS..........................................................................................................................8 BankDeposit Slips...........................................................................................................................................9 Timeliness of School Department Turnovers...................................................................................................9 AmbulanceReceivables ................................................................................................................................10 I I Other Postemployment Benefits Actuarial Valuation Prior Year Comment The prior year management letter indicated that the Town had met the requirements for implementation of GASB Statement#45,Accounting and Financial Reporting for Postemployment Benefits Other than Pensions, however it also indicated that an updated actuarial valuation, dated July 1, 2010,would be needed for the Town to remain compliant for fiscal years 2011 and 2012. Current Status The Town obtained an updated actuarial valuation, dated July 1, 2010,which allowed the Town to remain compliant with the requirements of GASB Statement#45. Government Accounting Standards Board (GASB)Statement#54 Prior Year Comment In February 2009, the GASB issued Statement#54, Fund Balance Reporting and Government Fund Type Definitions, which is required to be implemented in fiscal year 2011. The objective of this Statement is to enhance the usefulness of fund balance information by providing clearer fund balance classifications that can be more consistently applied and by clarifying the existing governmental fund type definitions. This Statement establishes fund balance classifications that comprise a hierarchy based primarily on the extent to which a government is bound to observe constraints imposed upon the use of the resources reported in governmental funds. Current Status The Town implemented GASB Statement#54 for the fiscal year ending June 30, 2011, the Town's required implementation date. Fraud Risk Assessment and Monitoring Prior Year Comment The prior year management letter recommended that the Town implement an ongoing internal program that provides for examining departmental internal controls, including the reporting of financial activity and the collection of cash at department levels, and for evaluating its risk and exposures to instances of fraud. Current Status Management hired an outside consultant to complete an overall fraud risk assessment. The engagement was completed in fiscal 2011 and a report was provided to the Town that included both findings and recommendations. The Town is currently assessing its risk tolerances in relation to the findings and recommendations. The Town will implement new policies and procedures for any risk areas that are considered to be in excess of the Town's risk tolerances. 2 Consider Online Payments for Real Estate, Excise Tax, and Other Revenues Prior Year Comment The prior year management letter indicated that a recent trend among many municipalities is to offer its citizens the opportunity to make payments of taxes and other charges online via the internet. It is our understanding that the Town is considering to offer such an option. Such systems allow bill payers to electronically access and pay their bills online. Often, payments can be made using an electronic check or a major credit card. Revenues that can be collected using an online system include real estate tax, personal property tax, motor vehicle excise tax, water sewer, parking tickets, school fees, lunch prepayments, park and recreation and building permits. Current Status The Town implemented online bill pay for real estate and personal property taxes as well as water and sewer utility charges in fiscal 2011. The Town anticipates implementing online bill pay for motor vehicle excise taxes in fiscal 2012. Preschool Revolving Funds Prior Year Comment The prior year management letter indicated that it did not appear that expenditures were being properly allocated to the Pre-school program and that it did not appear that the fee structure was designed to recover the cost of the program. It was recommended that policies and procedures be developed that will result in a consistent allocation of both direct and indirect costs on an annual basis. . Additionally, it was recommended that the preschool program's fee structure be designed to recover all program costs (direct and indirect). Current Status The current year costs exceeded the current year revenues by approximately$23,000 and the ending fund balance totaled approximately$42,000. Continuing Recommendation We continue to recommend that the Town adopt policies and procedures that will result in a consistent allocation of both direct and indirect costs on an annual basis. This will ensure that expenditures are consistently charged to the program and will enable the Town to properly set tuition rates to cover anticipated costs. Management's Response The School Committee has been informed of this finding and that not only will all appropriate expenses have to be made to this account, but fees will have to be adjusted to cover all appropriate expenses. A policy to this effect will be approved by the School Committee by December 31, 2011. 3 i Treasurer/Collector's Office—Old Outstanding Checks Prior Year Comment The prior year management letter indicated that the vendor and payroll outstanding checklists included many checks greater than three months old. Typically, checks greater than three months old reflect checks that have been voided, lost, misplaced or stolen. It was recommended that the Treasurer/Collector implement monthly procedures to investigate and resolve outstanding checks greater than three months old. To do so,the stale checks should be reclassified to tailings and removed from the outstanding check lists. For all uncashed checks greater than three years old, the Treasurer/Collector should follow the Massachusetts abandoned property law (MGL Chapter 200A, Section 9A)to bring them back into fund balance as miscellaneous revenue. Current Status The Treasurer has developed policies and procedures to resolve uncashed checks in accordance with MGL Chapter 200A, Section 9A; however, as of June 30, 2011, outstanding checks greater than three months old totaled approximately$21,100, an increase of$12,500 from the prior year. The increase indicates that uncashed checks are not being moved.into tailings on a timely basis. Reclassifying uncashed checks to the tailings account, on a timely basis, is an important internal control because the reissuance of checks becomes subject to -the Town's internal controls over cash disbursements. Continuing Recommendation We continue to recommend that the Treasurer/Collector develop policies and procedures that require outstanding checks greater than three months old to be removed from the outstanding check lists and to be reclassified to the Town's tailings account on a timelier basis. Management's Response We have started the abandoned property procedures for checks that were previously outstanding from Mellon. By the end of fiscal 2012,we anticipate having completed: writing to abandoned property division, sending letters to last known address, advertising on web and sending list of items under$100 to the Accountant to close. By the end of 2013 we anticipate the outstanding check balance on this account to be zero. Performance Bonds Prior Year Comment The prior year management letter identified that the Treasurer/Collector maintains performance bond deposits, totaling approximately$3,700,000 for various Highway Department, Planning Board and Conservation Commission purposes. These deposits are escrow accounts that must be returned to the original owners upon satisfactory completion of each individual project. It was noted that no procedures were in place to reconcile the outstanding balances of the deposits between the records maintained by the Treasurer/Collector and the appropriate departments. The lack of reconciliation procedures increases the likelihood that irregularities and/or errors could occur and not be detected and corrected timely. 4 Current Status The Highway department performance bonds were reconciled to the Treasurer/Collector's balances and the bank balances in fiscal 2010. The majority of the Conservation Commission performance bonds were reconciled to the Treasurer/Collector's balances and the bank balances in fiscal 2010. The remaining accounts were reconciled in fiscal 2011. In fiscal 2011, all but four of the Planning department performance bonds were reconciled between the Treasurer/Collector's balances and the Planning department balances. Continuing Recommendation We continue to recommend that the Treasurer/Collector and the Planning department complete the reconciliation of the Planning department performance bonds. Management's Response The Treasurer has fully and completely reconciled the bonds and escrow accounts with every department. However, there are three reconciling items which I will continue to work on reconciling. The Treasurer's office has continued to reconcile with the bank(every month)as well as the departments(every other month). Treasurer's Financial Policies and Procedures Manual Prior Year Comment The prior year management letter indicated that the preparation of a formal policy and procedures manual would improve and standardize the Town's financial policies and procedures. It was recommended that management develop and implement a formal financial policies and procedures manual. Current Status An accounting policies and procedures manual was completed in fiscal 2010. The Treasurer/Collector has completed an investment policy, and procedures have been documented to reconcile cash and resolve uncashed checks. However, the Treasurer/Collector is still in the process of documenting various Treasury and Collection policies and procedures such as; re-writing performance bond reconciliation procedures, general receipt posting and abatement/refund processing. Continuing Recommendation We continue to recommend that the Treasurer/Collector complete the development of a formal polices and procedures manual for the Treasury and Collection functions and that all policies and procedures be reviewed periodically. 5 Management's Response Our written procedures for general receipt posting, performance bond reconciliation, MLC requests, abatement/refund processing have been completed. A copy was sent to our auditors 10/7111. During fiscal 2012 we're working on adding the following to our procedure manual: parking ticket receipts posting, tax title payment receipt posting, Govern billing import, bond/escrow account set up and redemption. Integration of Accounts Receivable Software Prior Year Comment The prior year management letter indicated that the Town should consider eliminating the use of a stand-alone accounts receivable system and shift toward an integrated system. An integrated system would provide greater efficiencies as well as real-time, up-to-date data for important management decisions. We recommended that the Town perform a review of the current accounting system and consider implementing an integrated system. Current Status An appropriation was approved, at the May,2010 Annual Town Meeting, for the Town to install Unifund's Revenue Sense software,which is designed to integrate with Budget Sense. The Revenue Sense module was not implemented in fiscal 2011. The Treasurer/Collector indicated that the Town is currently exploring other alternatives. Continuing Recommendation We continue to recommend that the Town implement an integrated accounts receivable software solution. Management's Response There is no longer an option for us to have an integrated accounting system with Budgetsense. Our other option is to work with Govern to create a report that will be exported from Govern to Excel, then import from Excel to Budget Sense. This will save considerable time and eliminate duplicate data entry. We plan on this being tested and reviewed by March and fully implemented by the end of the fiscal year. Audit of Student Activity Funds Prior Year Comment The prior year management letter indicated that the Massachusetts Association of School Business Officials (MASBO) published a student activity accounts manual, in May of 2007, to assist school districts with the operation and management of student activity accounts under the provisions of Massachusetts General Law (MGL), Chapter 71,,Section 47, as amended by Chapter 66 of the Acts of 1996. To comply with the MGL, the MASBO recommends that annual audits of the student activity funds be performed. The audit may be an internal audit conducted by the school business administrator, if so approved by the School Committee. However, at least one time every three years, the audit should be performed by an independent audit firm. 6 Current Status The School department did not conduct an audit of the student activity funds in fiscal 2011. Continuing Recommendation We recommend that the School department comply with the MGL and the MASBO recommendation. Management's Response There is an existing policy that states an audit has to be conducted each year and an external audit every three years, but this will be reviewed and amended if necessary by December 31,2011. An audit firm has been hired to conduct an external audit by December 31, 2011. Conduct a Periodic Inventory of Fixed Assets Prior Year Comment The prior year management letter indicated that the Town has a significant investment in property and equipment and we recommended that controls be strengthened in this area. The Town's Charter requires annual physical counts of such property and equipment and we noted that the physical counts were not being performed in accordance with the Charter. We believe that annual physical counts will assist in planning for capital expenditures, help determine accurate amounts and values of insurable assets, and will help detect the loss or unauthorized use of valuable Town property. Current Status The Town is in the process of implementing fixed asset tracking software and inventorying all Town assets with a value in excess of$500. Continuing Recommendation We recommend that the Town complete the implementation of the fixed asset tracking software and inventorying all fixed assets in excess of the$500 threshold. Management's Response The department of Information Technology has fully implemented an asset tracking system, and engaged with the municipal and school departments to ensure all qualifying assets are tagged and inventoried. 7 CURRENT YEAR COMMENTS 8 Bank Deposit Slips Comment When cash receipts are recorded by the Treasurers office, all supporting documentation should be attached to the batch to substantiate what was recorded. This should include, at a minimum, the departmental turnover sheet, a copy of the remittance advice, and the corresponding deposit slip. While conducting our testing of cash receipts, we noted that the Treasurers office does not currently file the deposit slip along with the other supporting documentation for the revenue that is recorded. In a sample of 10 cash transactions,we noted three instances where the Treasurer could not locate the applicable deposit slips. Recommendation In order to maintain a clear audit trail,we recommend that all supporting documentation, including the deposit slip, be maintained with a copy of each cash receipt batch that is recorded in the accounting system. Management's Response We have implemented the recommended procedure. Timeliness of School Department Turnovers Comment While completing our transaction testing,we noted instances in which receipts were being held by the school department for more than two months prior to being turned over to the Treasurers office. For instance, in July, the Treasurer was provided with over 300 checks that were received in April and May, that totaled approximately $73,000, from Community Programs. All receipts collected by a department should be turned over to the Treasurers office, on a timely basis, so that the funds may be deposited into an appropriate bank account. Depositing cash receipts regularly reduces the risk of the funds being misplaced, stolen, or being returned by the bank due to insufficient funds. Recommendation We recommend that procedures be implemented at the school department to ensure that all receipts are turned over to the Treasurers office on a timelier basis. Management's Response A new policy outlining the timely handling and processing of receipts will be approved by the School Committee by December 31, 2011 and implemented. 9 Ambulance Receivables Comment The Town's ambulance receivable totaled approximately$800,000 at fiscal year-end. Of the amounts outstanding, the Town's third party billing agency has estimated approximately$500,000 to be uncollectible, which the Town has appropriately reflected in the financial statements as an allowance for uncollectible accounts. The Town should develop a policy that requires uncollectible accounts to be written-off on at least an annual basis. Recommendation We recommend that the Town develop a policy that requires uncollectible ambulance accounts to be written-off on at least an annual basis. Management's Response Treasurer's office has obtained ambulance receivable policies from other Towns and consulted with our ambulance billing company. During fiscal 2012 the Treasurer's office will work with the Town Manager and Board of Selectmen to develop a policy for ambulance billing collection. 10 G f TOWN OF NORTH ANDOVER, MASSACHUSETTS REPORT ON EXAMINATION OF BASIC FINANCIAL STATEMENTS FISCAL YEAR ENDED JUNE 30, 2011 TOWN OF NORTH ANDOVER, MASSACHUSETTS REPORT ON EXAMINATION OF BASIC FINANCIAL STATEMENTS JUNE 30, 2011 TABLE OF CONTENTS IndependentAuditors' Report..........................................................................................................................................1 Management's Discussion and Analysis.........................................................................................................................3 BasicFinancial Statements...........................................................................................................................................13 Statementof Net Assets............................................................................................................................................15 Statementof Activities ...............................................................................................................................................16 Governmental funds—balance sheet........................................................................................................................18 Reconciliation of the governmental funds balance sheet total fund balances to the statement of net assets..........19 Governmental funds—statement of revenues, expenditures and changes in fund balances...................................20 Reconciliation of the statement of revenues, expenditures, and changes in fund balances of governmental fundsto the statement of activities.............................................................................................................................21 Proprietary funds—statement of net assets..............................................................................................................22 Proprietary funds—statement of revenues, expenses and changes in fund net assets...........................................23 Proprietary funds—statement of cash flows..............................................................................................................24 Fiduciary funds—statement of fiduciary net assets...................................................................................................25 Fiduciary funds—statement of changes in fiduciary net assets................................................................................26 Notesto basic financial statements...........................................................................................................................27 RequiredSupplementary Information............................................................................................................................54 Schedule of revenues, expenditures and changes in fund balance—general fund—budget and actual.................56 RetirementSystem Schedules...................................................................................................................................58 Retirement system schedule of funding progress..................................................................................................59 Retirement system schedule of employer contributions ........................................................................................60 Other postemployment benefit plan schedules..........................................................................................................61 Other postemployment benefit plan schedule of funding progress and schedule of employer contributions........62 Other postemployment benefit plan actuarial methods and assumptions.............................................................63 Notes to required supplementary information............................................................................................................64 Additionalinformation ................................................................................................................................................67 Enterprise funds—schedule of revenues, expenses and changes in fund net assets—budgetary basis—budget andactual...............................................................................................................................................................68 ^ ^ LLC ~, 10 Parkway Independent Auditors' Report Suite 101 Wakefield,MU\U188O To the Honorable Board ofSelectmen T.781-91+1700 Town of North Andover, Massachusetts I(781-914-1701 ~°pv.yopemxodsnllbmocmu We have audited the accompanying financial statements of the governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information of the Town of North Andover, Massachusetts, as of and for the fiscal year ended June 30, 2011,which collectively comprise the Town's basic financial statements as listed in the table of contents. These financial statements are the responsibility of the Town of North Andover, Massachusetts' management. Our responsibility ioto express opinions on these financial statements based on our audit. We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Those standards require that weplan and perform the audit toobtain reasonable assurance about whether the financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements. An audit also includes assessing the accounting principles used and aignifio ant estimates made bymanagement, as well as evaluating the overall financial statement presentation. VVaba|ieve that our audit provides reasonable basis for our opinions. In our opinion, the financial statements referred to above present fairly, in all material respects, the respective financial position of the.governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information of the Town of North Andover, Massachusetts, as of June 30, 2011, and the respective changes in financial position and cash flows, where applicable, thereof for the fiscal year then ended in conformity with accounting principles generally accepted in the United States of America. In accordance with Government Auditing Standards,we have also issued our report dated December 19, 2011, on our consideration of the Town of North Andover, Massachusetts' internal control over financial reporting and our tests of its compliance with certain provisions of laws, regulations, contracts and grant agreements and other matters. The purpose of that report is to describe the scope of our testing of internal control over financial reporting and compliance and the results of that testing, and not to provide an opinion on the internal control over financial reporting oroncompliance. That report ioan integral part ofan audit performed in accordance with Government Auditing Standards and should be read in conjunction with this report in considering the results of our audit. Management's discussion and analysis, located on the following pages, and the schedule of revenues, expenditures and changes in fund balance-general fund—budgetary basis, retirement system schedule of funding progress, retirement system schedule of employer contributions, other postemployment benefit plan schedule of funding progress and schedule of employer contributions, and other postemployment benefit plan actuarial methods and assumptions, located after the notes to the basic financial statements, are not a required part of the basic financial statements but is supplementary information required by accounting principles generally accepted in the United States ofAmerica. VVe have applied certain limited procedures, which consisted principally of inquiries of management regarding the methods of measurement and presentation of the required supplementary information. However, we did not audit the information and express nn opinion nnit. I I� Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the Town of North Andover, Massachusetts' basic financial statements. The additional information, as listed in the table of contents, is presented for purposes of additional analysis and is not a required part of the basic financial statements. Such information has been subjected to the auditing procedures applied in the audit of the basic financial statements and in our opinion, is fairly stated in all material respects in relation to the basic financial statements taken as a whole. December 19, 2011 2 Management's Discussion ana Analysis Town of North Andover,Massachusetts 3 Basic Financial Statements Management's Discussion and Analysis As management of the Town of North Andover,we offer readers of these financial statements this narrative overview and analysis of the financial activities for the fiscal year ended June 30,2011. We encourage readers to consider the information presented in this report. All amounts, unless otherwise indicated, are expressed in whole dollars. The Governmental Accounting Standards Board (GASB) is the authoritative standard setting body that provides guidance on how to prepare financial statements in conformity with generally accepted accounting principles (GAAP)for states and local governmental entities. Users of these financial statements (such as investors, rating agencies and management) rely on the GASB to establish consistent reporting standards for all governments in the United States. This consistent application is the only way users (including citizens,the media, legislators and others)can assess the financial condition of one government compared to others. Recently, significant improvements in financial reporting have been made and more are currently proposed. In 2009, GASB required the full disclosure of other postemployment benefits (OPEB) in footnotes and the recording of the cumulative actuarial liability owed as of a balance sheet date over a thirty year period beginning in 2009. Among the proposals GASB recently made is a requirement that the total cumulative OPEB liability owing workers for past services performed, or(the cumulative actuarial liability owed as of a balance sheet date) would be fully recognized as a liability as of a balance sheet date. GASB has also proposed changes in accounting for governments that provide pension benefits and others that report and administer pension plans for governmental entities. While these changes only relate to financial reporting and do not extend to how governments approach pension plan funding,there is a close connection in existing GASB standards between how governments account for and report information about them in their financial statements. Under these proposals, North Andover would be required to record the entire unfunded actuarially owed pension obligation on their balance sheet as a liability, rather than the current method of just disclosing these future obligations in a footnotes and supplemental data and only recording the current year's funding requirement as an expense. In effect,this proposal would require the Town's financial statements to reflect actual liabilities,when incurred, rather than the current method of not recording them as liabilities and accounting for them as a future costs, even though these were incurred in prior periods. By way of example, the cost of raises would not only increase current payroll requirements for budgeting purposes, but the financial statements would also account for the actuarial costs of pension related benefits attributable to these raises in the period(s)when these raises were incurred. Second, pension plan administrators, such as the Essex County Retirement Board (ECRB)would be required to calculate pension obligations using realistic expected rates of returns(presently ECRB uses 8.25%)and more accurate and conservative other assumptions that dramatically have been used in the past to understate the amount of the unfunded liabilities owed employees. The implementation of these significant GASB requirements would dramatically alter the presentation of the Town's financial position and its operating results to methods required to be used by industry and other non- governmental units. It could result in the recording of over$150 million or perhaps more in additional liabilities on the Town's balance sheet for liabilities due former and current employees. Finally, as previously indicated, the implementation of these GASB requirements could fundamentally change the way government's budget costs and negotiate labor contracts, as well as force local town and cities seek state legislative relief on future obligations due employees, either new or existing. Town of North Andover,Massachusetts 4 Basic Financial Statements Financial Overview • Governmental net assets decreased by$6.2 million in fiscal 2011 due principally to the long term amortization of OPEB liability, which increased by$8.6 million in fiscal 2011 to bring the total recorded liability on the balance sheet to$22.9 million at year end from$14.3 million as of June 30, 2010. Based on the most recent actuarial report, dated July 1, 2010,the actual unfunded accrued liability as of June 30, 2011 totaled$141.5 million of which$22.9 million has been recorded in the balance sheet and$118.5 is to be recorded in the balance sheet over the next 27 years. See above and Note 12 for further discussion of this liability.- • The Essex County Retirement Board recently reported that the total unfunded liability for the pension plan that the Town'participates in increased by$114 million from $143.8 million to$257.8 million, using an estimated 8.25%annual return on funds, or more than 79%from January 1, 2008 to December 31, 2010. North Andover's share of this liability is determined annually based on payroll costs but has generally been approximately 15.5%that could resulting in an unfunded liability of$40 million. • At the close of the current fiscal year, the Town's general fund reported an ending fund balance of$4.7 million, an increase of approximately$424,000 in comparison with the prior year. Total fund balance represents 6% of total general fund expenditures. • The Town's total debt(short-term and long-term combined) decreased by a net of $5.4 million during the current fiscal year of which$1.7 million was attributable to sewer enterprise debt, $2.2 million was attributable to water enterprise debt and$1.7 million was attributable to governmental debt funds This was due to the net effect of$5.2 million from the issuance of new debt and $10.6 million in principal payments on outstanding debt • The Town adopted GASB Statement No. 54 which provides a more structured classification of fund balance and improves the usefulness of fund balance reporting to the users of the Town's financial statements. Overview of the Financial Statements This discussion and analysis are intended to serve as an introduction to the Town of North Andover's basic financial statements. These basic financial statements comprise of three components: 1) government-wide financial statements, 2)fund financial statements, and 3) notes to the financial statements. Government-wide financial statements. The government-wide financial statements are designed to provide readers with a broad overview of finances, in a manner similar to private-sector business. The statement of net assets presents information on all assets and liabilities,with the difference between the two reported as net assets. Over time, increases or decreases in net assets may serve as a useful indicator of whether the financial position is improving or deteriorating. The statement of activities presents information showing how the government's net assets changed during the most recent fiscal year. All changes in net assets are reported as soon as the underlying event giving rise to the change occurs, regardless of the timing of related cash flows. Thus, revenues and expenses are reported in this statement for some items that will only result in cash flows in future fiscal periods(e.g., uncollected taxes and earned but unused vacation leave). Town of North Andover,Massachusetts 5 Basic Financial Statements Both of the government-wide financial statements distinguish functions that are principally supported by taxes and intergovernmental revenues (governmental activities)from other functions that are intended to recover all or a significant portion of their costs through user fees and charges (business-type activities). The governmental activities include general government, public safety, education, public works, health and human services, culture and recreation and interest. The business-type activities include the activities of the water, sewer, and Osgood Hill Estate operations. Fund financial statements. A fund is a grouping of related accounts that is used to maintain control over resources that have been segregated for specific activities or objectives. Fund accounting is used to ensure and demonstrate compliance with finance-related legal requirements. All of the funds can be divided into three categories: governmental funds, proprietary funds, and fiduciary funds. Governmental funds. Governmental funds are used to account for essentially the same functions reported as governmental activities in the governmental-wide financial statements. However, unlike the government-wide financial statements, governmental fund statements focus on near-term inflows of spendable resources, as well as on balances of spendable resources available at the end of the fiscal year. Such information may be useful in evaluating a government's near-term financing requirements. Because the focus of governmental funds is narrower than that of the government-wide financial statements, it is useful to compare the information presented for governmental funds with similar information presented for governmental activities in the government-wide financial statements. By doing so, readers may better understand the long-term impact of the government's near-term financing decisions. Both the governmental fund balance sheet and the governmental fund statement of revenues, expenditures, and changes in fund balances provide a reconciliation to facilitate this comparison between governmental funds and govemmental activities. The Town of North Andover adopts an annual appropriated budget for its general fund. A budgetary comparison schedule has been provided for the general fund to demonstrate compliance with this budget. Proprietary funds. The Town maintains two types of proprietary funds. Enterprise funds are used to report the same functions presented as business-type activities in the government- wide financial statements. The Town uses enterprise funds to account for its water, sewer, and Osgood Hill Estate operations, all of which are considered to be major funds. The Town of North Andover adopts annual appropriated budgets for each enterprise fund. A budgetary comparison schedule has been provided, as additional information, to demonstrate compliance with these budgets. The Internal Service fund is used to account for the financing of services provided by one department to other departments or governmental units. This fund is used to account for risk-financing activities related to active employees' and retirees' health insurance. Fiduciary funds. Fiduciary funds are used to account for resources held for the benefit of parties outside the government. Fiduciary funds are not reflected in the government-wide financial statement because the resources of those funds are not available to support the Town's own programs. The accounting used for fiduciary funds is much like that used for propriety funds. Private-purpose trust funds and agency funds are reported and combined into a single, aggregate presentation in the fiduciary fund financial statements under the captions"private purpose trust funds"and "agency funds," respectively. Town of North Andover,Massachusetts 6 Basic Financial Statements Notes to the basic financial statements. The notes provide additional information that is essential to a full understanding of the data provided in the government-wide and fund financial statements. Government-wide Financial Analysis As noted earlier, net assets may serve over time as a useful indicator of a government's financial position. North Andover's assets exceeded liabilities by$137.6 million at the close of fiscal 2011. Net assets include$139.2 million investment in capital assets(e.g., land, buildings and building improvements, machinery and equipment and infrastructure), less any related debt used to acquire those assets that are still outstanding. The Town uses these capital assets to provide services to citizens; consequently, these assets are not available for future spending. Although the investment in its capital assets is reported net of its related debt, it should be noted that the resources needed to repay this debt must be provided from other sources, since the capital assets themselves cannot be used to liquidate these liabilities. An additional portion of the net assets, $7.6 million, represents resources that are subject to external restrictions on how they may be used. The remaining balance of unrestricted net assets has a year end deficit balance of ($9.2) million. The primary reason for this deficit balance is the increase in the other postemployment benefit liability. At the end of the current fiscal year, the Town is able to report positive balances in two of the three categories of net assets, for the Town as a whole and for its governmental activities. Its business-type activities report positive balances in both categories. The governmental activity and business-type activity components of the Town are presented below. Governmental Activities The Town of North Andover's assets exceeded liabilities for governmental activities by$98.6 million at the close of fiscal 2011. FY 2011 FY 2010 Assets: Current assets............................................. $ 28,372,788 $ 29,267,806 Noncurrent assets(excluding capital)............... 1,144,264 1,516,574 Capital assets............................................. 135,538,168 134,046,177 Total assets........................................... 165,055,220 164,830,557 Liabilities: Current liabilities(excluding debt).................... 6,832,998 7,134,598 Noncurrent liabilities(excluding debt): Other postemployment benefits................... 21,688,499 13,322,006 Compensated absences............................ 1,367,000 1,371,000 Current debt................................................ 6,492,129 6,689,004 Noncurrent debt........................................... 30,042,741 31,516,714 Total liabilities....................................... 66,423,367 60,033,322 Net Assets: Capital assets net of related debt..................... 102,754,256 100,868,439 Restricted................................................... 7,574,263 6,539,198 Unrestricted................................................ (11,696,666) (2,610,402) Total net assets...................................... $ 98,631,853 $ 104,797,235 Town of North Andover, Massachusetts 7 Basic Financial Statements I FY 2011 FY 2010 Program revenues: Charges for services..................................... $ 6,564,295 $ 6,212,690 Operating grants and contributions.................. 18,853,013 16,448,490 Capital grants and contributions...................... 1,856,297 455,022 General Revenues: Real estate and personal property taxes........... 57,726,043 55,855,205 Tax liens.................................................... 576,219 908,371 Motor vehicle and other excise taxes................ 3,748,360 3,165,811 Penalties and interest on taxes....................... 223,861 277,662 Payments in lieu of taxes............................... 1,867,094 1,838,821 Community preservation surcharges................ 1,312,401 1,263,566 Grants and contributions not restricted to specific programs..................................... 2,222,543 2,748,904 Unrestricted investment income...................... 445,515 449,199 Total revenues....................................... 95,395,641 89,623,741 Expenses: General government..................................... 4,559,013 4,021,067 Public safety................................................ 15,134,400 14,654,536 Education................................................... 70,860,920 66,409,142 Public works................................................ 6,485,227 6,227,974 Health and human services............................ 2,080,778 2,054,742 Culture and recreation................................... 2,192,035 2,109,924 Interest...................................................... 1,370,287 1,506,325 Total expenses....................................... 102,682,660 96,983,710 Excess (deficiency) before transfers................. (7,287,019) (7,359,969) Transfers....................................................... 1,121,637 916,256 Change in net assets...................................... $ (6,165,382) $ (6,443,713) The governmental expenses totaled$102.7 million of which $27.3 million (27%)was directly supported by program revenues consisting of charges for services, operating and capital grants and contributions. General revenues totaled $68.1 million, primarily coming from property taxes, motor vehicle excise, payments in lieu of taxes and non-restricted state aid. The governmental net assets decreased by$6.2 million during the current fiscal year. This was due to an$8.4 million increase in the other postemployment benefits liability and a$1.4 million decrease in the internal service fund. These decreases were partially offset by capital grants and favorable operating results for the general fund and community preservation fund. Town of North Andover, Massachusetts 8 Basic Financial Statements Business-type Activities For the Town's business-type activities, assets exceeded liabilities by$38.9 million at the close of fiscal 2011. FY 2011 FY 2010 Assets: Current assets............................................. $ 91-927,896 $ 11,512,413 Noncurrent assets(excluding capital)............... 875,504 993,664 Capital assets............................................. 56,875,340 56,259,161 Total assets........................................... 67,678,740 68,765,238 Liabilities: Current liabilities (excluding debt).................... 756,965 758,466 Noncurrent liabilities (excluding debt): Other postemployment benefits................... 1,219,505 950,071 Court judgments...................................... - 56,000 Current debt................................................ 3,537,069 3,939,351 Noncurrent debt........................................... 23,242,392 26,554,462 Total liabilities....................................... 28,755,931 32,258,350 Net Assets: Capital assets net of related debt..................... 36,443,088 32,898,415 Unrestricted................................................ 2,479,721 3,608,473 Total net assets...................................... $ 38,922,809 $ 36,506,888 Program'revenues: Charges for services..................................... $ 10,787,070 $ 10,295,194 Operating grants and contributions.................. 141,724 177,861 Total revenues....................................... 10,928,794 10,473,055 Expenses: Water........................................................ 3,188,559 2,972,303 Sewer........................................................ 3,877,585 3,644,464 Osgood Hill ................................................ 325,092 259,595 Total expenses....................................... 7,391,236 6,876,362 Excess (deficiency)before transfers................. 3,537,558 3,596,693 Transfers....................................................... (1,121,637) (916,256) Change in net assets...................................... $ 2,415,921 $ 2,680,437 Business-type net assets of$36.4 million represent the investment in capital assets while$2.5 million is unrestricted. The Town's business-type activities net assets increased by$2.4 million in the current fiscal year. The water enterprise fund net assets increased by$1.9 million. This was due to debt service principal payments exceeding depreciation expense by$1.6 million, some increased consumption and a reduction in the cost of services, primarily in utilities, contract services, chemicals, and materials and supplies. . The sewer enterprise fund net assets increased by$631,000. This increase was primarily due to debt service principal payments exceeding depreciation expense by$845,000. The Osgood Hill enterprise fund net assets decreased by$127,000,which was due to unfavorable operating results totaling $45,000 and depreciation expense totaling$82,000. Town of North Andover, Massachusetts 9 Basic Financial Statements Financial Analysis of the Government's Funds As noted earlier, the Town uses fund accounting to ensure and demonstrate compliance with finance-related legal requirements. Governmental funds. The focus of the Town of North Andover's governmental funds is to provide information on near-term inflows, outflows, and balances of spendable resources. Such information is useful in assessing the Town of North Andover's financing requirements. In particular, unassigned fund balance may serve as a useful measure of a government's net resources available for spending at the end of the fiscal year. As of the end of the current fiscal year, governmental funds reported combined ending fund balances of$15 million, of which$4.7 million is for the general fund, $5,400 is for the state fiscal stabilization fund, $5 million is for the community preservation fund, and$5.4 million is for non-major governmental funds. Cumulatively there was an increase of$283,000 in fund balances from the prior year. The general fund is the chief operating fund. At the end of the current fiscal year, unassigned fund balance of the general fund totaled $3.5 million, while total fund balance was$4.7 million. Restrictions of fund balance for debt service totaled $1 million. Fund balances have been assigned for encumbrances and continuing appropriations in the amount of$184,000. Total fund balance represents 6% of total general fund expenditures. The Town's general fund increased by$424,000 in fiscal 2011, which was primarily due to$373,000 that was raised on the tax levy for the stabilization fund as well as$51,000 of investment income earned on stabilization funds. The state fiscal stabilization fund is used to account for federal funds that were received through the American Recovery and Reinvestment Act. The fund decreased by$4,600 during fiscal 2011,which is attributable to timing differences between the receipt and expenditure of grant funds. The community preservation fund increased by$763,000 in fiscal 2011, which is due to timing differences between the receipt and expenditure of surcharge and state grant revenues. The nonmajor governmental funds decreased by$899,000 in fiscal 2011, which is due to timing differences between the receipt and expenditure of bond proceeds. Fiscal year 2011 was the Town's initial year of implementation of GASB#54, Fund Balance Reporting and Governmental Fund Type Definitions. The implementation of this standard has changed the fund balance components into nonspendable, restricted, committed, assigned and unassigned. Additionally, under the new standard, the Town's stabilization fund is reported within the general fund as unassigned. General Fund Budgetary Highlights The$131,000 increase between the original budget and final budget was due to a$373,000 supplemental transfer to the stabilization fund that was funded by a$100,000 reserve fund transfer and $273,000 of free cash, which resulted in a net increase of$273,000. This increase was offset by budget cuts totaling $109,000 and a reduction in state assessments totaling$33,000. Town of North Andover,Massachusetts 10 Basic Financial Statements Capital Asset and Debt Administration Capital Assets. In conjunction with the annual operating budget, the Town annually prepares a capital budget for the upcoming fiscal year and a five-year Capital Improvement Plan (CIP)that is used as a guide for future capital expenditures Town of North Andover,Massachusetts 11 Basic Financial Statements The Town's investment in capital assets for its governmental and business-type activities as of June 30, 2011, amounts to$192.4 million (net of accumulated depreciation). This investment in capital assets includes land, land improvements, buildings and building improvements, machinery and equipment, library books, vehicles and infrastructure. The Town invested$9.5 million for new capital asset additions in the fiscal 2011. The major governmental capital asset events during the current fiscal year included the purchase of land, construction of the new police station, construction of modular classrooms, road construction, police communications, police vehicles, two new fire trucks,fire radio equipment, and a new school IT network. The major business-type capital asset events during the current fiscal year consisted of water and sewer main improvements. Debt Administration. Outstanding gross long-term governmental debt, as of June 30, 2011, totaled $35.9 million. The general government's gross bonded debt decreased $1 million,which was due to the issuance of $4.4 million of general obligation bonds and principal payments totaling$5.4 million. Outstanding gross long-term debt of the water enterprise fund, as of June 30, 2011, totaled $12.2 million. The water gross bonded debt decreased $2.1 million,which was due to the issuance of$225,000 of general obligation bonds and principal payments totaling $2.3 million. Outstanding gross long-term debt of the sewer enterprise fund, as of June 30, 2011, totaled $14.6 million. The sewer gross bonded debt decreased $1.6 million, which was due to principal payments. The Town had $653,000 in outstanding bond anticipation notes (BAN) at year-end. The decrease of$635,000 over the prior year represents permanent funding of the note by the community preservation fund. Please refer to the notes to the basic financial statements for further discussion of the major capital and debt activity. Requests for Information This financial report is designed to provide a general overview of the Town of North Andover's finances for all those with an interest in the government's finances. Questions concerning any of the information provided in this report or requests for additional financial information should be addressed to the Budget Director/Town Accountant,Town Hall, 120 Main Street, North Andover, Massachusetts 01845. Town of North Andover,Massachusetts 12 Basic Financial Statements Basic Financial Statements Town of North Andover,Massachusetts 13 Basic Financial Statements This page intentionally left blank. Town of North Andover,Massachusetts 14 Basic Financial Statements STATEMENT OF NET ASSETS JUNE 30,2011 Primary Government Governmental Business-type Activities Activities Total ASSETS CURRENT: Cash and cash equivalents.................................. $ 21,665,355 $ 7,098,260 $ 28,763,615 Investments...................................................... 270,897 - 270,897 Receivables,net of allowance for uncollectibles: Real estate and personal property taxes............ 881,754 - 881,754 Tax and utility liens........................................ 1,911,180 83,329 1,994,509 Motor vehicle and other excise taxes................. 263,036 - 263,036 User charges................................................ - 2,645,583 2,645,583 Community preservation................................. 19,244 - 19,244 Departmental and other.................................. 393,594 - 393,594 Intergovernmental.......................................... 2,575,215 100,724 2,675,939 Taxforeclosures................................................ 392,513 - 392,513 NONCURRENT: Receivables,net of allowance for uncollectibles: Intergovernmental.......................................... 1,144,264 875,504 2,019,768 Capital assets,nondepreciable............................. 20,787,524 6,116,268 26,903,792 Capital assets,net of accumulated depreciation....... 114,750,644 50,759,072 165,509,716 TOTALASSETS................................................... 165,055,220 67,678,740 232,733,960 LIABILITIES CURRENT: Warrants payable.............................................. 1,418,264 473,149 1,891,413 Accrued payroll................................................. 3,026,274 - 3,026,274 Accrued health claims payable.............. ......... .... 768,000 - 768,000 Tax refunds payable.......................................... 782,000 - 782,000 Accrued interest................................................ 480,951 227,816 708,767 Other liabilities.................................................. 82,349 - 82,349 Liabilities due depositors..................................... 106,160 106,160 Compensated absences..................................... 169,000 - 169,000 Courtjudgments................................................ - 56,000 56,000 Notes payable................................................... 652,812 - 652,812 Bonds payable.................................................. 5,839,317 3,537,069 9,376,386 NONCURRENT: Compensated absences..................................... 1,367,000 - 1,367,000 Other postemployment benefits............................ 21,688,499 1,219,505 22,908,004 Bonds payable.................................................. 30,042,741 23,242,392 53,285,133 TOTAL LIABILITIES............................................... 66,423,367 28,755,931 95,179,298 NET ASSETS Invested in capital assets,net of related debt............... 102,754,256 36,443,088 139,197,344 Restricted for: Debt service..................................................... 1,033,892 - 1,033,892 Community preservation..................................... 5,301,200 - 5,301,200 Permanent funds: Expendable.................................................. 485,059 - 485,059 Nonexpendable............................................. 29,134 - 29,134 Gifts and grants................................................ 724,978 - 724,978 Unrestricted.......................................................... (11,696,666) 2,479,721 (9,216,945) TOTAL NET ASSETS............................................. $ 98,631,853 $ 38,922,809 $ 137,554,662 See notes to basic financial statements. Town of North Andover,Massachusetts 15 Basic Financial Statements STATEMENT OF ACTIVITIES FISCAL YEAR ENDED JUNE 30,2011 Program Revenues Operating Capital Charges for Grants and Grants and Net(Expense) Functions/Programs Expenses Services Contributions Contributions Revenue Primary Government: Governmental Activities: General government.................. $ 4,559,013 $ 616,654 $ 511,117 $ $ (3,431,242) Public safety............................ 15,134,400 2,536,254 171,523 (12,426,623) Education................................ 70,860,920 3,165,842 17,480,918 (50,214,160) Public works............................ 6,485,227 116,051 42,365 1,026,557 (5,300,254) Health and human services......... 2,080,778 117,916 456,908 - (1,505,954) Culture and recreation............... 2,192,035 11,578 125,084 829,740 (1,225,633) Interest................................... 1,370,287 - 65,098 - (1,305,189) Total Governmental Activities... 102,682,660 6,564,295 18,853,013 1,856,297 (75,409,055)' Business-Type Activities: Water..................................... 3,188,559 5,750,569 8,779 - 2,570,789 Sewer.................................... 3,877,585 4,797,301 132,945 1,052,661 Osgood Hill.............................. 325,092 239,200 - (85,892) Total Business-Type Activities.. 7,391,236 10,787,070 141,724 - 39537,558 Total Primary Government....... $ 110,073,896 $ 17,351,365 $ 18,994,737 $ 1,856,297 $ {71,871,4971 See notes to basic financial statements. (Continued) Town of North Andover,Massachusetts 16 Basic Financial Statements STATEMENT OF ACTIVITIES FISCAL YEAR ENDED JUNE 30,2011 Primary Government Governmental Business-Type Activities Activities Total Changes in net assets: Net(expense)revenue from previous page.... $ (75,409,055) $ 3,537,558 $ ` (71,871,497) General revenues: Real estate and personal property taxes, net of tax refunds payable.................... 57,726,043 - 57,726,043 Tax liens.............................................. 576,219 - 576,219 Motor vehicle and other excise taxes......... 3,748,360 - 3,748,360 Penalties and interest............................. 223,861 - 223,861 Payments in lieu of taxes........................ 1,867,094 - 1,867,094 Community preservation surcharges.......... 1,312,401 - 1,312,401 Grants and contributions not restricted to - specific programs............................... 2,222,543 - 2,222,543 Unrestricted investment income................ 445,515 - 445,515 Transfers, net.......................................... 1,121,637 (1,121,637) - Total general revenues and transfers............ 69,243,673 (1,121,637) 68,122,036 Change in net assets........................... (6,165,382) 2,415,921 (3,749,461) Net Assets: Beginning of year............................... 104,797,235 36,506,888 141,304,123 End of year.......................................... $ 98,631,853 $ 38,922,809 $ 137,554,662 (Concluded) Town of North Andover,Massachusetts 17 Basic Financial Statements GOVERNMENTALFUNDS BALANCE SHEET JUNE 30,2011 State Fiscal Nonmajor Total Stabilization Community Governmental Governmental ASSETS General Fund Preservation Funds Funds Cash and cash equivalents.................................... $ 8,975,362 $ 194,876 $ 5,613,230 $ 5,510,288 $ 20,293,756 Investments........................................................ - - - 270,897 270,897 Receivables,net of uncollectibles: Real estate and personal property taxes............... 881,754 - 881,754 _ Tax liens........................................................ 1,911,180 1,911,180 Motor vehicle and other excise taxes................... 263,036 - 263,036 Community preservation.................................... - - 19,244 - 19,244 Departmental and other.................................... 313,045 - 80,549 393,594 Intergovernmental............................:............... 1,688,667 - 329,740 1,701,072 3,719,479 Tax foreclosures.................................................. 392,513 - - 392,513 TOTAL ASSETS.................................................. $ 14,425,557 $ 194,876 $ 5,962,214 $ 7,562,806 $ 28,145,453 LIABILITIES AND FUND BALANCES LIABILITIES: Warrants payable............................................. $ 1,005,705 $ 182,462 $ 8,202 $ 221,711 $ 1,418,080 Accrued payroll............................................... 2,619,946 7,040 - 399,288 3,026,274 Tax refunds payable......................................... 782,000 - - 782,000 Liabilities due depositors................................... 106,160 - 106,160 Other liabilities................................................ 82,349 - - - 82,349 Deferred revenues........................................... 5,155,325 - 348,984 1,554,766 7,059,075 Notes payable................................................. - - 652,812 - 652,812 TOTAL LIABILITIES............................................. 9,751,485 189,502 1,009,998 2,175,765 13,126,750 FUND BALANCES: Nonspendable................................................ - - - 29,134 29,134 Restricted...................................................... 1,033,892 5,374 4,952,216 5,357,907 11,349,389 Assigned........................................................ 184,314 - - - 184,314 Unassigned.................................................... 3,455,866 - - 3,455,866 TOTAL FUND BALANCES.................................... 4,674,072 5,374 4,952,216 5,387,041 15,018,703 TOTAL LIABILITIES AND FUND BALANCES............ $ 14,425,557 $ 194,876 $ 5,962,214 $ 7,562,806 $ 28,145,453 See notes to basic financial statements. Town of North Andover,Massachusetts 18 Basic Financial Statements RECONCILIATION OF THE GOVERNMENTAL FUNDS BALANCE SHEET TOTAL FUND BALANCES TO THE STATEMENT OF NET ASSETS JUNE 30,2011 Total governmental fund balances........................................... ........................... $ 15,018,703 Capital assets(net)used in governmental activities are not financial resources and,therefore,are not reported in the funds.................................................... 135,538,168 Accounts receivable are not available to pay for current-period expenditures and,therefore, are deferred in the funds....................................... 7,059,075 Internal service funds are used by management to account for unemployment, health insurance activities.The assets and liabilities of the internal service funds are included in the governmental activities in the statement of net assets.............. 603,415 In the statement of activities, interest is accrued on outstanding long-term debt, whereas in governmental funds interest is not reported until due......................... (480,951) Long-term liabilities are not due and payable in the current period and,therefore, are not reported in the governmental funds. Bonds payable,net of unamortized premiums and deferred losses on refundings........................................................... (35,882,058) Other postemployment benefits................................................................. (21,688,499) Compensated absences........................................................I.................. (1,536,000) Net effect of reporting long-term liabilities.............................................. (59,106,557) Net assets of governmental activities................................................................... $ 98,631,853 See notes to basic financial statements. Town of North Andover,Massachusetts 19 Basic Financial Statements GOVERNMENTALFUNDS STATEMENT OF REVENUES,EXPENDITURES AND CHANGES IN FUND BALANCES FISCAL YEAR ENDED JUNE 30,2011 State Fiscal Nonmajor Total Stabilization Community Governmental Governmental General Fund Preservation Funds Funds REVENUES: Real estate and personal property taxes, net of tax refunds................................. $ 57,423,755 $ $ $ $ 57,423,755 Tax and utility liens.................................. 238,977 - 238,977 Payments in lieu of taxes........................... 1,731,968 - 135,126 1,867,094 Community Preservation Surcharges........... - 1,510,382 - 1,310,382 Motor vehicle and other excise taxes........... 3,790,515 - - 3,790,515 Charges for services................................. 836,864 3,498,702 4,335,566 Penalties and interest on taxes................... 336,298 - - 336,298 Licenses and permits................................ 220,650 382,665 603,315 Fines and forfeitures................................. 113,167 - - 113,167 Intergovernmental.................................... 15,660,252 622,762 886,099 4,657,022 21,826,135 Departmental and other............................. 1,271,902 - - 406,861 1,678,763 Contributions.......................................... - - 620,946 620,946 Investment income.................................. 364,914 - 51,763 28,838 445,515 TOTAL REVENUES......................... 81,989,262 622,762 2,248,244 9,730,160 94,590,428 EXPENDITURES: Current: General government............................. 2,866,154 - - 236,599 3,102,753 Public safety....................................... 8,620,394 - 4,465,574 13,085,968 Education.......................................... 37,357,213 627,388 8,398,189 46,382,790 Public works....................................... 4,156,778 - - 1,248,876 5,405,654 Health and human services.................... 938,863 - 408,219 1,347,082 Culture and recreation.......................... 813,611 1,470,105 41,580 2,325,296 Pension benefits.................................. 9,537,508 - - 9,537,508 Property and liability insurance............... 276,258 276,258 Employee benefits............................... 9,415,481 9,415,481 State and county charges.......................... 2,115,484 2,115,484 Debt service: Principal............................................. 5,574,681 - 5,574,681 Interest.............................................. 1,337,978 14,812 - 1,352,790 TOTAL EXPENDITURES.................. 83,010,403 627,388 1,484,917 14,799,037 99,921,745 EXCESS(DEFICIENCY)OF REVENUES OVER EXPENDITURES........................... (1,021,141) (4,626) 763,327 (5,068,877) (5,331,317) OTHER FINANCING SOURCES(USES): Issuance of bonds and notes...................... - - 4,365,353 4,365,353 Premium from issuance of bonds................ 127,464 - - 127,464 Transfers in............................................ 1,322,517 1,322,517 Transfers out.......................................... (5,000) (195,880) (200,880) TOTAL OTHER FINANCING SOURCES(USES)....................... 1,444,981 4,169,473 5,614,454 NET CHANGE IN FUND BALANCES............... 423,840 (4,626) 763,327 (899,404) 283,137 FUND BALANCES AT BEGINNING OF YEAR(REVISED)............................ 4,250,232 10,000 4,188,889 6,286,445 14,735,566 FUND BALANCES AT END OF YEAR............. $ 4,674,072 $ 5,374 $ 4,952,216 $ 5,387,041 $ 15,018,703 See notes to basic financial statements. Town of North Andover,Massachusetts 20 Basic Financial Statements RECONCILIATION OF THE STATEMENT OF REVENUES,EXPENDITURES, AND CHANGES IN FUND BALANCES OF GOVERNMENTAL FUNDS TO THE STATEMENT OF ACTIVITIES FISCAL YEAR ENDED JUNE 30,2011 Net change in fund balances-total governmental funds...................................................... $ 283,137 Governmental funds report capital outlays as expenditures. However,in the Statement of Activities the cost of those assets is allocated over their estimated useful lives and reported as depreciation expense. Capitaloutlay................................................................................................. 7,120,754 Depreciationexpense...................................................................................... (5,597,636) Net effect of reporting capital assets........................................................... 1,523,118 The net effect of other miscellaneous transactions involving capital assets (i.e.,sales,trade-ins,and donations)is to decrease net assets............................ (31,127) Revenues in the Statement of Activities that do not provide current financial resources are fully deferred in the Statement of Revenues,Expenditures and Changes in Fund Balances. Therefore,the recognition of revenue for various types of accounts receivable(i.e.,real estate and personal property,motor vehicle excise,etc.)differ between the two statements. This amount represents the net change in deferred revenue........................................................................ 805,213 The issuance of long-term debt(e.g.,bonds and leases)provides current financial resources to governmental funds,while the repayment of the principal of long- term debt consumes the financial resources of governmental funds. Neither transaction,however,has any effect on net assets. Also,governmental funds report the effect of premiums,discounts,and similar items when debt is first issued,whereas these amounts are deferred and amortized in the Statement of Activities. Issuance of bonds and notes............................................................................. (4,365,353) Debt service principal payments..........................................................:............. 5,574,681 Amortization of deferred losses on refundings...................................................... (173,669) Net effect of reporting long-term debt.......................................................... 1,035,659 Some expenses reported in the Statement of Activities do not require the use of current financial resources and,therefore,are not reported as expenditures in the governmental funds. Net change in compensated absences accrual..................................................... 4,000 Net change in accrued interest on long-term debt.................................................. 28,709 Net change in other postemployment benefits...................................................... (8,366,493) Net effect of recording long-term liabilities and amortizing deferred losses.......... (8,333,784) Internal service funds are used by management to account for health insurance and workers'compensation activities. The net activity of internal service funds is reported with Governmental Activities......... (1,447,598) Change in net assets of governmental activities............. .................................................. $ (6,165,382) See notes to basic financial statements. Town of North Andover,Massachusetts 21 Basic Financial Statements PROPRIETARY FUNDS STATEMENT OF NET ASSETS JUNE 30,2011 Business-type Activities-Enterprise Funds Governmental Activities- Osgood Internal Service Water Sewer Hill Total Funds ASSETS CURRENT: Cash and cash equivalents.................................... $ 2,787,055 $ 4,285,631 $ 25,574 $ 7,098,260 $ 1,371,599 Receivables,net of allowance for uncollectibles: User fees....................................................... 1,312,192 1,333,391 - 2,645,583 - Utility liens...................................................... 73,009 10,320 83,329 Intergovernmental............................................ - 100,724 100,724 - Total current assets...................................... 4,172,256 5,730,066 25,574 9,927,896 1,371,599 NONCURRENT: Receivables,net of allowance for uncollectibles: Intergovernmental............................................ - 875,504 - 875,504 Capital assets,nondepreciable............................... 1,982,535 133,733 4,000,000 6,116,268 - Capital assets,net of accumulated depreciation......... 27,146,534 22,172,771 1,439,767 50,759,072 - Total noncurrent assets................................. 29,129,069 23,182,008 5,439,767 57,750,844 - TOTAL ASSETS...................................................... 33,301,325 28,912,074 5,465,341 67,678,740 1,371,599 LIABILITIES CURRENT: Warrants payable................................................. 228,444 235,157 9,548 473,149 184 Health claims payable........................................... - - - - 768,000 Accrued interest................................................... 76,309 151,507 227,816 - Court judgments.................................................. - 56,000 56,000 Bonds payable.................................................... 1,867,574 1,669,495 - 3,537,069 - Total current liabilities................................... 2,172,327 2,112,159 9,548 4,294,034 768,184 NONCURRENT: Other postemployment benefits.............................. 762,827 456,678 - 1,219,505 - Bonds payable.................................................... 10,324,588 12,917,804 23,242,392 Total noncurrent liabilities.............................. 11,087,415 13,374,482 24,461,897 - TOTAL LIABILITIES................................................. 13,259,742 15,486,641 9,548 28,755,931 768,184 NET ASSETS Invested in capital assets,net of related debt................. 18,690,954 12,312,367 5,439,767 36,443,088 - Unrestricted............................................................ 1,350,629 1,113,066 16,026 2,479,721 603,415 TOTAL NET ASSETS............................................... $ 20,041,583 $ 13,425,433 $ 5,455,793 $ 38,922,809 $ 603,415 See notes to basic financial statements. Town of North Andover,Massachusetts 22 Basic Financial Statements PROPRIETARY FUNDS STATEMENT OF REVENUES,EXPENSES AND CHANGES IN FUND NET ASSETS FISCAL YEAR ENDED JUNE 30,2011 Business-type Activities-Enterprise Funds Governmental Activities- Osgood Internal Service Water Sewer Hill Total Funds OPERATING REVENUES: Employee contributions....................................... $ $ - $ $ $ 2,275,972 Employer contributions........................................ - 8,520,609 Charges for services........................................... 5,727,456 4,772,782 239,200 10,739,438 - Penalties and interest........................................... 23,113 24,519 - 47,632 TOTAL OPERATING REVENUES....................... 5,750,569 4,797,301 239,200 10,787,070 10,796,581 OPERATING EXPENSES: Cost of service and administration.......................... 1,770,366 880,774 238,308 2,889,448 GLSD assessment............................................... - 1,428,879 - 1,428,879 - Repairs and maintenance.................................... 135,852 66,888 4,647 207,387 - Depreciation....................................................... 815,587 838,205 82,137 1,735,929 - Employee benefits............................................... - - - - 12,250,648 TOTAL OPERATING EXPENSES....................... 2,721,805 3,214,746 325,092 6,261,643 12,250,648 OPERATING INCOME(LOSS)............................ 3,028,764 1,582,555 (85,892) 4,525,427 (1,454,067) NONOPERATING REVENUES(EXPENSES): Investment income.............................................. 8,779 4,998 13,777 6,469 Interest expense................................................. (466,754) (662,839) (1,129,593) - Intergovernmental............................................... - 127,947 127,947 - TOTAL NONOPERATING REVENUES(EXPENSES),NET........................ (457,975) (529,894) - (987,869) 6,469 INCOME(LOSS)BEFORE TRANSFERS.............. 2,570,789 1,052,661 (85,892) 3,537,558 (1,447,598) TRANSFERS: Transfers in........................................................ - - 5,000 5,000 - Transfers out...................................................... (658,016) (422,161) (46,460) (1,126,637) - TOTAL OPERATING TRANSFERS...................... (658,016) (422,161) (41,460) (1,121,637) - CHANGE IN NET ASSETS................................. 1,912,773 630,500 (127,352) 2,415,921 (1,447,598) NET ASSETS AT BEGINNING OF YEAR................... 18,128,810 12,794,933 5,583,145 36,506,888 2,051,013 NET ASSETS AT END OF YEAR............................. $ 20,041,583 $ 13,425,433 $ 5,455,793 $ 38,922,809 $ 603,415 See notes to basic financial statements. Town of North Andover,Massachusetts 23 Basic Financial Statements PROPRIETARY FUNDS STATEMENT OF CASH FLOWS FISCAL YEAR ENDED JUNE 30,2011 Business-type Activities-Enterprise Funds Activities- Osgood Internal Service Water Sewer Hill Total Funds CASH FLOWS FROM OPERATING ACTIVITIES: Receipts from customers and users.................................................. $ 5,788,532 $ 4,866,849 $ 239,200 $ 10,894,581 $ 2,275,972 Receipts from interfund services provided.......................................... - - - - 8,520,609 Payments to vendors..................................................................... (957,469) (1,897,330) (140,725) (2,995,524) - Payments toemployees................................................................. (617,147) (575,883) (92,682) (1,285,712) Payments for interfund services used................................................ - (12,361,479) NET CASH FROM OPERATING ACTIVITIES........................................ 4,213,916 2,393,636 5,793 6,613,345 (1,564,898) CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES: Transfersin................................................................................. - - 5,000 5,000 Transfers out............................................................................... (658,016) (422,161) (46,460) (1,126,637) NET CASH FROM NONCAPITAL FINANCING ACTIVITIES..................... (658,016) (422,161) (41,460) (1,121,637) CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES: Proceeds from the issuance of bonds and notes................................. 225,000 - 225,000 Intergovernmental........................................................................ - 39,775 39,775 Acquisition and construction of capital assets..................................... (1,362,016) (984,083) (6,009) (2,352,108) Principal payments on bonds and notes............................................ (2,370,448) (1,585,281) (3,955,729) Interest expense........................................................................... (414,306) (485,800) (900,106) NET CASH FROM CAPITAL AND RELATED FINANCING ACTIVITIES...... (3,921,770) (3,015,389) (6,009) (6,943,168) - CASH FLOWS FROM INVESTING ACTIVITIES: Investment income........................................................................ 8,779 4,998 13,777 6,469 NET CHANGE IN CASH AND CASH EQUIVALENTS.............................. (357,091) (1,038,916) (41,676) (1,437,683) (1,558,429) CASH AND CASH EQUIVALENTS AT BEGINNING OF YEAR.................. 3,144,146 5,324,547 67,250 8,535,943 2,930,028 CASH AND CASH EQUIVALENTS AT END OF YEAR $ 2,787,055 $ 4,285,631 $ 25,574 $ 7,098,260 $ 1,371,599 RECONCILIATION OF OPERATING INCOME(LOSS)TO NET CASH FROM OPERATING ACTIVITIES: Operating income(loss)................................................................. $ 3,028,764 $ 1,582,555 $ (85,892) $ 4,525,427 $ (1,454,067) Adjustments to reconcile operating income(loss)to net cash from operating activities: Depreciation............................................................................ 815,587 838,205 82,137 1,735,929 Changes in assets and liabilities: User fees............................................................................ 12,576 50,874 - 63,450 Utility liens.......................................................................... 25,387 18,674 - 44,061 Warrants payable................................................................. 173,417 (151,921) 9,548 31,044 (39,831) Health claims payable........................................................... - - - (71,000) Court judgments................................................................... - (56,000) (56,000) Other postemployment benefits............................................... 158,185 111,249 - 269,434 Total adjustments............................................................. 1,185,152 811,081 91,685 2,087,918 (110,831) NET CASH FROM OPERATING ACTIVITIES........................................ $ 4,213,916 $ 2,393,636 $ 5,793 $ 6,613,345 $ (1,564,898) I NONCASH INVESTING CAPITAL AND FINANCING ACTIVITIES: Intergovernmental debt service subsidy(MWPAT).............................. $ - $ 97,942 $ $ 97,942 $ Net change in deferred charges....................................................... 72,559 41,760 114,319 See notes to basic financial statements. li Town of North Andover,Massachusetts 24 Basic Financial Statements FIDUCIARY FUNDS STATEMENT OF FIDUCIARY NET ASSETS JUNE 30,-2011 Private Purpose Agency Trust Funds Funds ASSETS CURRENT: Cash and cash equivalents........................................ $ 70,795 $ 3,913,718 LIABILITIES Warrants payable..................................................... - 3,976 Liabilities due depositors........................................... - 3,909,742 TOTAL LIABILITIES..................................................... - 3,913,718 NET ASSETS Held in trust for other purposes................................... $ 70,795 $ - See notes to basic financial statements. Town of North Andover,Massachusetts 25 Basic Financial Statements FIDUCIARY FUNDS STATEMENT OF CHANGES IN FIDUCIARY NET ASSETS FISCAL YEAR ENDED JUNE 30, 2011 Private Purpose Trust Funds ADDITIONS: Net investment income: Interest.................................................................. $ 57 NET ASSETS AT BEGINNING OF YEAR.......................... 70,738 NET ASSETS AT END OF YEAR.................................... $ 70,795 See notes to basic financial statements. Town of North Andover, Massachusetts 26 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 NOTE 1 -SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES The accompanying basic financial statements of the Town of North Andover, Massachusetts(the Town) have been prepared in accordance with accounting principles generally accepted in the United States of America (GAAP). The Governmental Accounting Standards Board (GASB)is the recognized standard-setting body for establishing governmental accounting and financial reporting principles. The significant accounting policies are described herein. A. Reporting Entity The Town is a municipal corporation that is governed by an elected Board of Selectmen (the Board). For financial reporting purposes, the Town has included all funds, organizations, account groups, agencies, boards, commissions and institutions. The Town has also considered all potential component units for which it is financially accountable as well as other organizations for which the nature and significance of their relationship with the Town are such that exclusion would cause the basic financial statements to be misleading or incomplete. . As required by GAAP, these basic financial statements present the Town (the primary government) and its component units. It has been determined that there are no component units that meet the requirements for inclusion in the Town's financial statements. Joint Venture A joint venture is an organization (resulting from a contractual arrangement)that is owned, operated and governed by two or more participants as a separate and specific activity subject to joint control in which the participants retain an ongoing financial interest or ongoing financial responsibility. Joint control means that no single participant has the ability to unilaterally control the financial or operating policies of the joint venture. The Town participates in the following joint ventures with other municipalities to pool resources and share the costs, risks, and rewards of providing goods and services to venture participants directly, or for the benefit of the general public or specified recipients. Greater Lawrence Sanitary District(GLSD) GLSD operates a wastewater treatment plant for five member communities and is located within the Town. The GLSD is governed by a seven member board consisting of one appointed representative from the Town. The Town is indirectly liable for the GLSD's debt and other expenditures and is assessed annually for its share of operating and capital costs. For the fiscal year ended June 30, 2011, the Town's assessment totaled $1,428,879. Separate financial statements may be obtained by writing to the Treasurer of the GLSD at 240 Charles Street, North Andover, MA 01845. Greater Lawrence Regional Technical Vocational School(GLRTVS) The GLRTVS is governed by a seven member school committee consisting of one elected representative from the Town. The Town is indirectly liable for the GLRTVS' debt and other expenditures and is assessed annually for its share of operating and capital costs. For the fiscal year ended June 30,2011,the Town's assessment totaled $362,500. Separate financial statements may be obtained by writing to the Treasurer of the GLRTVS at 57 River Road, Andover, MA 01810. Town of North Andover,Massachusetts 27 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 B. Government-Wide and Fund Financial Statements Government-Wide Financial Statements The government-wide financial statements (i.e., statement of net assets and the statement of changes in net assets) report information on all of the non-fiduciary activities of the primary government and its component units. Governmental activities, which are primarily supported by taxes and intergovernmental revenues, are reported separately from business-type activities, which are supported primarily by user fees and charges. Fund Financial Statements Separate financial statements are provided for governmental funds, proprietary funds, and fiduciary funds, even though fiduciary funds are excluded from the government-wide financial statements. Major individual governmental funds and major individual enterprise funds are reported as separate columns in the fund financial statements. Nonmajor funds are aggregated and displayed in a single column. Major Fund Criteria Major funds must be reported if the following criteria are met: • If the total assets, liabilities, revenues, or expenditures/expenses of an individual governmental or enterprise fund are at least 10 percent of the corresponding element(assets, liabilities, etc.)for all funds of that category or type(total governmental or total enterprise funds), and • If the total assets, liabilities, revenues, or expenditures/expenses of the individual governmental fund or enterprise fund are at least 5 percent of the corresponding element for all governmental and enterprise funds combined. Additionally, any other governmental or enterprise fund that management believes is particularly significant to the basic financial statements may be reported as a major fund. Fiduciary funds are reported by fund type. C Measurement Focus Basis of Accounting and Financial Statement Presentation Government-Wide Financial Statements The government-wide financial statements are reported using the economic resources measurement focus and the accrual basis of accounting. Under this method, revenues are recorded when earned and expenses are recorded when the liabilities are incurred. Real estate and personal property taxes are recognized as revenues in the fiscal year for which they are levied. Grants and similar items are recognized as revenue as soon as all eligibility requirements imposed by the provider have been met. The statement of activities demonstrates the degree to which the direct expenses of a particular function or segment are offset by program revenues. Direct expenses are those that are clearly identifiable with a specific function or segment. Program revenues include the following: • Charges to customers or applicants who purchase, use, or directly benefit from goods, services, or privileges provided by a given function or segment. Town of North Andover,Massachusetts 28 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 • Grants and contributions that are restricted to meeting the operational requirements of a particular function or segment. • Grants and contributions that are restricted to meeting the capital requirements of a particular function or segment. Taxes and other items not identifiable as program revenues are reported as general revenues. For the most part, the effect of interfund activity has been removed from the government-wide financial statements. However, the effect of interfund services provided and used between functions is not eliminated as the elimination of these charges would distort the direct costs and program revenues reported for the functions affected, Fund Financial Statements Governmental fund financial statements are reported using the flow of current financial resources measurement focus and the modified accrual basis of accounting. Under the modified accrual basis of accounting, revenues are recognized when susceptible to accrual(i.e., measurable and available). Measurable means the amount of the transaction can be determined and available means collectible within the current period or soon enough thereafter to pay liabilities of the current period. Expenditures are recorded when the related fund liability is incurred, except for unmatured interest on general long-term debt which is recognized when due, and certain compensated absences, claims and judgments which are recognized when the obligations are expected to be liquidated with current expendable available resources. Real estate and personal property tax revenues are considered available if they are collected within 60 days after fiscal year-end. Investment income is susceptible to accrual. Other receipts and tax revenues become measurable and available when the cash is received and are recognized as revenue at that time. Entitlements and shared revenues are recorded at the time of receipt or earlier if the susceptible to accrual criteria is met. Expenditure driven grants recognize revenue when the qualifying expenditures are incurred and all other grant requirements are met. The following major governmental funds are reported: i The general fund is the primary operating fund. It is used to account for all financial resources, except those that are required to be accounted for in another fund. The state fiscal stabilization fund is used to account for federal funds that were received through the American Recovery and Reinvestment Act. The community preservation fund is a special revenue fund used to account for the 3% local real estate tax surcharge on nonexempt property(and matching state trust fund distribution)that can be used for open space, historic resource and affordable housing purposes. Property exempt from the surcharge consists of the first $100,000 of all residential property and also property owned by low income seniors with a low or moderate income as defined by Massachusetts Department of Revenue(DOR) guidelines. Disbursements from this fund must originate from the Community Preservation Committee and be approved by Town Meeting. I Town of North Andover,Massachusetts 29 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30, 2011 The nonmajor governmental funds consist of other special revenue, capital projects and permanent funds that are aggregated and presented in the nonmajor governmental funds column on the governmental funds financial statements. The following describes the general use of these fund types: The special revenue fund is used to account for and report the proceeds of specific revenue sources that are restricted or committed to expenditure for specified purposes other than permanent funds or capital projects. The capital projects fund is used to account for and report financial resources that are restricted, committed, or assigned to expenditure for capital outlays, including the acquisition or construction of capital facilities and other capital assets of the governmental funds. The permanent fund is used to account for and report financial resources that are legally restricted to the extent that only earnings, not principal, may be used for purposes that support the governmental programs. Proprietary fund financial statements are reported using the flow of economic resources measurement focus and use the accrual basis of accounting. Under this method, revenues are recorded when earned and expenses are recorded when the liabilities are incurred. Proprietary funds distinguish operating revenues and expenses from nonoperating items. Operating revenues and expenses generally result from providing services and producing and delivering goods in connection with the proprietary funds principle ongoing operations. All revenues and expenses not meeting this definition are reported as nonoperating revenues and expenses. The following major proprietary funds are reported: The water enterprise fund is used to account for the water activities. The sewer enterprise fund is used to account for the sewer activities. The Osgood Hill enterprise fund is used to account for the operation of Osgood Hill Estate activities. Additionally, the following proprietary fund type is reported: The internal service fund is used to account for the financing of services provided by one department to other departments or governmental units. This fund is used to account for risk financing activities related to employees' health insurance. Fiduciary fund financial statements are reported using the flow of economic resources measurement focus and use the accrual basis of accounting, except for agency funds which have no measurement focus. Fiduciary funds are used to account for assets held in a trustee capacity for others that cannot be used to support the governmental programs. The following fiduciary fund types are reported: The private-purpose trust fund is used to account for trust arrangements that exclusively benefit individuals, private organizations, or other governments. Some of these trusts have donor restrictions and trustee policies that do not allow the endowment portion and any unrealized appreciation to be spent. The donor restrictions and trustee policies only allows the trustees to authorize spending of the realized investment earnings. The Town's educational scholarship trusts are accounted for in this fund. Town of North Andover,Massachusetts 30 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 The agency fund is used to account for assets held in a custodial capacity. Such assets consist primarily of performance bonds and bid deposits. Agency funds do not present the results of operations or have a measurement focus. Government-Wide and Fund Financial Statements Private-sector standards of accounting and financial reporting issued prior to December 1, 1989, generally are followed in both the government-wide and proprietary fund financial statements to the extent that those standards do not conflict with or contradict guidance of the Governmental Accounting Standards Board. Governments also have the option of following subsequent private-sector guidance for their business-type activities and enterprise funds, subject to this same limitation. The government has elected not to follow subsequent private-sector guidance. D. Cash and Investments Government-Wide and Fund Financial Statements . Cash and cash equivalents are considered to be cash on hand, demand deposits and short-term investments with an original maturity of three months or less from the date of acquisition. Investments are carried at fair value. E.Accounts Receivable Government-Wide and Fund Financial Statements The recognition of revenue related to accounts receivable reported in the government-wide financial statements and the proprietary funds and fiduciary funds financial statements are reported under the accrual basis of accounting. The recognition of revenue related to accounts receivable reported in the governmental funds financial statements are reported under the modified accrual basis of accounting. Real Estate,Personal Property Taxes and Tax Liens Real estate and personal property taxes are levied and based on values assessed on January 1St of every year. Assessed values are established by the Board of Assessor's for 100% of the estimated fair market value. Taxes are due on August 1St, November 1 st, February 1St and May 1 st and are subject to penalties and interest if they are not paid by the respective due date. Real estate tax liens are processed one year after the close of the valuation year on delinquent properties and are recorded as receivables in the fiscal year they are processed. Real estate receivables are secured via the tax lien process and are considered 100% collectible. Accordingly, an allowance for uncollectibles is not reported. Personal property taxes cannot be secured through the lien process. The allowance for uncollectibles is estimated based on historical trends and specific account analysis. Motor Vehicle Excise Motor vehicle excise taxes are assessed annually for each vehicle registered and are recorded as receivables in the fiscal year of the levy. The Commonwealth is responsible for reporting the number of vehicles registered and the fair values of those vehicles. The tax calculation is the fair value of the vehicle multiplied by$25 per$1,000 of value. Town of North Andover,Massachusetts 31 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 The allowance for uncollectibles is estimated based on historical trends and specific account analysis. Community Preservation Surcharges Community preservation surcharges are levied annually at a rate of 3% of resident's real estate tax bills with exemptions for the first$100,000 of residential property and property owned by qualified persons with low income and seniors (60+)with low or moderate income defined by DOR guidelines. The surcharge is due with the real estate tax on August 1st, November 1st, February 1st and May 1st and are subject to penalties and interest if they are not paid by the respective due date. Overdue surcharges are included on the tax liens processed on delinquent real estate taxes. Surcharges are recorded as receivables in the fiscal year of the levy. Since the receivables are secured via the lien process, these accounts are considered 100%collectible and therefore do not report an allowance for uncollectibles. Water and Sewer User Charges and Utility Liens User fees are levied monthly based on individual meter readings and are subject to penalties and interest if they are not paid by the respective due date. Water and sewer liens are processed approximately six months after the end of the fiscal year and are included as a lien on the property owner's tax bill. Water and sewer charges and liens are recorded as receivables in the fiscal year of the levy. Since the receivables are secured via the lien process, these accounts are considered 100%collectible and therefore do not report an allowance for uncollectibles. Departmental and Other Departmental and other receivables consist primarily of amounts due from ambulance charges and police details. These receivables are recorded when the applicable service has been performed. The allowance for uncollectibles is estimated based on historical trends and specific account analysis. Intergovernmental Various federal and state grants for operating and capital purposes are applied for and received annually. For non-expenditure driven grants, receivables are recorded as soon as all eligibility requirements imposed by the provider have been met. For expenditure driven grants, receivables are recorded when the qualifying expenditures are incurred and all other grant requirements are met. These receivables are considered 100% collectible and therefore do not report an allowance for uncollectibles. F. Inventories Government-Wide and Fund Financial Statements Inventories are recorded as expenditures at the time of purchase. Such inventories are not material in total to the government-wide and fund financial statements, and therefore are not reported. Town of North Andover,Massachusetts 32 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30, 011 G. Capital Assets Government-Wide and Proprietary Fund Financial Statements Capital assets,which include land, land improvements, buildings and improvements, machinery and equipment, library books, vehicles, infrastructure(e.g:, roads, treatment plants, pump stations ,sewer mains and similar items) and construction-in-progress, are reported in the applicable governmental or business-type activity column of the government-wide financial statements and in the proprietary fund financial statements. Capital assets are recorded at historical cost, or at estimated historical cost, if actual historical cost is not available. Donated capital assets are recorded at the estimated fair market value at the date of donation. Except for the capital assets of the governmental activities column in the government-wide financial statements, construction period interest is capitalized on constructed capital assets. All purchases and construction costs in excess of$10,000 are capitalized at the date of acquisition or construction, respectively, with expected useful lives of greater than one year. Capital assets (excluding land) are depreciated on a straight-line basis. The estimated useful lives of capital assets are as follows: Estimated Useful Life Capital Asset Type in ears Land improvements................................. 20-30 Buildings and improvements..................... 7-50 Machinery and equipment........................ 3-20 Library books......................................... 10 Vehicles................................................ 5 Treatment plants.................................... 10-40 Pump stations........................................ 20-40 Reservoirs............................................. 20-40 Infrastructure......................................... 20-60 The cost of normal maintenance and repairs that do not add to the value of the assets or materially extend asset lives are not capitalized and are treated as expenses when incurred. Improvements are capitalized. Governmental Fund Financial Statements Capital asset costs are recorded as expenditures in the acquiring fund in the fiscal year of the purchase. H. Interfund Receivables and Payables During the course of its operations, transactions occur between and within individual funds that may result in amounts owed between funds. Government-Wide Financial Statements Transactions of a buyer/seller nature between and within governmental funds are eliminated from the governmental activities in the statement of net assets. Any residual balances outstanding between the governmental activities and business-type activities are reported in the statement of net assets as"internal balances". Town of North Andover,Massachusetts 33 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30, 2011 Fund Financial Statements Transactions of a buyer/seller nature between and within funds are not eliminated from the individual fund statements. Receivables and payables resulting from these transactions are classified as"Due from other funds" or"Due to other funds" on the balance sheet. I. Interfund Transfers During the course of its operations, resources are permanently reallocated between and within funds. These transactions are reported as transfers in and transfers out. Government-Wide Financial Statements Transfers between and within governmental funds are eliminated from the governmental activities in the statement of net assets. Any residual balances outstanding between the governmental activities and business- type activities are reported in the statement of activities as"Transfers, net". Fund Financial Statements Transfers between and within funds are not eliminated from the individual fund statements and are reported as transfers in and transfers out. J. Deferred Revenue Deferred revenue at the governmental fund financial statement level represents billed receivables that do not meet the available criterion in accordance with the current financial resources measurement focus and the modified accrual basis of accounting. Deferred revenue is recognized as revenue in the conversion to the government-wide(full accrual)financial statements. K. Net Assets and Fund Equity Government-Wide Financial Statements(Net Assets) Net assets reported as "invested in capital assets, net of related debt' includes capital assets, net of accumulated depreciation, less the principal balance of outstanding debt used to acquire capital assets. Unspent proceeds of capital related debt are not considered to be capital assets. Net assets are reported as restricted when amounts that are not available for appropriation or are legally restricted by outside parties for a specific future use. Net assets have been "restricted for"the following: "Debt service" represents amounts accumulated from the Massachusetts School Building Authority(MSBA)to reduce school construction excluded debt service costs over the life of the loans. "Community preservation" represents amounts restricted for the purpose of acquiring land for conservation, recreational, and affordable housing purposes. "Permanent funds—expendable" represents the amount of realized and unrealized investment earnings of donor restricted trusts. The donor restrictions and trustee policies only allows the trustees to approve spending of the realized investment earnings that support governmental programs. Town of North Andover,Massachusetts 34 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 "Permanent funds—nonexpendable" represents amounts held in trust for which only investment earnings may be expended. "Gifts and grants" represents restrictions placed on assets from outside parties. Fund Financial Statements(Fund Balances) Governmental fund balances are classified as nonspendable, restricted, committed, assigned, or unassigned based on the extent to which the government is bound to honor constraints on the specific purposes for which amounts in those funds can be spent. The governmental fund balance classifications are as follows: "Nonspendable"fund balance includes amounts that cannot be spent because they are either not in spendable form or they are legally or contractually required to be maintained intact. "Restricted"fund balance includes amounts subject to constraints placed on the use of resources that are either externally imposed by creditors, grantors, contributors, or laws or regulations of other governments; or that are imposed by law through constitutional provisions or enabling legislation. "Committed" fund balance includes amounts that can only be used for specific purposes pursuant to constraints imposed by formal action of the government's highest level of decision-making authority. "Assigned"fund balance includes amounts that are constrained by the Town of North Andover's intent to be used for specific purposes, but are neither restricted nor committed. "Unassigned"fund balance includes the residual classification for the general fund. This classification represents fund balance that has not been assigned to other funds and that has not been restricted, committed, or assigned to specific purposes within the general fund. L. Long-term debt Government-Wide and Proprietary Fund Financial Statements Long-term debt is reported as liabilities in the government-wide and proprietary fund statement of net assets. Material bond premiums and discounts are deferred and amortized over the life of the bonds using the straight- line method. Bonds payable are reported net of the applicable bond premium or discount. Governmental Fund Financial Statements The face amount of governmental funds long-term debt is reported as other financing sources. Bond premiums and discounts, as well as issuance costs, are recognized in the current period. Bond premiums are reported as other financing sources and bond discounts are reported as other financing uses. Issuance costs,whether or not withheld from the actual bond proceeds received, are reported as general government expenditures. M. Investment Income Excluding the permanent funds, Investment income derived from major and nonmajor governmental funds is legally assigned to the general fund unless otherwise directed by Massachusetts General Law(MGL). Town of North Andover,Massachusetts 35 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 N. Compensated Absences Employees are granted vacation and sick leave in varying amounts based on collective bargaining agreements, state laws and executive policies. Compensated absences liabilities related to both governmental and business- type activities are normally paid from the funds reporting payroll and related expenditures. Government-Wide and Proprietary Fund Financial Statements Vested or accumulated vacation and sick leave are reported as liabilities and expensed as incurred. Governmental Fund Financial Statements Vested or accumulated vacation and sick leave, which will be liquidated with expendable available financial resources, are reported as expenditures and fund liabilities upon maturity of the liability. O. Use of Estimates Government-Wide and Fund Financial Statements The preparation of basic financial statements in conformity with GAAP requires management to make estimates and assumptions that affect the reported amounts of assets and liabilities and disclosure for contingent assets and liabilities at the date of the basic financial statements and the reported amounts of the revenues and expenditures/expenses during the fiscal year. Actual results could vary from estimates that were used. P. Total Column Government-Wide Financial Statements The total column presented on the government-wide financial statements represents consolidated financial information. Fund Financial Statements The total column on the fund financial statements is presented only to facilitate financial analysis. Data in this column is not the equivalent of consolidated financial information. Q. Individual Fund Deficits Several individual fund deficits exist at June 30, 2011,within the special revenue funds. These deficits will be funded with grant proceeds in subsequent fiscal years. NOTE 2 -CASH AND INVESTMENTS A cash and investment pool is maintained that is available for use by all funds. Each fund type's portion of this pool is displayed on the balance sheet as"Cash and Cash Equivalents." The deposits and investments of the trust funds are held separately from those of other funds. Statutes authorize the investment in obligations of the U.S. Treasury, agencies, and instrumentalities, certificates of deposit, repurchase agreements, money market accounts, bank deposits and the State Treasurer's Investment Pool (the Pool). The Treasurer may also invest trust funds in securities, other than mortgages or collateral loans, Town of North Andover,Massachusetts 36 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 which are legal for the investment of funds of savings banks under the laws of the Commonwealth. In addition, there are various restrictions limiting the amount and length of deposits and investments. The Pool meets the criteria of an external investment pool. The Pool is administered by the Massachusetts Municipal Depository Trust(MMDT), which was established by the Treasurer of the Commonwealth who serves as Trustee. The fair value of the position in the Pool is the same as the value of the Pool shares. Custodial Credit Risk—Deposits In the case of deposits,this is the risk that in the event of a bank failure,the Town's deposits may not be returned to it. The Town's policy is to minimize custodial credit risk by only investing in highly rated banks,which is determined through the utilization of a bank rating service. At fiscal year-end, the carrying amount of deposits totaled $30,758,266 and the bank balance totaled$32,058,209. Of the bank balance, $5,635,626 was covered by Federal Depository Insurance, $9,759,375, was covered by the depositor's insurance fund, and$16,663,208 was collateralized. Interest Rate Risk The Town's investment policy limits investment maturities to one year as a means of managing its exposure to fair value losses arising from increasing interest rates. The Town participates in MMDT,which maintains a cash portfolio and a short-term bond fund with combined average maturities of approximately three months. As of June 30, 2011,the Town had the following investments and maturities. Maturities Investment Type Fair Value 1-5 Years 6-10 Years Debt Securities Bond Mutual Funds....................................$ 93,951 $ - $ 93,951 Repurchase Agreements............................. 380,000 380,000 - Total Debt Securities......................................... 473,951 $ 380,000 $ 93,951 Other Investments Equity Mutual Funds......................................... 176,946 Money Market Mutual Funds........................ 186,051 MMDT..................................................... 1,423,811 Total Investments..............................................$ 2,260,759 The Town participates in MMDT, which maintains a cash portfolio and a short-term bond fund with combined average maturities of approximately 3 months. Custodial Credit Risk—Investments For an investment,this is the risk that, in the event of a failure by the counterparty, the Town will not be able to recover the value of its investments or collateral security that are in the possession of an outside party. The Town did not have investments that were exposed to custodial credit risk. The Town's policy to minimize custodial credit risk is to obtain from brokerage houses and broker/dealers 1) audited financial statements, 2) proof of National Association of Security Dealers certification, 3) a statement that the dealer has read the Town's Town of North Andover,Massachusetts 37 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 investment policy and will comply with it and 4) be in business for no less than five years and have a minimum capitalization of$10 million. Credit Risk Standard and Poor's Investors Service rated $93,951 of bond mutual funds AAA. The$380,000 of repurchase agreements and $1,423,811 of MMDT deposits were unrated. The Town's investment policy limits investments in debt securities to U.S. Treasuries and U.S. Agency Obligations, which are AAA rated, and like-kind investments that are fully collateralized. Concentration of Credit Risk The Town limits the amount the Town may invest in any one issuer to 10%. The Town does not have investments in corporate bonds or equity securities and therefore does not have exposure to concentration of credit risk. NOTE 3 -RECEIVABLES At June 30, 2011, receivables for the individual major and non-major governmental funds including the applicable allowances for uncollectible accounts are as follows: Allowance Gross for Net Amount Uncollectibles Amount Receivables: Real estate and personal property taxes.........................$ 983,754 $ (102,000) $ 881,754 Tax liens.................................................................. 1,911,180 - 1,911,180 Motor vehicle and other excise taxes.............................. 601,036 (338,000) 263,036 Community preservation surcharges.............................. 19,244 - 19,244 Departmental and other............................................... 962,830 (569,236) 393,594 Intergovernmental...................................................... 3,719,479 - 3,719,479 Total......................................................................$ 8,197,523 $ (1,009,236) $ 7,188,287 At June 30, 2011, receivables for the water and sewer enterprise funds are as follows: Allowance Gross for Net Amount Uncollectibles Amount Receivables: User charges............................................................ $ 2,645,583 $ - $ 2,645,583 Utility liens................................................................ 83,329 - 83,329 Intergovernmental...................................................... 976,228 - 976,228 $ 3,705,140 $ - $ 3,705,140 Town of North Andover,Massachusetts 38 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 201'1 Governmental funds report deferred revenue in connection with receivables for revenues that are not considered to be available to liquidate liabilities of the current period. At the end of the current fiscal year,the various components of deferred revenue reported in the governmental funds were as follows: Other General Governmental Fund Funds Total Receivable and other asset type: Real estate and personal property taxes.........................$ 758,977 $ - $ 758,977 Tax liens.................................................................. 1,911,180 - 1,911,180 Tax foreclosures........................................................ 392,513 - 392,513 Motor vehicle and other excise taxes............................. 263,036 - 263,036 Community preservation surcharges.............................. - 19,244 19,244 Departmental and other............................................... 313,045 80,549 393,594 Intergovernmental(highway construction assistance)........ - 1,474,217 1,474,217 Intergovernmental(school construction assistance).......... 1,516,574 - 1,516,574 Intergovernmental(CPA state match)............................. - 329,740 329,740 Total......................................................................$ 5,155,325 $ 1,903,750 $ 7,059,075. NOTE 4-CAPITAL ASSETS Capital asset activity for the fiscal year ended June 30, 2011, is as follows: Beginning Ending Governmental Activities: Balance Increases Decreases Balance Capital assets not being depreciated: Land.........................................................$ 20,284,590 $ 502,815 $ - $ 20,787,405 Construction in progress............................... 4,799,730 119 (4,799,730) 119 Total capital assets not being depreciated.... 25,084,320 502,934 (4,799,730) 20,787,524 Capital assets being depreciated: Land improvements..................................... 3,257,450 - - 3,257,450 Buildings and building improvements............... 126,962,103 6,799,602 - 133,761,705 Machinery and equipment............................. 7,291,850 1,952,527 (656,052) 8,588,325 Library books............................................. 4,014,642 102,795 - 4,117,437 Vehicles.................................................... 5,024,431 1,486,116 (232,703) 6,277,844 Infrastructure............................................. 34,913,077 1,076,510 - 35,989,587 Total capital assets being depreciated......... 181,463,553 11,417,550 (888,755) 191,992,348 Less accumulated depreciation for: Land improvements..................................... (2,063,352) (99,261) - (2,162,613) Buildings and improvements.......................... (41,956,686) (3,425,748) - (45,382,434) Machinery and equipment............................. (4,958,547) (555,142) 656,052 (4,857,637) Library books............................... ............. (3,904,264) (48,410) - (3,952,674) Vehicles.................................................... (3,933,504) (306,581) 201,576 (4,038,509) Infrastructure............................................. (15,685,343) (1,162,494) - (16,847,837) Total accumulated depreciation.................. (72,501,696) (5,597,636) 857,628 (77,241,704) Total capital assets being depreciated, net........... 108,961,857 5,819,914 (31,127) 114,750,644 Total governmental activities capital assets, net....,$ 134,046,177 $ 6,322,848 $ (4,830,857) $ 135,538,168 Town of North Andover,Massachusetts 39 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 Beginning Ending Business-Type Activities: Balance Increases Decreases Balance Capital assets not being depreciated: Land.........................................................$ 6,097,262 $ - $ - $ 6,097,262 Construction in progress............................... 19,006 - - 19,006 Total capital assets not being depreciated.... 6,116,268 - - 6,116,268 Capital assets being depreciated: Land improvements..................................... 225,442 6,009 - 231,451 Buildings and improvements.......................... 1,952,335 - - 1,952,335 Machinery and equipment............................. 2,085,112 82,780 - 2,167,892 Vehicles.................................................... 483,715 - (23,000) 460,715 Treatment plants......................................... 16,573,234 - 16,573,234 Pump stations............................................ 3,372,491 878,507 - 4,250,998 Reservoirs................................................. 1,477,296 - - 1,477,296 Infrastructure............................................. 50,607,404 1,384,812 - 51,992,216 Total capital assets being depreciated......... 76,777,029 2,352,108 (23,000) 79,106,137 Less accumulated depreciation for: Land improvements..................................... (89,994) (9,454) (99,448) Buildings and improvements.......................... (661,508) (70,617) (732,125) Machinery and equipment............................. (1,145,581) (11,670) - (1,157,251) Vehicles...._...... .............. ........................ (325,944) (37,085) 23,000 (340,029) Treatment plants................ ........................ (9,403,322) (441,286) - (9,844,608) Pump stations............................................ (1,973,328) (122,151) (2,095,479) Reservoirs........................... ................. (1,084,862) (52,321) (1,137,183) Infrastructure............................................. (11,949,597) (991,345) - (12,940,942) Total accumulated depreciation.................. (26,634,136) (1,735,929) 23,000 (28,347,065) Total capital assets being depreciated, net........... 50,142,893 616,179 - 50,759,072 Total business-type activities capital assets, net....$ 56,259,161 $ 616,179 $ - $ 56,875,340 Depreciation expense was charged to functions/programs of the primary government as follows: Governmental Activities: General government................................................. $ 301,210 Publicsafety........................................................... 462,632 Education............................................................... 3,161,929 Public works........................................................... 1,358,390 Humanservices...................................................... 132,784 Culture and recreation.............................................. 180,691 Total depreciation expense-governmental activities............ $ 5,597,636 Business-Type Activities: Water..................................................................... $ 815,587 Sewer..................................................................... 838,205 Osgood Hill............................................................. 82,137 I Total depreciation expense-business-type activities............ $ 1,735,929 I Town of North Andover,Massachusetts 40 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 NOTE 5-INTERFUNDTRANSFERS Interfund transfers for the fiscal year ended June 30, 2011, are summarized as follows: Operating Transfers In: Osgood Hill General Enterprise Operating Transfers Out: Fund Fund Total General Fund....................:....... $ - $ 5,000 $ 5,000 (1) Nonmajor Governmental Funds.... 195,880 - 195,880 (2) Water Enterprise Fund................ 658,016 - 658,016 (3) Sewer Enterprise Fund..............:. 422,161 - 422,161 (3) Osgood Hill Enterprise Fund......... 46,460 - 46,460.(3) $ 1,322,517 '$ 5,000 $ 1,327,517 (1) Represents a budgeted transfer to fund an operating deficit. (2) Represents budgeted transfers from other available funds. (3) Represents budgeted transfers for indirect costs. NOTE 6—LEASES Operating Lease The Town entered into a commercial lease for office space for the Schools Business Office that expires May 31, 2012. The future minimum lease payments are as follows: Governmental Fiscal Years Ending June 30, Activities 2012...................................................... $ 91,098 I I 'i Town of North Andover,Massachusetts 41 Basic Financial Statements II Notes to Basic Financial Statements Fiscal Year Ended June 30, 2011 NOTE 7-SHORT-TERM FINANCING Short-term debt may be authorized and issued to fund the following: • Current operating costs prior to the collection of revenues through issuance of revenue or tax anticipation notes (RANS or TANS). • Capital project costs and other approved expenditures incurred prior to obtaining permanent financing through issuance of bond anticipation notes (BANS)or grant anticipation notes (GANS). Short-term loans are general obligations and carry maturity dates that are limited by statute. Interest expenditures and expenses for short-term borrowings are accounted for in the general fund and enterprise funds, respectively. Details related to the short-term debt activity for the fiscal year ended June 30, 2011, are as follows: Rate Beginning Ending Type Purpose (%) Due Date Balance Additions Reductions Balance BAN Land Acquisition.......... 1.15 6/16/2011 $ 1,288,000 $ - $ 1,288,000 $ - BAN Land Acquisition.......... 1.05 6/1512012 - 652,812 - 652,812 Total.................................... $ 1,288,000 $ 652,812 $ 1,288,000 $ 652,812 I I NOTE 8-LONG-TERM DEBT State law permits the Town, under the provisions of Chapter 44, Section 10, to authorize indebtedness up to a limit of 5% of its equalized valuation. Debt issued in accordance with this section of the law is designated as being"inside the debt limit". In addition, however, a Town may authorize debt in excess of that limit for specific purposes. Such debt,when issued, is designated as being 'outside the debt limit". In prior years, the Town defeased certain of its outstanding general obligation bonds by placing the proceeds of new refunding bonds in an irrevocable escrow account to provide amounts sufficient for the future payment of principal and interest on those bonds.Accordingly, neither the assets in the escrow nor the liability for the defeased bonds are included in the Town's financial statements.At June 30, 2011, $2,500,000 of general obligation bonds outstanding are considered defeased. i Town of North Andover,Massachusetts 42 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 Details related to the outstanding indebtedness at June 30, 2011, and the debt service requirements are as follows: Bonds and Notes Payable-Governmental Funds Interest Rate Beginning Ending Project (%) Balance Additions Reductions Balance Municipal Purpose Loan of 2001.........:.............. 4.00-4.20 $ 85,000 $ - $ 85,000 $ - Municipal Purpose Loan of 2002........................ 4.00-4.50 2,400,000 - .1,200,000 1,200,000 Municipal Purpose Loan of 2003........................ 2.30-4.00 290,261 - 100,174 190,087 Municipal Purpose Loan of 2004........................ 2.00-5.00 2,620,000 - 655,000 1,965,000 Refunding Bonds of 2004................................. 2.00-4.20 3,236,294 - 699,200 2,543,094 Municipal Purpose Loan of 2005........................ 3.00-4.00 409,440 - 81,888 327,552 Municipal Purpose Loan of 2005........................ 3.00-4.00 3,910,955 - 389,326 3,521,629 High School Construction................................. 3.30-5.00 2,400,000 - 150,000 2,250,000 Sargent School Ventilation................................ 3.60-4.50 48,195 - 8,195 40,000 School System Technology............................... 3.60-4.50 146,805 - 25,555 121,250 Roadwork...................................................... 3.60-4.50 43,400 - 43,400 - Drainage Improvements................................... 3.60-4.50 31,200 - 5,200 26,000 Town Garage Heating...................................... 3.60-4.50 15,000 - 2,500 12,500 Historic Center Roadway.................................. 4,00-4.40 208,000 - 30,500 177,500 Olde Center Roadway...................................... 4.00-4.40 313,513 - 39,189 274,324 Franklin School Roof....................................... 4.00-4.40 193,796 - 11,400 182,396 Front End Loader............................................ 4.00-4.40 144,000 - 18,000 126,000 Ambulance Replacement.................................. 4.00-4.40 126,831 - 15,854 110,977 Mosquito Brook Drainage................................. 4.00-4.40 72,000 - 4,000 68,000 Tractor.......................................................... 4.00-4.40 44,000 - 5,500 38,500 Land Acquisition-Refunding............................. 3.00-4.00 2,420,000 - 265,000 2,155,000 Municipal Purpose Loan 1998-Refunding............ 3.00-4.00 1,730,000 - 160,000 1,570,000 Municipal Purpose Loan 1998-Refunding............ 3.00-4.00 6,120,000 - 675,000 5,445,000 Municipal Purpose Loan 2009............................ 2.75-5.00 6,551,126 - 579,978 5,971,148 Municipal Purpose Loan 2009,Series A............... 2.25-4.00 4,171,222 - 330,822 3,840,400 Municipal Purpose Loan 2011............................ 2.00-3.75 - 4,365,353 - 4,365,353 Sub-total....................................................... 37,731,038 4,365,353 5,574,681 36,521,710 Deferred loss on refundings.............................. (813,321) - (173,669) (639,652) Total governmental bonds and notes payable........ $ .36,917,717 $ 4,365,353 $ 5,401,012 $ 35,882,058 Town of North Andover,Massachusetts 43 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 Debt service requirements for principal and interest for Governmental bonds payable in future fiscal years are as follows: Fiscal Year Principal Interest Total 2012.......... $ 5,995,123 $ 1,264,568 $ 7,259,691 2013.......... 4,846,282 1,044,678 5,890,960 2014.......... 4,822,957 886,252 5,709,209 2015.......... 3,497,880 738,087 4,235,967 2016.......... 3,142,274 616,554 3,758,828 2017.......... 2,981,999 509,994 3,491,993 2018.......... 3,001,331 398,239 3,399,570 2019.......... 1,601,669 301,659 1,903,328 2020.......... 1,122,900 245,072 1,367,972 2021.......... 1,087,900 205,390 1,293,290 2022.......... 740,400 170,733 911,133 2023.......... 730,400 142,243 872,643 2024.......... 730,399 113,709 844,108 2025.......... 730,399 83,836 814,235 2026.......... 500,399 58,097 558,496 2027.......... 350,399 40,686 391,085 2028.......... 329,000 26,238 355,238 2029.......... 310,000 12,713 322,713 Totals........ $ 36,521,710 $ 6,858,748 $ 43,380,458 Bonds and Notes Payable-Water Enterprise Fund Interest Rate Beginning Ending Project (%) Balance Additions Reductions Balance Municipal Purpose Loan of 1996........................ 4.00-5.20 $ 274,500 $ - $ 274,500 $ Municipal Purpose Loan of 2001........................ 4.00-4.20 65,000 - 65,000 - Municipal Purpose Loan of 2002........................ 4.00-4.50 375,000 - 230,000 145,000 Municipal Purpose Loan of 2003........................ 2.30-4.00 1,537,368 - 421,784 1,115,584 Refunding Bonds of 2004................................. 2.00-4.20 618,705 - 111,800 506,905 Municipal Purpose Loan of 2005........................ 3.00-4.00 359,576 - 59,929 299,647 Municipal Purpose Loan of 2005........................ 3.00-4.00 1,216,000 - 243,200 972,800 Water Supply System Security........................... 3.60-4.50 129,000 - 21,500 107,500 Bear Hill Water Tank....................................... 3.60-4.50 19,000 - 19,000 - Sutton Hill Water Tank..................................... 3.60-4.50 17,000 - 17,000 - Lake Outlet Structure....................................... 3.60-4.50 360,000 - 60,000 300,000 MWPAT........................................................ 2.00 5,080,765 - 236,858 4,843,907 Water Mains................................................... 3.70-5.00 520,000 - 65,000 455,000 Water Meter Replacement................................ 3.70-5.00 280,000 - 35,000 245,000 Municipal Purpose Loan of 1998-Refunding........ 3.00-4.00 1,173,777 - 334,477 839,300 Municipal Purpose Loan of 2009........................ 2.75-5.00 405,000 - 45,000 360,000 Municipal Purpose Loan of 2009,Series A............ 2.25-4.00 2,025,000 - 130,400 1,894,600 Water Meters................................................. 2.00-3.75 - 225,000 225,000 Subtotal......................................................... 14,455,691 225,000 2,370,448 12,310,243 Deferred loss on refundings...........................- (190,640) - (72,559) (118,081) Total Water Enterprise bonds and notes payable... $ 14,265,051 $ 225,000 $ 2,297,889 $ 12,192,162 Town of North Andover,Massachusetts 44 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 Debt service requirements for principal and interest for Water Enterprise fund bonds and notes payable in future fiscal years are as follows: Fiscal Year Principal Interest Total 2012..........$ 1,917,627 $ 346,921 $ 2,264,548 2013.......... 1,771,078 285,072 2,056,150 2014.......... 1,213,343 233,469 1,446,812 2015.......... 1,229,622 194,804 1,424,426 2016.......... 855,199 155,418 1,010,617 2017.......... 624,558 131,096 755,654 2018.......... 629,953 113,167 743,120. 2019.......... 480,453 95,319 575,772 2020.......... 396,073 82,700 478,773 2021.......... 376,801 73,456 450,257 2022.......... 360,146 65,109 425,255 2023.......... 366,108 56,873 422,981 2024.......... 372,191 48,514 420,705 2025.......... 378,397 39,708 418,105 2026.......... 384,729 30,777 415,506 2027.......... 391,188 21,717 412,905 2028.......... 397,777 12,528 410,305 2029.......... 65,000 6,600 71,600 2030.......... 100,000 4,000 104,000 Totals........ $ 12,310,243 $ 1,997,248 $ 14,307,491 Bonds and Notes Payable-Sewer Enterprise Fund Interest Rate Beginning Ending Project (%) Balance Additions Reductions Balance MWPAT......................................................... 3.70-5.40 $ 278,600 $ - $ 46,930 $ 231,670 MWPAT......................................................... 3.40-5.40 239,185 - 42,686 196,499 MWPAT......................................................... 3.40-5.40 340,485 - 60,764 279,721 Municipal Purpose Loan of 1996.......................... 4.00-5.20 60,500 - 60,500 - MWPAT......................................................... 2.80-3.40 230,000 - 20,000 210,000 MWPAT......................................................... 2.80-3.40 835,000 - 75,000 760,000 MWPAT......................................................... 2.80-3.40 100,000 - 10,000 90,000 MWPAT......................................................... 2.80-3.50 130,000 - 10,000 120,000 MWPAT......................................................... 2,80-3.50 160,000 - 15,000 145,000 MWPAT......................................................... 2,80-3.50 620,000 - 55,000 565,000 MWPAT......................................................... 2.60-2.80 1,544,891 - 119,891 1,425,000 Municipal Purpose Loan of 2003.......................... 2.30-3.70 2,102,370 - 288,043 1,814,327 Municipal Purpose Loan of 2005.......................... 3.00-4.00 799,560 - 159,912 639,648 Municipal Purpose Loan of 2005.......................... 3.00-4.00 244,467 - 40,745 203,722 Sewer Extension.............................................. 3.60-4.50 525,400 - 47,650 477,750 Waverly Road.................................................. 3.70-5.00 3,491,866 - 112,620 3,379,246 Sewer Watershed............................................. 3.70-5.00 160 - 20 140 Wastewater Management.................................. 3.70-5.00 115,834 - 57,917 57,917 Municipal Purpose Loan of 1998-Refunding......... 3.00-4.00 206,223 - 45,523 160,700 Municipal Purpose Loan of 1998-Refunding......... 3.00-4.00 310,000 - 35,000 275,000 East Side Sewer......... .................................... 2.75-5.00 438,872 - 50,022 388,850 Municipal Purpose Loan 2010-Refunding............ 2.25-3.50 3,465,001 - 305,000 3,160,001 East Side Truck Sewer...................................... 2.25-3.25 250,000 - 25,000 225,000 Subtotal......................................................... 16,488,414 - 1,683,223 14,805,191 Deferred loss on refundings.............................. (259,652) - (41,760) (217,892) Total Sewer Enterprise bonds and notes payable... $ 16,228,762 $ - $ 1,641,463 $ 14,587,299 Town of North Andover, Massachusetts 45 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 Debt service requirements for principal and interest for Sewer Enterprise fund bonds and notes payable in future fiscal years are as follows: Fiscal Year Principal Interest Total 2012.......... $ 1,707,568 $ 546,875 $ 2,254,443 2013.......... 1,700,869 486,155 2,187,024 2014.......... 1,740,789 432,993 2,173,782 2015.......... 1,772,907 367,587 2,140,494 2016.......... 1,422,751 305,413 1,728,164 2017.......... 1,140,500 252,499 1,392,999 2018.......... 1,156,170 205,602 1,361,772 2019.......... 955,836 158,991 1,114,827 2020.......... 894,599 121,421 1,016,020 2021.......... 644,600 89,935 734,535 2022.......... 494,599 68,711 563,310 2023.......... 209,600 50,327 259,927 2024.......... 204,601 41,681 246,282 2025.......... 204,601 62,986 267,587 2026.......... 194,601 24,290 218,891 2027.......... 189,601 15,776 205,377 2028.......... 170,999 7,481 178,480 Totals........ $ 14,805,191 $ 3,238,723 $ 18,043,914 The Sewer Enterprise Fund is scheduled to be subsidized by the Massachusetts Water Pollution Abatement Trust (MWPAT) on a periodic basis for principal in the amount of$976,228 and interest costs of$643,932. Thus, net MWPAT loan repayments, including interest, are schedule to be$3,277,894. The principal subsidies are guaranteed and therefore a$976,228 intergovernmental receivable has been reported in the proprietary fund financial statements. Since the Town is legally obligated for the total amount of the debt, such amounts have been recorded in the accompanying basic financial statements. The fiscal year 2011 principal and interest subsidies totaled$97,942 and$127,947, respectively. The Commonwealth has approved school construction assistance. The assistance program,which is administered by the Massachusetts School Building Authority, provides resources for future debt service of general obligation school bonds outstanding. During fiscal year 2011, approximately$412,000 of such assistance was received. Approximately$1,649,000 will be received in future fiscal years. Of this amount, approximately $132,000 represents reimbursement of long-term interest costs, and approximately$1,517,000 represents reimbursement of approved construction costs.Accordingly, a$1,517,000 intergovernmental receivable and corresponding deferred revenue have been reported in the governmental fund financial statements. The deferred revenue has been recognized as revenue in the conversion to the government-wide financial statements. Town of North Andover,Massachusetts 46 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 The Town is subject to various debt limits by statute and may issue additional general obligation debt under the normal debt limit. At June 30,2011, the Town had the following authorized and unissued debt. Purpose Amount Revenue Billing System................................................ $ 75,000 Fire Sprinkler System................................................... 375,000 Meter Replacement..................................................... 225,000 Roadway Improvements............................................... 342,192 Fire Alarm Boxes and Panels......................................... 53,011 Internet Telephone System.....................................:...... 375,000 Middle School Roof Replacements................................. 1,859,134 Defibrillator Replacement.............................................. 43,000 Police Station Parking Lot and Exterior Lighting................. 125,000 Emergency Generator at Public Works............................ 38,000 School Department Data Storage and Intergration.............. 82,000 Vehicle Fuel Pump System............................................ 45,000 DumpTruck............................................................... 182,579 Sargent School Roof Replacement................................. 564,000 Atkinson School Window Replacment.............................. 1,277,000 Heating,Ventilating and Air Conditioning Equipment........... 690,000 Valve and Hydrant Replacement and Installation............... 260,000 Sewer Utility Truck...................................................... 78,000 Total........................................................................ $ 6,688,916 Changes in Long-term Liabilities During the fiscal year ended June 30, 2011,the following changes occurred in long-term liabilities: Beginning Ending Due within Balance Additions Reductions Balance One Year Governmental Activities: Long-term bonds and notes............ $ 37,731,038 $ 4,365,353 $ (5,574,681) $ 36,521,710 $ 5,995,123 Unamortized deferred loss on refundings............................. (813,321) - 173,669 (639,652) (155,806) Bonds and notes payable net.......... 36,917,717 4,365,353 (5,401,012) 35,882,058 5,839,317 Other postemployment benefits....... 13,322,006 12,086,115 (3,719,622) 21,688,499 - Compensated absences................ 1,540,000 165,000 (169,000) 1,536,000 169,000 Total governmental....................... $ 51,779,723 $ 16,616,468 $ (9,289,634) $ 59,106,557 $ 6,008,317 Town of North Andover,Massachusetts 47 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 Beginning Ending Due within Balance Additions Reductions Balance One Year Business-Type Activities: Long-term bonds and notes............ $ 30,944,105 $ 225,000 $ (4,053,671) $ 27,115,434 $ 3,625,195 Unamortized deferred loss on refunding.............................. (450,292) - 114,319 (335,973) (88,126) Bonds and notes payable net.......... 30,493,813 225,000 (3,939,352) 26,779,461 3,537,069 Other postemployment benefits....... 950,071 389,220 (119,786) 1,219,505 - Court judgments........................... 112,000 - (56,000) 56,000 56,000 Total business-type...................... $ 31,555,884 $ 614,220 $ (4,115,138) $ 28,054,966 $ 3,593,069 NOTE 9—GOVERNMENTAL FUND BALANCE CLASSIFICATIONS The Town has adopted GASB 54 as part of its fiscal year 2011 reporting. Implementation of GASB 54 is required for fiscal years beginning after June 15, 2010. The intention of the GASB is to provide a more structured classification of fund balance and to improve the usefulness of fund balance reporting to the users of the Town's financial statements. The reporting standard establishes a hierarchy for fund balance classifications and the constraints imposed on the uses of those resources. GASB 54 provides for two major types of fund balances, which are nonspendable and spendable. Nonspendable fund balances are balances that cannot be spent because they are not expected to be converted to cash or they are legally or contractually required to remain intact. Examples of this classification are prepaid items, inventories, and principal(corpus) of an endowment fund. The Town has reported principal portions of endowment funds as nonspendable. In addition to the nonspendable fund balance, GASB 54 has provided a hierarchy of spendable fund balances, based on a hierarchy of spending constraints. • Restricted: fund balances that are constrained by external parties, constitutional provisions, or enabling legislation. • Committed: fund balances that contain self-imposed constraints of the government from its highest level of decision making authority. • Assigned:fund balances that contain self-imposed constraints of the government to be used for a particular purpose. • Unassigned: fund balance of the general fund that is not constrained for any particular purpose Massachusetts General Law Ch.40 §5B allows for the establishment of stabilization funds for one or more different purposes. The creation of a fund requires a two-thirds vote of the legislative body and must clearly define the purpose of the fund. Any change to the purpose of the fund along with any additions to or appropriations from the fund requires a two-thirds vote of the legislative body. At year end, the balance of the general stabilization fund is$2,646,278 and is reported as unassigned fund balance within the general fund. Town of North Andover,Massachusetts 48 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 The Town has classified its fund balances with the following hierarchy. GOVERNMENTALFUNDS State Fiscal Nonmajor Total Stabilization Community Governmental Governmental General Fund Preservation Funds Funds FUND BALANCES Nonspendable: Permanent fund principal.........................$ $ - $ - $ 29,134 $ 29,134 Restricted for: Municipal Federal and State Grants............ - - 288,391 288,391 Education Federal and State Grants 5,374 - 189,040 194,414 Receipts reserved for appropriations.......... - - 172,285 172,285 Municipal Revolving Funds....................... - - 404,097 404,097 Education Revolving Funds...................... - - - 516,851 516,851 School Lunch Funds............................... - - - 185,797 185,797 CPA Fund.................... - - 4,952,216 - 4,952,216 Other Special Revenue Funds.................. - - 424,190 424,190 Municipal Capital Projects........................ - - 1,230,799 1,230,799 Education Capital Projects........................ - 349,523 349,523 Affordable Housing Trust Fund.................. - - 1,065,949 1,065,949 Other Trust Funds.................................. 45,926 45,926 Debt Service.......................................... 1,033,892 - - - 1,033,892 Other Permenant Funds........................... - - - 485,059 485,059 Assigned to: General government............................... 64,770 - - 64,770 Public safety.......................................... 12,798 - 12,798 Education.....__.................................. 43,885 - - - 43,885 Public works.......................................... 58,587 - - 58,587 Culture and recreation............................. 636 - - 636 Employee benefits.................................. 3,638 - - 3,638 Unassigned............................................... 3,455,866 - - 3,455,866 TOTAL FUND BALANCES(DEFICIT)................$ 4,674,072 $ 5,374 $ 4,952,216 $ 5,387,041 $ 15,018,703 Revisions In accordance with GASB Statement No. 54, the stabilization fund has been reported in the general fund, and accordingly, the general fund beginning balance has been revised by$2,222,033 and totals$4,250,232. Included in the unassigned fund balance of the general fund is$2,646,278 of stabilization fund balance. NOTE 10-RISK FINANCING The Town is exposed to various risks of loss related to torts; theft of, damage to and destruction of assets; errors and omissions; and natural disasters for which the Town carries commercial insurance. The Town participates in a premium-based workers' compensation plan for its active and retired employees. The Town is self-insured for its health insurance activities. These activities are accounted for in the internal service fund where revenues are recorded when earned and expenses are recorded.when incurred. . Health Insurance Health insurance claims are administered by a third party administrator and are funded on an as needed basis from the Town's internal service fund. The estimated "Incurred But Not Reported (IBNR)"claims are based on actual and historical lag claims. The Town purchases individual stop loss insurance for claims in excess of the coverage provided by the Town in the amount of$100,000 per claim. The amount of claim settlements has not exceeded the insurance coverage in any of the previous three fiscal years. Town of North Andover,Massachusetts 49 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 The liability at June 30, 2011 totaled $768,000. Changes in the reported liability since July 1, 2009, are as follows: Current Year Balance at Claims and Balance at Beginning of Changes in Claims Fiscal Fiscal Year Estimate Payments Year-End Fiscal Year 2010........... $ 754,000 $ 9,736,000 $ (9,651,000) $ 839,000 Fiscal Year 2011........... 839,000 12,251,000 (12,322,000) 768,000 NOTE 11 -PENSION PLAN Plan Description-The Town contributes to the Essex Regional Retirement System (the System), a cost sharing multiple-employer defined benefit pension plan administered by the Essex County Retirement Board. School teachers and certain administrators are members of the Commonwealth of Massachusetts'Teachers Retirement System, to which the Town does not contribute. All pension benefits and expenses paid by the Teachers Retirement System are funded by the Commonwealth of Massachusetts (Commonwealth). The amount of these on-behalf payments totaled approximately$6,734,000 for the fiscal year ended June 30, 2011, and accordingly are reported in the general fund as intergovernmental revenues and pension benefit expenditures. The System provides retirement, disability and death benefits to plan members and beneficiaries. Chapter 32 of the MGL assigns authority to establish and amend benefit provisions of the plan. Cost-of-living adjustments granted between 1981 and 1997 and any increase in other benefits imposed by the Commonwealth's state law during those years are borne by the Commonwealth and are deposited into the pension fund. Cost-of-living adjustments granted after 1997 must be approved by the System and are borne by the System. The System issues a publicly available financial report in accordance with guidelines established by the Commonwealth's Public Employee Retirement Administration Commission. That report may be obtained by contacting the System located at 36 Federal Street, Salem, Massachusetts, 01970. Funding Policy-Plan members are required to contribute to the System at rates ranging from 5%to 11%of annual covered compensation. The Town is required to pay into the System its share of the system-wide actuarial determined contribution,which is apportioned among the employers based on active current payroll. The contributions of plan members and the Town are governed by Chapter 32 of the MGL. The Town's contributions to the System for the fiscal years ended June 30, 2011, 2010, and 2009 totaled $2,803,785, $2,596,530, and $2,468,667, respectively, which equaled its required contribution for each fiscal year. The schedule of funding progress, presented as required supplementary information,following the notes to the basic financial statements, presents multiyear trend information about whether the actuarial value of plan assets is increasing or decreasing over time relative to the actuarial accrued liability for benefits. Additionally, the schedule of employer contributions, presented as required supplementary information, following the notes to the basic financial statements, presents multiyear trend information for required and actual contributions relating to the cost- sharing plan as a whole, of which the Town is one participating employer, as well as the Town's proportionate share of the plan's annual contributions. This information is designed to be helpful for understanding the scale of the information presented relative to the Town. Town of North Andover, Massachusetts 50 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30, 2011 NOTE 12—POSTEMPLOYMENT BENEFITS OTHER THAN PENSIONS Plan Description—The Town of North Andover administers a single-employer defined benefit healthcare plan ("the Retiree Health Plan"). The plan provides lifetime healthcare insurance for eligible retirees and their spouses through the Town's group health insurance plan,which covers both active and retired members. Chapter 32B of the MGL assigns authority to establish and amend benefit provisions of the plan. Benefit provisions are negotiated between the Town and the unions representing Town employees and are renegotiated each bargaining period. The Retiree Health Plan does not issue a publicly available financial report. Funding Policy—Contribution requirements are also negotiated between the Town and union representatives. The required contribution is based on a pay-as-you-go financing requirement. The Town contributes a variable portion of the cost of current-year premiums, which varies by plan, for eligible retired plan members and their spouses. Plan members receiving benefits contribute the remaining portion of their premium costs. For fiscal year 2011, the Town contributed $3.8 million to the plan. Annual OPEB Cost and Net OPEB Obligation—The Town's annual other postemployment benefit(OPEB) cost (expense) is calculated based on the annual required contribution of the employer(ARC), an amount actuarially determined in accordance with the parameters of GASB Statement 45. The ARC represents a level of funding that, if paid on an ongoing basis, is projected to cover the normal cost each year and amortize any unfunded actuarial liabilities(or funding excess)over a period not to exceed thirty years. The components of the Town's annual OPEB cost for the year,the amount actually contributed to the plan, and changes in the Town's net OPEB obligation are summarized in the following table: Annual required contribution........................................ $ 12,441,414 Interest on net OPEB obligation.................................... 642,243 Adjustment to annual required contribution..................... (608,322) Annual OPEB Cost(expense)...................................... 12,475,335 Contributions made.................................................... (3,839,408) Increase in net OPEB obligation................................... 8,635,927 Net OPEB obligation-beginning of year......................... 14,272,077 Net OPEB obligation -end of year.................................$ 22,908,004 The Town's annual OPEB cost,the percentage of annual OPEB cost contributed to the plan, and the net OPEB obligation for fiscal year 2011 was as follows: Percentage of Fiscal Year Annual Annual OPEB Net OPEB Ended OPEB Cost Cost Contributed Obligation 6/30/2011 $ 12,475,335 31% $ 22,908,004 6/30/2010 11,632,440 33% 14,272,077 6/30/2009 10,964,622 36% 6,986,513 Funded Status and Funding Progress—As of July 1, 2010 the actuarial accrued liability for benefits was$118.6 million, all of which was unfunded. The covered payroll (annual payroll of active employees covered by the plan) was$39.3 million, and the ratio of the LIAAL to the covered payroll was 301.5 percent. Town of North Andover,Massachusetts 51 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 Actuarial valuations of an ongoing plan involve estimates of the value of reported amounts and assumptions about the probability of occurrence of events far into the future. Examples include assumptions about future employment, mortality, and the healthcare cost trend. Amounts determined regarding the funded status of the plan and the annual required contributions of the employer are subject to continual revision as actual results are compared with past expectations and new estimates are made about the future. The schedule of funding progress, presented as required supplementary information following the notes to the financial statements, presents multiyear trend information about whether the actuarial value of plan assets is increasing or decreasing over time relative to the actuarial accrued liabilities for benefits. Actuarial Methods and Assumptions—Projections of benefits for financial reporting purposes are based on the substantive plan (the plan as understood by the employer and the plan members) and include the types of benefits provided at the time of each valuation and the historical pattern of sharing of benefit costs between the employer and plan members to that point. The actuarial methods and assumptions used include techniques that are designed to reduce the effects of short-term volatility in actuarial accrued liabilities and the actuarial value of assets, consistent with the long-term perspective of the calculations. In the July 1, 2010 actuarial valuation, actuarial liabilities were determined using the projected unit credit cost method. The actuarial assumptions included a 4.5% investment return assumption, which is based on the expected yield on the assets of the Town, calculated based on the funded level of the plan at the valuation date, and an annual health care trend rate of 9.5% initially, graded to 5% over 9 years. The UAAL is being amortized with a level dollar amount over a 30 year period on an open basis. The remaining amortization period at June 30, 2011 is 30 years. NOTE 13—CONTINGENCIES The Town participates in a number of Federal award programs. These programs are subject to financial and compliance audits. The amount, if any, of expenditures which may be disallowed by the granting agencies cannot be determined at this time, although the Town expects such amounts, if any, to be immaterial. Various legal actions and claims are pending against the Town. Litigation is subject to many uncertainties, and the outcome of individual litigated matters is not always predictable. Although the amount of liability, if any, at June 30, 2011, cannot be ascertained, management believes any resulting liability should not materially affect the financial position of the Town at June 30, 2011. NOTE 14—IMPLEMENTATION OF NEW GASB PRONOUNCEMENTS During fiscal year 2011, the following GASB pronouncements were implemented: • GASB Statement#54, Fund Balance Reporting and Governmental Fund Type Definitions, was implemented in fiscal year 2011. Financial statements changes include new fund balance designations and the reclassification of stabilization funds from the special revenue fund to the general fund. The notes to the basic financial statements were changed to provide additional disclosure on the new designations of fund balance. • GASB Statement#59, Financial Instruments Omnibus,was implemented in fiscal year 2011 and did not impact the financial statements. Town of North Andover,Massachusetts 52 Basic Financial Statements Notes to Basic Financial Statements Fiscal Year Ended June 30 2011 Other Future GASB Pronouncements: • The GASB issued Statement#60,Accounting and Financial Reporting for Service Concession Arrangements,which is required to be implemented in fiscal year 2013. Management expects that the implementation of this pronouncement will have an impact on the basic financial statements. • The GASB issued Statement#61, The Financial Reporting Entity: Omnibus,which is required to be implemented in fiscal year 2013. Management's current assessment is that this pronouncement will not have a significant impact on the basic financial statements. • The GASB issued Statement#62, Codification of Accounting and Financial Reporting Guidance Contained in Pre-November30, 1989 FASB and AICPA Pronouncements, which is required to be implemented in fiscal year 2013. Management's current assessment is that this pronouncement will not have a significant impact on the basic financial statements. • The GASB issued Statement#63, Financial Reporting of Deferred Outflows of Resources, Deferred Inflows of Resources, and Net Position,which is required to be implemented in fiscal year 2013. Management's current assessment is that this pronouncement will have a significant impact on the basic financial statements. • The GASB issued Statement#64, Derivative Instruments:Application of Hedge Accounting Termination Provisions, an amendment of GASB Statement No. 53,which is required to be implemented in fiscal year 2012. Management's current assessment is that this pronouncement will not have a significant impact on the basic financial statements. Town of North Andover,Massachusetts 53 Basic Financial Statements Required Supplementary Information Town of North Andover,Massachusetts 54 Required Supplementary Information This page intentionally left blank. Town of North Andover,Massachusetts 55 Required Supplementary Information GENERALFUND SCHEDULE OF REVENUES,EXPENDITURES AND CHANGES IN FUND BALANCE- BUDGET AND ACTUAL FISCAL YEAR ENDED JUNE 30,2011 Budgeted Amounts Amounts Current Year Carried forward Initial Original Final From Prior Year Budget Budget Budget REVENUES: Real estate and personal property taxes, net of tax refunds.................................................. $ $ 58,258,340 $ 58,258,340 $ 58,258,340 Taxliens................................................................. - - - Motorvehicleandotherexcisetaxes............................ 3,522,184 3,522,184 3,522,184 Charges for services................................................. 790,000 790,000 790,000 Penalties and interest on taxes.................................... 350,152 350,152 350,152 Payments in lieu of taxes............................................ 1,754,759 1,754,759 1,754,759 Licenses and permits................................................ 173,000 173,000 173,000 Fines and forfeitures.................................................. 177,000 177,000 177,000 Intergovernmental..................................................... 8,867,453 8,867,453 8,867,453 Departmental and other............................................. 1,132,288 1,132,288 1,132,288 Investment income.................................................... 267,000 267,000 267,000 TOTAL REVENUES.......................................... 75,292,176 75,292,176 75,292,176 EXPENDITURES: Current: General government............................................. 71,694 3,376,962 3,448,656 3,082,841 Public safety........................................................ 17,337 8,923,401 8,940,738 8,787,010 Education............................................................ 102,544 37,348,253 37,450,797 37,440,797 Public works........................................................ 43,894 3,910,302 3,954,196 4,298,929 Health and human services.................................... 5,460 942,151 947,611 947,851 Culture and recreation........................................... 1,264 827,510 828,774 816,344 Pension benefits................................................... - 2,803,785 2,803,785 2,803,785 Property and liability insurance................................ - 300,641 300,641 293,688 Employee benefits................................................ 24,500 9,531,593 9,556,093 9,531,093 State and county charges........................................... - 2,101,820 2,101,820 2,068,403 Debt service: Principal............................................................. 5,574,681 5,574,681 5,574,681 Interest............................................................... - 1,337,978 1,337,978 1,337,978 TOTAL EXPENDITURES................................... 266,693 76,979,077 77,245,770 76,983,400 EXCESS(DEFICIENCY)OF REVENUES OVER EXPENDITURES............................................. (266,693) (1,686,901) (1,953,594) (1,691,224) OTHER FINANCING SOURCES(USES): Premium from issuance of bonds................................ - - - Transfers in............................................................. 1,322,517 1,322,517 1,322,517 Transfersout........................................................... - - (393,167) TOTAL OTHER FINANCING SOURCES(USES).... 1,322,517 1,322,517 929,350 NET CHANGE IN FUND BALANCE.................................. (266,693) (364,384) (631,077) (761,874) BUDGETARY FUND BALANCE,Beginning of year.............. 2,605,019 2,605,019 2,605,019 BUDGETARY FUND BALANCE,End of year...................... $ (266,693) $ 2,240,635 $ 1,973,942 $ 1,843,145 See notes to required supplementary information. Town of North Andover,Massachusetts 56 Required Supplementary Information Actual Amounts Variance Budgetary Carried Forward To Final Amounts To Next Year Budget $ 57,505,519 $ $ (752,821) 238,977 238,977 3,790,517 268,333 836,864 46,864 336,298 - (13,854) 1,731,968 (22,791) 220,650 47,650 113,167 (63,833) 8,926,529 - 59,076 1,271,902 139,614 313,836 46,836 75,286,227 (5,949) 2,866,154 64,770 151,917 8,620,394 12,798 153,818 37,357,213 43,885 39,699 4,156,778 58,587 83,564 938,863 - 8,988 813,611 636 2,097 2,803,785 - - 276,258 - 17,430 9,415,481 3,638 111,974 2,115,484 - (47,081) 5,574,681 1,337,978 - - 76,276,680 184,314 522,406 (990,453) (184,314) 516,457 127,464 127,464 1,322,517 - (378,167) 15,000 1,071,814 142,464 81,361 (184,314) 658,921 2,605,019 $ 2,686,380 $ (184,314) $ 658,921 Town of North Andover,Massachusetts 57 Required Supplementary Information Retirement System Schedules of Funding Progress and Employer Contributions The Retirement System Schedule of Funding Progress presents multiyear trend information about whether the actuarial value of planned assets is increasing or decreasing over time relative to the actuarial accrued liability for benefits. The Retirement System Schedule of Employer Contributions presents multiyear trend information for required and actual contributions relating to the cost-sharing plan as a whole, of which the Town is one participating employer, as well as the Town's proportionate share of the plan's annual contributions. Town of North Andover,Massachusetts 58 Required Supplementary Information ESSEX REGIONAL RETIREMENT SYSTEM SCHEDULE OF FUNDING PROGRESS Actuarial UAAL as a Actuarial Accrued Unfunded Percentage Actuarial Value of Liability(AAL) AAL Funded Covered of Covered Valuation Assets Entry Age (UAAL) Ratio Payroll Payroll Date (A) (B) (B-A) (A/B) (C) ((B-A)/C) 01/01/11 $ 278,332,006 $ 536,115,536 $ 257,783,530 51.9% $ 119,707,156 215.3% 01/01108 301,420,965 445,171,554 143,750,589 67.7% 111,726,856 128.7% 01/01/06 261,327,047 376,034,621 114,707,574 69.5% 98,641,094 116.3016 01/01/04 229,852,971 333,396,222 103,543,251 68.9% 93,404,002 110.9% 01101/02 218,346,198 287,390,715 69,044,517 76.0% 85,005,338 81.2% 01/01/00 190,363,700 253,847,100 63,483,400 75.0% 69,525,900 91.3% 01/01/99 180,034,700 268,386,000 88,351,300 67.1% 89,645,300 98.6% The Town's share of the UAAL, as of January 1,2011 is approximately 15%. See notes to required supplementary information. Town of North Andover,Massachusetts 59 Required Supplementary Information ESSEX REGIONAL RETIREMENT SYSTEM SCHEDULE OF EMPLOYER CONTRIBUTIONS System Wide Town of North Andover (B/A) Fiscal Year Annual (A) (B) Town's Percentage Ended Required Actual Percentage Actual of System Wide June 30 Contributions Contributions Contributed Contributions Actual Contributions 2011 $ 19,093,942 $ 19,093,942 100% $ 2,803,785 14.7% 2010 17,648,430 17,648,487 100% 2,596,530 14.7% 2009 15,601,671 15,601,671 100% 2,468,667 15.8% 2008 15,788,864 15,788,864 100% 2,261,142 14.3% 2007 16,622,274 16,622,274 100% 2,227,020 13.4% 2006 13,080,011 13,080,011 100% 2,181,588 16.7% 2005 12,223,776 12,223,776 100% 1,946,329 15.9% 2004 12,516,569 12,516,569 100% 1,693,461 13.5% The Town's Actual Contributions equaled 100% of its Required Contributions for each year presented. See notes to required supplementary information. Town of North Andover, Massachusetts 60 Required Supplementary Information Other Postemployment Benefit Plan Schedules The Schedule of Funding progress compares, over time, the actuarial accrued liability for benefits with the actuarial value of accumulated plan assets. The Schedule of Employer Contributions compares, overtime,the annual required contributions to the actual contributions made. The Schedule of Actuarial Methods and Assumptions presents factors that significantly affect the identification of trends in the amounts reported. Town of North Andover,Massachusetts 61 Required Supplementary Information OTHER POSTEMPLOYMENT BENEFIT PLAN SCHEDULE OF FUNDING PROGRESS AND SCHEDULE OF EMPLOYER CONTRIBUTIONS Schedule of Funding Progress Actuarial Accrued UAAL as a Actuarial Liability(AAL) Unfunded Percentage Actuarial Value of Projected AAL Funded Covered of Covered Valuation Assets Unit Credit (UAAL) Ratio Payroll Payroll Date (A) (B) (B-A) (A/B) (C) ((B-A)/C) 07/01/10 $ - $ 118,595,377 $ 118,595,377 0.0% $ 39,329,676 301.5% 07/01108 - 125,963,157 125,963,157 0.0% 39,189,469 321.4% Schedule of Employer Contributions Annual Actual Fiscal Year Required Contributions Percentage Ended Contribution Made Contributed 6/30/11 $ 12,441,414 $ 3,839,408 30.9% 6/30/10 11,241,110 4,346,876 38.7% 6/30/09 10,964,622 3,978,109 36.3% I See notes to required supplementary information. I i i I II I Town of North Andover,Massachusetts 62 Required Supplementary Information OTHER POSTEMPLOYMENT BENEFIT PLAN ACTUARIAL METHODS AND ASSUMPTIONS Actuarial Methods: Valuation date..................... .. . ........................... July 1, 2010 Actuarial cost method.......................I................. Projected Unit Credit Amortization method.......................................... Level dollar amount over thirty years based on an open group, open basis Remaining amortization period............................. 30 years Actuarial Assumptions: Investment rate of return..................................... 4.5% Plan Membership: Current retirees, beneficiaries, and dependents....... 417 Current active members...................................... 1,060 Total 1,477 See notes to required supplementary information. I I I i Town of North Andover, Massachusetts 63 Required Supplementary Information Notes to Required Supplementary Information Fiscal Year Ended June 30. 2011 NOTE A-STEWARDSHIP, COMPLIANCE AND ACCOUNTABILITY 1. Budgetary Information Municipal Law requires the Town to adopt a balanced budget that is approved by Town Meeting. The Finance Committee presents an annual budget to Town Meeting, which includes estimates of revenues and other financing sources and recommendations of expenditures and other financing uses. Town Meeting, which has full authority to amend and/or reject the budget or any individual line item, adopts the expenditure budget by majority vote. Increases or transfers between departments subsequent to the approval of the annual budget, requires majority Town Meeting approval via a supplemental appropriation. The majority of the Town's appropriations are non-continuing which lapse at the end of each fiscal year. Others are continuing appropriations for which the governing body has authorized that an unspent balance from a prior fiscal year be carried forward and made available for spending in the current fiscal year. These carry forwards are included as part of the subsequent fiscal year's original budget. Generally, expenditures may not exceed the legal level of spending authorized for an appropriation account. However, the Town is statutorily required to pay debt service, regardless of whether such amounts are appropriated. Additionally, expenditures for disasters, natural or otherwise, and final judgments may exceed the level of spending authorized by majority vote of the Town Meeting. The Town adopts an annual budget for the General Fund in conformity with the guidelines described above. The original fiscal year 2011 approved budget for the General Fund authorized approximately$77.3 million in appropriations and other amounts to be raised. The$131,000 increase between the original budget and final budget was due to a$373,000 supplemental transfer to the stabilization fund that was funded by a$100,000 reserve fund transfer and $273,000 of free cash. This resulted in a net increase of$273,000, which was offset by budget cuts totaling $109,000 and a reduction in state assessments totaling $33,000. The Town Accountant's office has the responsibility to ensure that budgetary control is maintained on an individual line item appropriation account basis. Budgetary control is exercised through the Town's accounting system. 2. Budgetary-GAAP Reconciliation For budgetary financial reporting purposes, the Uniform Municipal Accounting System basis of accounting (established by the Commonwealth of Massachusetts) is followed,which differs from the GAAP basis of accounting. A reconciliation of budgetary-basis to GAAP-basis results for the General Fund for the fiscal year ended June 30, 2011, is presented below: Net change in fund balance-budgetary basis.............................................. $ 81,361 Perspective difference: Activity of the stabilization fund recorded in the general fund for GAAP......................................................................... 424,245 I Basis of accounting differences: Net change in recording 60 day receipts................................................... (46,766) Net change in recording tax refunds payable............................................. (35,000) Recognition of revenue for on-behalf payments.......................................... 6,733,723 Recognition of expenditures for on-behalf payments.................................... (6,733,723) Net change in fund balance-gaap basis.................................................... $ 423,840 Town of North Andover,Massachusetts 64 Required Supplementary Information Notes to Required Supplementary Information Fiscal Year Ended June 30 2011 3. Excess of Expenditures over Appropriations During fiscal year 2011, expenditures exceeded budgeted appropriations for state&county charges. These amounts will be raised on the fiscal 2012 Tax Recapitulation. NOTE B—PENSION PLAN The following actuarial methods and assumptions were used in the Retirement System's most recent actuarial valuation: Actuarial Methods and Assumptions: Valuation Date.........................................January 1,2008 Actuarial Cost Method............................... Entry Age Normal Cost Method Amortization Method................................. Increasing at 4.5%per year, level.dollar for ERI liability for certain units Remaining Amortization Period................... 19 years remaining as of July 1,2009 Asset Valuation Method.............................A preliminary actuarial value is first determined by taking the actuarial value of assets at the beginning of the year and adding assumed investment earnings(at the assumed actuarial rate fo return)and the net new money during the year(contributions less benefit payments and administrative expenses). 20%of the difference between the market value of assets and the preliminary actuarial value is added to the preliminary actuarial value. In order that the actuarial value not differ too significantly from the market value of assets,the final actuarial value of assets must be within 20%of the market value of assets. Actuarial Assumptions: Investment rate of return.......................... 8.50% Projected salary increases........................5.00% Cost of living adjustments.........................3.0%of first$12,000 of retirement income. Plan Membership: Retired participants and beneficiaries receiving benefits.......................... 1,568 Inactive participants...................................................................................... 880 Disabled.................................................................................................... 65 Active participants........................................................................... 3,139 Total............................................................................................ 5,652 NOTE C—OTHER POSTEMPLOYMENT BENEFITS PLAN The Town administers a single-employer defined benefit healthcare plan ("The Retiree Health Plan"). The plan provides lifetime healthcare insurance for eligible retirees and their spouses through the Town's group health insurance plan,which covers both active and retired members. Additionally, retired teachers and their spouses receive health insurance through the Group Insurance Commission of the Commonwealth of Massachusetts (GIC). Each participating municipality is assessed for the governmental share of health and life insurance premiums paid on behalf of its teacher retirees by the state. The Town currently finances its other postemployment benefits (OPEB) on a pay-as-you-go basis. As a result, the funded ratio(actuarial value of assets expressed as a percentage of the actuarial accrued liability) is 0%. In accordance with Governmental Accounting Standards, the Town has recorded its OPEB cost equal to the actuarially determined annual required contribution (ARC)which includes the normal cost of providing benefits for the year and a component for the amortization of the total unfunded actuarial accrued liability of the plan. Town of North Andover,Massachusetts 65 Required Supplementary information Notes to Required Suoolementary Information Fiscal Year Ended June 30. 2011 The Schedule of Funding Progress presents multi-year trend information which compares, overtime, the actuarial accrued liability for benefits with the actuarial value of accumulated plan assets. The Schedule of Employer Contributions compares, overtime, the annual required contributions to the actual contributions made. Projections of benefits for financial reporting purposes are based on the substantive plan and include the types of benefits provided at the time of each valuation and the historical pattern of sharing of benefit costs between the employer and plan members to that point. The actuarial methods and assumptions used include techniques that are designed to reduce the effects of short-term volatility in actuarial accrued liabilities and the actuarial value of assets, consistent with the long-term perspective of the calculations. The Schedule of Actuarial Methods and Assumptions presents factors that significantly affect the identification of trends in the amounts reported. Town of North Andover,Massachusetts 66 Required Supplementary Information Additional Information Town of North Andover,Massachusetts 67 Additional Information I ENTERPRISE FUND SCHEDULE OF REVENUES,EXPENSES AND CHANGES IN FUND NET ASSETS BUDGETARY BASIS-BUDGET AND ACTUAL FISCAL YEAR ENDED JUNE 30,2011 Water Fund Amounts Actual Carried Variance Original Final Budgetary Forward To To Final Budget Budget Amounts Next Year Budget OPERATING REVENUES: Charges for services........................................................................ $ 5,349,752 $ 5,349,752 $ 5,765,416 $ $ 415,664 Penalties and interest........................................................................ 22,000 22,000 23,113 1,113 TOTAL OPERATING REVENUES.................................................. 5,371,752 5,371,752 5,788,529 416,777 OPERATING EXPENSES: Cost of service and administration....................................................... 1,983,867 1,983,867 1,745,906 52,076 185,885 GLDS assessment............................................................................ - TOTAL OPERATING EXPENSES.................................................. 1,983,867 1,983,867 1,745,906 52,076 185,885 OPERATING INCOME(LOSS)....................................................... 3,387,885 3,387,885 4,042,623 (52,076) 602,662 NONOPERATING REVENUES(EXPENSES): Investment income........................................................................... 1,500 1,500 8,779 7,279 Interest expense.............................................................................. (420,830) (420,830) (414,308) 6,522 Debt service-principal...................................................................... (2,370,448) (2,370,448) (2,370,448) - TOTAL NONOPERATING REVENUES(EXPENSES),NET.................................................... (2,789,778) (2,789,778) (2,775,977) 13,801 INCOME(LOSS)BEFORE TRANSFERS......................................... 598,107 598,107 1,266,646 (52,076) 616,463 TRANSFERS: Transfersin.................................................................................... - - - - Transfers out................................................................................... (658,016) (658,016) (640,999) 17,017 TOTAL OPERATING TRANSFERS................................................. (658,016) (658,016) (640,999) 17,017 CHANGE IN NET ASSETS............................................................ (59,909) (59,909) 625,647 (52,076) 633,480 NET ASSETS AT BEGINNING OF YEAR.................................................. 178,916 178,916 178,916 - NET ASSETS AT END OF YEAR............................................................ $ 119,007 $ 119,007 $ 804,563 $ (52,076) $ 633,480 Town of North Andover,Massachusetts 68 Additional Information Sewer Fund Osgood Hill Fund Amounts Amounts Actual Carried Variance Actual Carried Variance Original Final Budgetary Forward To To Final Original Final Budgetary Forward To To Final Budget Budget Amounts Next Year Budget Budget Budget Amounts Next Year Budget $ 5,026,817 $ 5,026,817 $ 4,842,333 $ $ (184,484) $ 293,184 $ 293,184 $ 239,200 $ $ (53,984) 20,000 20,000 24,519 4,519 5,046,817 5,046,817 4,866,852 (179,965) 293,184 293,184 239,200 (53,984) 915,698 915,698 892,413 933 22,352 256,882 244,087 242,955 189 943 1,642,900 1,642,900 1,428,879 214,021 2,558,598 2,558,598 2,321,292 933 236,373 256,882 244,087 242,955 189 943 2,488,219 2,488,219 2,545,560 (933) 56,408 36,302 49,097 (3,755) (189) (53,041) 3,000 3,000 4,937 - 1,937 - - - (485,804) (485,804) (485,804) - (1,585,278) (1,585,278) (1,585,278) (2,068,082) (2,068,082) (2,066,145) 1,937 - 420,137 420,137 479,415 (933) 58,345 36,302 49,097 (3,755) (189) (53,041) - - - - - - - 5,000 - 5,000 (422,161) (422,161) (422,161) 4( 6,460) 4( 6,460) (46,460) - (422,161) (422,161) (422,161) 46,460 46,460 (41,460) 5,000 i (2,024) (2,024) 57,254 (933) 58,345 (10,158) 2,637 (45,215) (189) (48,041) 376,288 376,288 376,288 47,399 47,399 47,399 $ 374,264 $ 374,264 $ 433,542 $ (933) $ 58,345 $ 37,241 $ 50,036 $ 2,184 $ (189) $ (48,041) i II I Town of North Andover,Massachusetts 69 Additional information Sewer Fund Osgood Hill Fund Amounts Amounts Actual Carried Variance Actual Carried Variance Original Final Budgetary Forward To To Final Original Final Budgetary Forward To To Final Budget Budget Amounts Next Year Budget Budget Budget Amounts Next Year Budget $ 5,026,817 $ 5,026,817 $ 4,842,333 $ $ (184,484) $ 293,184 $ 293,184 $ 239,200 $ $ (53,984) 20,000 20,000 24,519 4,519 - 5,046,817 5,046,817 4,866,852 (179,965) 293,184 293,184 239,200 (53,984) 915,698 915,698 892,413 933 22,352 256,882 244,087 242,955 189 943 1,642,900 1,642,900 1,428,879 214,021 - - - 2,558,598 2,558,598 2,321,292 933 236,373 256,882 244,087 242,955 189 943 2,488,219 2,488,219 2,545,560 (933) 56,408 36,302 49,097 (3,755) (189) (53,041) 3,000 3,000 4,937 - 1,937 - - - (485,804) (485,804) (485,804) - (1,585,278) (1,585,278) (1,585,278) - (2,068,082) (2,068,082) (2,066,145) 1,937 - 420,137 420,137 479,415 (933) 58,345 36,302 49,097 (3,755) (189) (53,041) i 5,000 5,000 (422,161) (422,161) (422,161) 4( 6,460) 46,460 (46,460) - (422,161) (422,161) (422,161) 4( 6,460) 4( 6,460) (41,460) - 5,000 (2,024) (2,024) 57,254 (933) 58,345 (10,158) 2,637 (45,215) (189) (48,041) 376,288 376,288 376,288 47,399 47,399 47,399 $ 374,264 $ 374,264 $ 433,542 $ (933) $ 58,345 $ 37,241 $ 50,036 $ 2,184 $ (189) $ (48,041) I Town of North Andover,Massachusetts 69 Additional Information L TOWN OF NORTH ANDOVER, MASSACHUSETTS REPORTS ON FEDERAL AWARD PROGRAMS FISCAL YEAR ENDED JUNE 30, 2011 i I TOWN OF NORTH ANDOVER, MASSACHUSETTS REPORTS ON FEDERAL AWARD PROGRAMS FISCAL YEAR ENDED JUNE 30, 2011 TABLE OF CONTENTS PAGE Report on internal control over financial reporting and on compliance and other matters based on an audit of financial statements performed in accordance with Government Auditing Standards. 1 Report on compliance with requirements that could have a direct and material effect on each major program and on internal control over compliance in accordance with OMB Circular A-133 3 Schedule of expenditures of federal awards 5 Notes to schedule of expenditures of federal awards 6 Schedule of findings and questioned costs 7 REPORT ON INTERNAL CONTROL OVER FINANCIAL REPORTING 100 Quannapowitt Parkway Suite 101 AND ON COMPLIANCE AND OTHER MATTERS BASED ON AN AUDIT Wakefield,NfA,01880 OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH T.781-914-1700 GOVERNMENT AUDITING STANDARDS F.781-914-1701 www.powersandsuHivan.com To the Honorable Board of Selectmen Town of North Andover, Massachusetts We have audited the financial statements of the governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information of the Town of North Andover, Massachusetts, as of and for the fiscal year ended June 30, 2011, which collectively comprise the Town of North Andover, Massachusetts' basic financial statements and have issued our report thereon dated December 19, 2011. We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Internal Control Over Financial Reporting In planning and performing our audit,we considered the Town of North Andover, Massachusetts' internal control over financial reporting as a basis for designing our auditing procedures for the purpose of expressing our opinions on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of the Town of North Andover, Massachusetts' internal control over financial reporting. Accordingly, we do not express an opinion on the effectiveness of the Town of North Andover, Massachusetts' internal control over financial reporting. A deficiency in internal control exists when the design or operation of a control does not allow management or employees, in the normal course of performing their assigned functions, to prevent or detect and correct misstatements on a timely basis. A material weakness is a deficiency, or combination of deficiencies, in internal control, such that there is a reasonable possibility that a material misstatement of the entity's financial statements will not be prevented, or detected and corrected in a timely basis, Our consideration of the internal control over financial reporting was for the limited purpose described in the first paragraph of this section and would not necessarily identify all deficiencies in internal control that might be deficiencies, significant deficiencies or material weaknesses. We did not identify any deficiencies in internal control over financial reporting that we consider material weaknesses, as defined above. Compliance and Other Matters As part of obtaining reasonable assurance about whether the Town of North Andover, Massachusetts'financial statements are free of material misstatement,we performed tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements, noncompliance with which could have a direct and material effect on the determination of financial statement amounts. However, providing an opinion on compliance with those provisions was not an objective of our audit, and accordingly, we do not express such an opinion. The results of our tests disclosed no instances of noncompliance or other matters that are required to be reported under Government Auditing Standards. 1 We noted certain other matters that we reported to management of the Town of North Andover, Massachusetts in a separate letter dated December 19, 2011. This report is intended solely for the information and use of management,the Board of Selectmen, others within the entity, and federal awarding agencies and pass-through entities and is not intended to be and should not be used by anyone other than these specified parties. December 19, 2011 2 Powers & Sullivan, LLC Certified Pti lic traotiat-hats 100 Quannapowitt Parkway REPORT ON COMPLIANCE WITH REQUIREMENTS THAT Suite 101 COULD HAVE A DIRECT AND MATERIAL EFFECT ON EACH Wakefield,MA 01880 MAJOR PROGRAM AND ON INTERNAL CONTROL OVER T.781-914-1700 COMPLIANCE IN ACCORDANCE WITH OMB CIRCULAR A-133 F.781-914-1701 www.powersaridsullivan.com To the Honorable Board of Selectmen Town of North Andover, Massachusetts Compliance We have audited the compliance of the Town of North Andover, Massachusetts, with the types of compliance requirements described in the U.S. Office of Management and Budget(OMB) Circular A-133 Compliance Supplement that could have a direct and material effect on each of the Town's major federal programs for the fiscal year ended June 30,2011. The Town of North Andover, Massachusetts' major federal programs are identified in the summary of auditors' results section of the accompanying schedule of findings and questioned costs. Compliance with the requirements of laws, regulations, contracts and grants applicable to each of its major federal programs is the responsibility of the Town of North Andover, Massachusetts' management. Our responsibility is to express an opinion on the Town of North Andover, Massachusetts' compliance based on our audit. We conducted our audit of compliance in accordance with auditing standards generally accepted in the United States of America; the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States; and OMB CircularA-133,Audits of States, Local Governments, and Non-Profit Organizations. Those standards and OMB Circular A-133 require that we plan and perform the audit to obtain reasonable assurance about whether noncompliance with the types of compliance requirements referred to above that could have a direct and material effect on a major federal program occurred. An audit includes examining, on a test basis, evidence about the Town of North Andover, Massachusetts' compliance with those requirements and performing such other procedures as we considered necessary in the circumstances. We believe that our audit provides a reasonable basis for our opinion. Our audit does not provide a legal determination of the Town of North Andover, Massachusetts' compliance with those requirements. In our opinion,the Town of North Andover, Massachusetts, complied, in all material respects, with the requirements referred to above that could have a direct and material effect on each of its major federal programs for the fiscal year ended June 30, 2011. Internal Control Over Compliance Management of the Town of North Andover, Massachusetts is responsible for establishing and maintaining effective internal control over compliance with the requirements of laws, regulations, contracts, and grants applicable to federal programs. In planning and performing our audit, we considered the Town of North Andover, Massachusetts' internal control over compliance with the requirements that could have a direct and material effect on a major federal program in order to determine our auditing procedures for the purpose of expressing our opinion on compliance, but not for the purpose of expressing an opinion on the effectiveness of internal control over compliance. Accordingly, we do not express an opinion on the effectiveness of the Town of North Andover, Massachusetts' internal control over compliance. 3 A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of performing their assigned functions, to prevent, detect, and correct, noncompliance with a type of compliance requirement of a federal program on a timely basis. A material weakness in internal control over compliance is a deficiency, or combination of deficiencies, in internal control over compliance, such that there is a reasonable possibility that material noncompliance with a type of compliance requirement of a federal program will not be prevented, or detected and corrected, on a timely basis. Our consideration of the internal control over compliance was for the limited purpose described in the first paragraph of this section and was not designed to identify all deficiencies in internal control over compliance that might be deficiencies, significant deficiencies, or material weaknesses. We did not identify any deficiencies in internal control over compliance that we consider to be material weaknesses, as defined above. Schedule of Expenditures of Federal Awards We have audited the financial statements of the governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information of the Town of North Andover, Massachusetts as of and for the fiscal year ended June 30, 2011, and have issued our report thereon dated December 19, 2011. Our audit was performed for the purpose of forming our opinions on the financial statements that collectively comprise the Town of North Andover, Massachusetts', basic financial statements. The accompanying schedule of expenditures of federal awards is presented for purposes of additional analysis as required by OMB Circular A- 133 and is not a required part of the basic financial statements. Such information has been subjected to the auditing procedures applied in the audit of the basic financial statements and, in our opinion, is fairly stated, in all material respects, in relation to the basic financial statements taken as a whole. This report is intended solely for the information and use of management, the Board of Selectmen, others within the entity, and federal awarding agencies and pass-through entities and is not intended to be and should not be used by anyone other than these specified parties. December 19, 2011 4 SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS FOR THE FISCAL YEAR ENDED JUNE 30, 2011 Federal CFDA Federal Grantor/Program Title Number Expenditures U.S. DEPARTMENT OF AGRICULTURE: Passed through Massachusetts Department of Elementary and Secondary Education: Non-Cash Assistance(Commodities): National School Lunch Program 10.555 $ 42,282 Cash Assistance: School Breakfast Program 10.553 40,141 National School Lunch Program 10.555 307,548 TOTAL AGRICULTURE 389,971 U.S. DEPARTMENT OF ENERGY: Passed through Massachusetts Department of Energy Resources: ARRA-Energy Efficiency and Conservation Block Grant Program 81.128 103,845 U.S. DEPARTMENT OF EDUCATION: Passed through Massachusetts Department of Elementary and Secondary Education: Title I Grants to Local Educational Agencies 84.010 205,780 Special Education Grants to States 84.027 1,051,348 Safe and Drug Free Schools and Communities State Grants(A) 84.186 8,997 Fund for the Improvement of Education 84.215 137,146 Improving Teacher Quality State Grants 84.367 87,389 ARRA-Title I Grants to Local Educational Agencies 84.389 146,349 ARRA-Special Education-Grants to States 84.391 722,243 ARRA-State Fiscal Stabilization Fund-Education State Grants 84.394 627,388 ARRA-Race to the Top 84.395 4,114 Passed through Massachusetts Department of Early Education and Care: Special Education-Preschool Grants 84.173 27,821 ARRA-Special Education-Preschool Grants 84.392 27,093 TOTAL EDUCATION 3,045,668 CORPORATION FOR NATIONAL AND COMMUNITY SERVICE: Direct Program: Learn and Serve America School and Community Based Programs 94.004 2,500 SOCIAL SECURTIY ADMINISTRATION: Passed through Massachusetts Rehabilitation Commission: Social Security Disability Insurance 96.001 250 U.S. DEPARTMENT OF HOMELAND SECURITY: Passed through the State Office of Emergency Management: Public Assistance Grants 97.036 89,197 TOTAL $ 3,631,431 See notes to schedule of expenditures of federal awards. Town of North Andover,Massachusetts 5 Reports on Federal Award Programs Notes to Schedule of Expenditures of Federal Awards Fiscal Year Ended June 30. 2011 Note 1 -Definition of Reporting Entity The accompanying Schedule of Expenditures of Federal Awards presents the activity of all federal financial assistance programs of the Town of North Andover, Massachusetts. All federal financial assistance received directly from federal agencies as well as federal financial assistance passed through other governmental agencies is included on the schedule. Note 2-Significant Accounting Policies The accounting and reporting policies of the Town of North Andover, Massachusetts, are set forth below: (a) Basis of Presentation -The accompanying Schedule of Expenditures of Federal Awards is presented on the modified accrual basis of accounting. Accordingly, expenditures are recognized when the liability is incurred. (b) Cash Assistance-School Breakfast and Lunch Program-Program expenditures represent federal reimbursement for meals provided during the fiscal year. (c) Non-Cash Assistance(Commodities)—School Lunch Program—Program expenditures represent the value of donated foods received during the fiscal year. (d) Public Assistance Grants—Program expenditures represent federal reimbursement received during the fiscal year. Note 3—Program Clusters In accordance with Subpart A§_105 of OMB Circular No.A-133, Audits of States, Local Governments and Non Profit Organizations, certain programs have been clustered in determining major programs. The following represents the clustered programs: CFDA Name of Cluster/Program Number Child Nutrition Cluster School Breakfast Program 10.553 National School Lunch Program 10.555 Title I Cluster Title I Grants to Local Educational Agencies 84.010 ARRA-Title I Grants to Local Educational Agencies 84.389 Special Education Cluster Special Education Grants to States 84.027 Special Education Preschool Grants 84.173 ARRA-Special Education-Grants to States 84.391 ARRA-Special Education-Preschool Grants 84.392 Town of North Andover, Massachusetts 6 Reports on Federal Award Programs Schedule of Findings and Questioned Costs Fiscal Year Ended June 30 2011 A. Summary of Auditors' Results 1. The auditors' report expresses an unqualified opinion on the financial statements of the Town of North Andover, Massachusetts. 2. No significant deficiencies relating to the audit of the financial statements are reported in the Report on Internal Control over Financial Reporting and on Compliance and Other Matters Based on an Audit of Financial Statements Performed in Accordance with Government Auditing Standards. 3. No instances of noncompliance material to the financial statements of the Town of North Andover, Massachusetts, were disclosed during the audit. 4. No significant deficiencies relating to the audit of the major federal award programs is reported in the Report on Compliance with Requirements that Could Have a Direct and Material Effect on Each Major Program and on Internal Control Over Compliance in Accordance with OMB Circular A-133. 5. The auditors' report on compliance for the major federal award programs for the Town of North Andover, Massachusetts, expresses an unqualified opinion. 6. No audit findings were required to be reported in accordance with Section 510(a)of OMB Circular A-1 33. 7. The programs tested as major programs include: CFDA Program Title Number Title I Grants to Local Educational Agencies 84.010 Special Education Grants to States 84.027 Special Education Preschool Grants 84.173 ARRA-Title I Grants to Local Educational Agencies 84.389 ARRA-Special Education-Grants to States 84.391 ARRA-Special Education-Preschool Grants 84.392 ARRA-State Fiscal Stabilization Fund-Education State Grants 84.394 8. The threshold for distinguishing Types A and B programs was$300,000. 9. The Town of North Andover, Massachusetts was determined to be a low-risk auditee. B. Findings-Financial Statements Audit None. C. Finding and Questioned Costs—Major Federal Award Programs None D. Prior Fiscal Year Audit Findings and Questioned Costs None Town of North Andover, Massachusetts 7 Reports on Federal Award Programs ci 'a= az �9�v�c .�a�ziarotcc O6.sewa�inra �oaem�lle� ,� ��`�� ;� n, (97dJ 682 6374 Date: April 6, 2012 To: North Andover Board of Selectmen Via: Andrew Maylor, Town Manager CC: Division Director, Ray Santilli Director of Public Works Bruce Thibodeau North Andover Police Department, Chief Rick Stanley North Andover Fire Department, Chief Andrew Melnikas Subject: Request to Conduct Memorial Day Parade & Ceremony Ladies and Gentlemen: The North Andover Patriotic Observance &Marching Committee respectfully requests permission to conduct an appropriate Parade and Ceremonial Service in recognition of Memorial Day, May 28th 2012. We respectfully request your approval of having the Memorial Day Parade form at 10:00 A.M on Monday May 30th, on the West side of Center Common(Osgood&Andover St.). The parade will then go right onto Mass Ave and then head left onto Salem Street with the Parade ending at the Ridgewood Cemetery for the appropriate ceremony. Upon completion of our Memorial Ceremony,the Parade will reform and proceed back to the Center Common and disperse from there. A small contingency will form at the V.F.W. Post 2104 on Park Street for the ceremonial Flag Raising and reception. In the event of inclement weather, our services will be held in the Middle School Veteran's Auditorium at 10:30A.M. For additional information please contact Edward V. Mitchell at(978) 688-9525. Respectfully, Chief Edward V. Mitchell,US Navy(Ret) 99--1 Chairmen, Patriotic Observance &Marching Committee INTEROFFICE MEMORANDUM DATE: April 17,2012 TO: Adele Johnson, Administrative Secretary FROM: Bruce Thibodeau, Director of Public Works CC: RE: Request to Conduct Memorial Day,Parade &,Ceremony The Division of Public Works has no objection to the request from Chief Edward V. Mitchell from the North Andover Patriotic Observance & Marching Committee to conduct the Memorial Day Parade & Ceremony. TOWN OF NORTH ANDOVER, MASSACHUSETTS r Police Department 1475 Osgood Street North Andover, MA. 01845 Tel:978-683-3168 To: Adele Johnson,Administrative Secretary From: Lt.John Carney RE: Memorial Day Parade Date: April 11, 2012 The Police Department recommends favorable action on the request from Ed Mitchell to hold the annual Memorial Day Parade on May 28th. The Police Department will provide the normal support. i Johnson, Adele From: McCarthy, Fred Sent: Thursday, April 19, 2012 4:12 PM To: Johnson, Adele Subject: RE: Need recommendations for Memorial Day Parade Adele, The Fire Department recommends favorable action for the Memorial Day Parade. Our only request is to be updated just prior to the start of road closures and detours. Regards Lt Fred McCarthy Fire Prevention 978-688-9590 From: Johnson, Adele Sent: Tuesday, April 17, 2012 3:28 PM To:Thibodeau, Bruce; Barry, Nancy; Carney, John; Gallagher, Paul; Melnikas, Andrew; McCarthy, Fred Subject: FW: Need recommendations for Memorial Day Parade Please send me your recommendation by Thursday,4/19/12. Thanks, Adele J.Johnson Adminstrative Secretary Town of North Andover 120 Main Street North Andover, MA 01845 Phone 978.688.9510 Fax 978.688.9556 Email as iohnson @townofnorthandover.com Web www,TownofNorthAndover.com From: noreply townofnorthandover.com [mai Ito:noreply(atownofnorthandover.corn l Sent: Tuesday, April 17, 2012 3:26 PM To: Johnson, Adele Subject: Please notf the U.,issachusetts,Secretary of State's office has determined that most ernaiis to and frC]m€ ti I 4Jpzli offices and rofid3is Pare;public records,For rn are infomiat.ion please refer to:hftp://www,see.state.ma.us/pre/preidx.htm. 1 a I �4 ffir _---.-= .- To: Ray Santilli,Assistant Town Manager STEVENS From: Mary Rose Quinn,Library Director E OPUA , Re: Donation from Sisters In Crime LIBRA 'y Date: April 19, 2012 The Stevens Memorial Library received two donations: one from the local Sisters In Crime (Internet Chapter), a national mystery writers organization for$3,475.26 and from Kathy Phillips, chapter member for$1,600. The Library requests that the No. Board of Selectmen accept these gifts on behalf of the Town. X13=;5-6�J� 'd 9176-61881950s The donations will be used to purchase mysteries for the collection and to develop programming promoting mystery book discussions and mystery author visits at the srt_�rdl qr Library. msm!z .JC.o,' In order to streamline the purchases anticipated as a result of these gifts,we would ask that the Town establish a town account for these and similar Library donations. Please let me know if you have any questions. I TOWN OF NORTH ANDOVER 2012 ANNUAL TOWN MEETING WARRANT ARTICLES AS OF APRIL 23,2012 Alpha Num. Article Title Sponsor Board of Selectmen Finance Committee Planning Board A Reports of5pecial Committees Board of Selectmen B Reports of Receipts and Expenditures Board of Selectmen C Authorization of the Town Manager or Superintendant of Schools Regarding Board of Selectmen Contracts in Excess of Three Years D Authorization to Accept Grants of Easements Board of Selectmen E Authorization to Grant Easements Board of Selectmen F Compensation of Elected Officials Board of Selectmen G Prior Year Unpaid Bills Board of Selectmen H Establishment of Revolving Funds Board of Selectmen I Continuation of MGL,Chapter 59,Section 5K,Senior Work Program-Funding Council on Aging J Amend General Fund Appropriation for FY12 Board of Selectmen K Amend Water Fund Appropriation for FY12 Board of Selectmen L Amend Sewer Fund Appropriation for FY12 Board of Selectmen M Amend Stevens Estate at Osgood Hill Enterprise Fund Appropriation for FY12 Board of Selectmen N lAmend Capital Plan Appropriations from Prior Years Board of Selectmen 0 General Fund Appropriation Fiscal Year 2013 Board of Selectmen P Water Enterprise Fund Appropriation Fiscal Year 2013 Board of Selectmen Q Sewer Enterprise Fund Appropriation Fiscal Year 2013 Board of Selectmen - R Stevens Estate at Osgood Hill Enterprise Fund Appropriation Fiscal Year 2013 Board of Selectmen 5 Capital Improvement Plan Appropriation Fiscal Year 2013 Board of Selectmen -- T Report ofthe Community Preservation Committee and Appropriation Board of Selectmen U Appropriation from Federal Early Retirement Reinsurance Program Board of Selectmen V ISale of Public Buildings Town Manager W Capital Stabilization Account Town Manager X Energy Services Company Project Funding Town Manager Y Finger Print Based Criminal Record Background Checks Town Manager Z Reduction of Community Preservation Act Surcharge CP-William Callahan AA Amend Chapter 69-7.1 ofthe Town Bylaws Fire Chief AB Amend Chapter 28.3 ofthe Town Bylaws Board of Selectmen AC I Petition the General Court-Liquor Quota Increase-LaBottega-Turnpike St. CP-Angela Paolini AD Petition the General Court-Amend Town Charter-Change Election to June CP-George Vozeolas AE Petition the General Court-Amend Town Charter Town Meeting Proceedures Town Clerk AF Amend General Bylaws-Chapter 59-6-Annual Town Meeting Date Town Clerk AG Amend General Bylaws-Add Chapter 174-Trees DPW AH Amend Zoning Bylaw-Section 8.1.4-Off Street Parking General Requirements Planning Board AI Amend Zoning Bylaw-Section 4.137-Floodplain District Planning Board Al Amend Zoning Bylaw-Section 4.135-Industrial S-Added Use Planning Board AK Amend Zoning Map-1080 Osgood Street-Map3S Parcel 19 from 12 to B-2 Planning Board AL Transfer to Stabilization Board of Selectmen AM Transfer to OPEB Stabilization Board of Selectmen AN Change Time of Elected Officials Assuming Office(Henry Fink Proposal) Board of Selectmen AO lAdopt Provisions of MGL Chapter 60,Section 3D-Elderly Disabled Tax Fund Town Manager AP Rescind MGL c.31,section 47-DPW labor civil service Town Manager AC, Amend CPA BAN Authorization Town Manager AR Amend Zoning Bylaw-Section 16.5 Drive Through in CDD2 Board of Selectmen MASTER LIST-2012 ANNUAL TOWN MEETING-MARCH 28 20125heetl4/19/201212:37 PM TOWN OF NORTH ANDOVER OFFICE OF TOWN CLERK 120 MAIN STREET NORTH ANDOVER, MASSACHUSETTS 01845 f pORTH 1 Joyce A. Bradshaw, CMMC Telephone(978)688-9501 Town Clerk, x � FAX(978)688-9557 9SSgCHusEc MEMORANDUM TO: Rosemary Connelly Smedile, Chairman, Licensing Comm. Members of the Board of Selectmen Andrew Maylor, Town Manager FROM: Karen A. Fitzgibbons, Asst. Town Clerk DATE: April 17, 20I2 SUBJECT: One Day Wine & Malt License Attached please find an application from Sue Zeytoonian, Manager, Camelot, 505 Sutton Street, requesting a One Day Wine & Malt License. The event is for the King Pins Car Show to be held on Sunday, May 6, 2012 from 10:00 a.m. to 7:00 p.m. Favorable recommendations, with some stipulations, are included from the North Andover Building Inspector, Police Department and Fire Department. Ms. Zeytoonian has been made aware of these stipulations and if the Board so directs I can include them in the license. If you have any questions or concerns, please do not hesitate to contact me or Joyce Bradshaw. Thank you. March 25, 2012 To whom it may concern: I am requesting a one day beer and wine license to sell outside. We are hosting the King Pins Car show season opener on Sunday May 6th. We held the fall closer for them and only served inside which was hectic. We are a responsible establishment and have held outside events in the past without incident. We have ample parking and emergency exits. All liquor will be served in a fenced tented area. Thank you for your consideration. Sincerely `" Susan Ze3yxb c an Manager, Camelot Sports Pub TOWN OF NORTH ANDOVER ONE DAY LIQUOR LICENSE APPLICATION (30 DAY NOTICE STRONGLY RECOMMENDED) r�Organization holding event: -—0 L(�Z X5T Y Name&Address of Responsible Party: f t Contact Number&e-mail Location of Event; �GS Type of Event: Is the event being cateredP Yes _ No Name of Caterer . ' ✓r a Date&Time of Event: ,lei- B fit Nan Profht Or anit0tign Other Than N on Pro Wine&Malt All Alcohol Wine&Malt --' ALCOHOL MUST BE PURCHASED BY THE LICENSEE:FROM A WHOLESALER Has permission been received from the property owner to hold this event? y Who Is serving the alcohol? ± Ll �p Does the server have liquor liability Insvrance? Gf7 Have servers had training in alcohol service? �S I,the undersigned, understand and agree to the restriction and responsibliftles of holding a One Day Alcohol License and certify that I am not prohibited from holding such license. I Agree that the-town of North A ver Is In • y responsible for the actions of the applicant. Applicant's Si gfia Date I _ ::T: ... Fitzgibbons, Karen From: Leathe, Brian Sent: Tuesday, April 03, 2012 12:39 PM To: Fitzgibbons, Karen; McCarthy, Fred; Sawyer, Susan Subject: RE: Special One Day License Karen Camelot will need to permit the tent, provide us with it location on a plot plan, and the fire rating certificate once the licensing commission signs off. Any food related issues should be brought to the attention of the health department before application to the building department is made. Brian From: Fitzgibbons, Karen Sent: Tuesday, April 03, 2012 11:56 AM To: Leathe, Brian Subject: FW: Special One Day License Hi Brian, I understand Gerry is on vacation and I will need this recommendation before he returns. Could you please respond to this request. Thank you kindly, Karen From: Fitzgibbons, Karen Sent: Monday, April 02, 2012 3:39 PM To: Carney, John; McCarthy, Fred; Brown, Gerald Subject: Special One Day License Hi John, Fred and Gerry, Attached you will find a letter and application from Susan Zeytoonian, Camelot manager, 505 Sutton Street, requesting a special one day beer and wine license for the King Pins Car show season opener on Sunday, May 6th between the hours of 10:00 am and 7:00 p.m. Gerry,you will please note the applicant plans to erect a tent on the premises so I will definitely need your recommendation. I have scheduled this item for the April 23, 2012 BOSJt.icensing Commission hearing,therefore i would need your respective recommendations no later than April 11, 2012. As usual,thank you all for your co-operation in this matter. Karen Fitzgibbons Asst, Town Clerk 1 TOWN OF NORTH ANDOVER, MASSACHUSETTS Police Department Y 1475 Osgood Street North Andover, MA. 01845 Tel. 978-683-3168 To: Karen Fitzgibbons, Assistant Town Clerk From: Lt.John Carney RE: One Day Liquor License Date: April 5, 2012 The Police Department recommends favorable action on the request from Susan Zeytoonian, on behalf of the Knights of Columbus,for a one day liquor license on May 6, 2012, as described in the application. All servers should be TIPS certified;all alcohol should be sold and consumed within the controlled area. No alcohol shall be brought onto the premises by anyone other than the K of C employees. All vehicles should be parked on K of C property.The Police, as licensing agents, may conduct checks during the event. TOWN OF NORTH ANDOVER .Fire Department Central Fire Headquarters—Eire Prevention Office 124 MAIN STREET NORTH ANDOVER, MASSACHUSETTS 01845 yORTH Andrew Meinikas Fire Chief Telephone(978) 688-9593 FAX (978) 688-9594 Lt. F. McCarthy a�R"T�n�PP`y.�Cj amelnil<as�� to�.vnofriorthandover.com Fire Prevention.Officer "$SgCHUSE�` finceartliy ),townofnorthandover.com Town Clerks Office 120 Main St. North Andover, Ma April 5, 2012 Karen, The Fire Department recommends favorable action for a one day liquor license for the Knights of Columbus on May 6, 2012. A couple of concerns would be that the FD will need 360 degree access around the building with all fire lanes clear. Any outdoor cooking shall be attended at all times with a fire extinguisher present. Lt Fred McCarthy Fire Prevention TOWN OF NORTH ANDOVER OFFICE OF TOWN CLERK 120 MAIN STREET NORTH ANDOVER, MASSACHUSETTS 01845 f ,%ORTH ?Ottt Sao Sawa ~D Joyce A. Bradshaw,CMMC 0 n Telephone(978)688-9501 Town Clerk, FAX(978)688-9557 SSACHUSE MEMORANDUM TO: Rosemary Connelly Smedile, Chairman, Licensing Comm. Members of the Board of Selectmen Andrew Maylor,Town Manager FROM: Karen A. Fitzgibbons, Asst. Town Clerk 1#W1t'' DATE: April 13, 2012 SUBJECT: One Day,Wine &Malt License Attached please find a request from Merrimack College for a One Day Wine& Malt License application. The event is called "Women Empowering Women" and is to be held on April 26, 2012 from 5:00 p.m. to 9:00 p.m. at Cascia Hall. Included are favorable recommendations from the North Andover Police and Fire Departments. If you have any questions or concerns please do not hesitate to contact me or Joyce Bradshaw. Thanlc you. Merrim ack NORTH ANbol'ER, MASSACHUSETTS 0184U12 A PR -5 F`? E 978-837-5000 > 7i'2d7t>.lYlet'Y111i17Ck.�c�td April 2, 2012 VIA FIRST CLASS MAIL Board of Selectmen Town of North Andover 120 Main Street North Andover, MA 01845 Re: Merrimack Colhe e-Request for one- 'ay license Dear Sir or Madam: Please find enclosed a completed One Day Liquor License Application and a check in support of same. Specifically, the Women Empowering Woman event will be held in Cascia Hall. Should you need anything further, please let met know. As always,thank you so much for your help. Very truly yours, C.Alexa Abowitz Vice President of Administration And General Counsel TOWN OF NORTH ANDOVER lea 24'—� � �APR Y�1 ONE DAY LIQUOR LICENSE APPLICATION 2012 Organization holding event: ( ;+ Name&Address of Responsible Party:-MP-,r r i or,l- Contact Number&e-mail 4 c a ( Location of Event; Type of Event: Is the event being catered? Yes No Name of Caterer Date&Time of Event: CP �.. �+ Non Profit Organization Other Than Non Profit ine&Malt All Alcohol Wine& Malt ALCOHOL MUST BE PURCHASED BY THE LICENSEE FROM A WHOLESALER Has permission been received from the property owner to hold this event? Who is serving the alcohol? ''� Does the server have liquor liability insurance? `a Have servers had training in alcohol service? I,the undersigned, understand and agree to the restriction and responsibilities of holding a One Day Alcohol License and certify that I am not prohibited from holding such license. I agree that the Town of No Andover is in no way responsible for the actions of the applicant. /-I---& �2 /'Z Applicant's Signature Date H' TOWN OF NORTH ANDOVER, MASSACHUSETTS r 1 § Police Department s 1475 Osgood Street h, North Andover,MA. 01845 Tel.978-683-3168 To: Karen Fitzgibbons, Assistant Town Clerk From: Lt. John Carney RE: One Day License—Merrimack College Date: April 11, 2012 The Police Department recommends favorable action on the request from Merrimack College for a one day license on April 26, 2012 as outlined in the application. No additional stipulations. TOWN OF NORTH ANDOVER Fire Department Central Fire I ieadquarters—Fire Prevention Office 124 MAIN STREET NORTH ANDOVER, MASSACHUSETTS 01845 ORTH Andrew Melnikas o N,10 Fire Chief o? - ° 'Telephone(978) 688-9593 F- FAX (978) 688-9594 Lt. F. McCarthy ry4 Fire Prevention Officer ,°°�nr.o�p"��5 amelnil<as;�z)townotnorthandover.com SSACHUS£ fmccartlhvCa)townofnorthandovei-.com Town Clerk's Office 120 Main St. North Andover, Ma April 13,2012 Karen, The Fire Department recommends favorable action for a 1 day liquor Iicense at Cascia Hall Merrimack College on April 26, 2012. Lt Fred McCarthy Fire Prevention\ 978-688-9590 I i I I I '��`�� x C/inz��irdovWiz .�alzioiic C96sewaliorc �ona�i�ee �,��-�r 1978) 682-6378 Date: April 6, 2012 To: North Andover Board of Selectmen Via: Andrew Maylor, Town Manager CC: Division Director, Ray Santilli Director of Public Works Bruce Thibodeau Director of Youth&recreation Services Rick Gorman Subject: Request to Install Memorial Plaque at Youth Center Ladies and Gentlemen: In support of the Arbor Day tree planting scheduled for 4/27/12 at 10:00am.The North Andover Patriotic Observance Committee respectfully requests permission to install a 12"x 24" granite stone with the following inscription: 1.JMB TO GLOB ,* C Y•. In Memoriam to PFC Evan W. O'Neill, U.S. Army April 16, 1984 — September 29, 2003 Exceptional meritorious achievement as a Rifleman assigned to the 10th Mountain division in direct support of Operation Enduring Freedom. For additional information please contact Edward V. Mitchell at(978) 688-9525. Respectfully, Chief Edward V. Mitchell, US Navy(Ret) Chairmen, Patriotic Observance & Marching Committee INTEROFFICE MEMORANDUM TO: Andrew Maylor,Town Manager DATE: April 2,2012 FR: Bruce Thibodeau,Director of Public Works CC: Rick Gorman,Director of Youth Services Ed Mitchell,Director of Veterans' Services Tim Willett, Operations Manager John Lavin, Sr. Foreman RE: Arbor Day Celebration We have scheduled Arbor Day Celebration this year actually on Arbor Day, Friday,April 27th at 10 AM. We will be planting a tree at the Youth Center in memory of a fallen soldier from North Andover, Evan O'Neil. Information on PFC O'Neill is attached.National Grid will be donating the tree, a flowering cherry; which will replace a tree that was damaged during a storm. John Lavin has coordinated with both Rick Gorman and Ed Mitchell. We will need a proclamation signed by the Board and someone to read it at the celebration. We will also have a poem to read and I have someone in mind to do that reading, Karen Kline,but have not made any commitments. I will get you a form of the proclamation before the next Selectmen's meeting although there should be a form already in the files from last year. ALXIIA l-UN1YAiN Y 1-6 1 1,N 025-70-6296 Private First Class O'Neill was a rifleman for 2" Squad, 1" Platoon, Alpha Company 1-87 IN at Firebase Shkin, in support of Operation J✓nduring Freedom IV in Afghanistan_ On the afternoon of 29 September 2003, 1" PLT conducted a dismounted reinforcement of troops in contact in the vicinity of Lazano Ridge. The purpose of the patrol was twofold: 1) To reinforce 2nd PLT, who was in contact, and 2) To cicar known cnemy locations identified by 2nd PIatoon in the initial engagement. The patrol dismounted and moved across Lazano Ridge with the mounted elements in support of their movement on the high ground to the west and south. 2nd Squad was the lead element of the company, and PFC O'Neill was the point man throughout the movement, god identified a small ruins with fresh footprints,recently burned wood,and other obvious evidence of recent activity. SSG McGurk instmcied the squad.to climb the next high ground rather than moving any further through the wadi system. Upon reaching the crest of the?till one fire team provided over watch while the other crested the hill and moved to the next covered position. Immediately after cresting the hill the lead fire team, with PFC O'Neill as the far right flank, surprised three enemy soldiers hiding in a tree. PFC O'Neill arid his fire team immediately engaged the enemy, killing one and wounding two. The enemy immediatcly attempted to break contact Upon initiation of the fighting PFC O'Neill immediately engaged the enemy at a range of less than ten meters. After killing and wounding the cncmy, SGT Grcnz gave the order to break contact to the nearest covered position to the west. At that time PFC O'Neill immediately began movement following his team leader, while at the same tine fixing weapon malfunction. PFC O'Neill was engaged by the enemy from a distance of over 800 meters. PPC O'Neill was hit three times by enemy fire, with the fourth round lodging in his ammunition pouch. PFC O'Neill remained coherent and talking to his leaders, more concerned about the welfare of his friends and squad tlian himself. PVC O'Neil l's quick actions under fire saved the lives of his teals. Aftcr the conclusion of the fireflvht it wDz dCfcrmini-A that PFr: nwt-;w1 z nrfin-c nr h,nlly cgx—i nr inacf fmant,, C r- o N 0 Z T T E UNITED STATES O F AM � R� �l� 0 ">7 T() A1,T.«'IJU i]TAIJ, SELL THESE PRFSEh t REL- •TS, TINO. TlIFS 1S TO C D ERTSFY T}f.�T THE PFZF_SIDENT > Ifs' 1'EEJi t'v17'ED ST,i'T1 5 OE' AJIF:FICA ,\tT1i01t17,E l) 1JY }:XE( ITIVE 0RDER, w4 AUGUST 1962 K'S ANVARDED U 0 THE BRONZE STAR MEDAL A fO WITH "V"DEVICE PRIVATE FIRST CLASS EVAN W.O'NULL rztlt 1sT BATTALION,87T"INFANTRY REGIMENT exccpiionally )jcsitorious achievement as a Rifletnat for Alpia Company, 1-871 lnfa.try Regiment,while deployed to Afghanstan, iJt direct support aCOperadoa Endaring Frcedon). Private First Class O'Neill's leadership, selfless Scnict, and Enduring lment to mission accomplishment under tltcntosl extreme of circumstances greatly contributed to[,iCSUCCess crop eration Enduring Frecdont. tiVSite e gaged in an eremy ambush, his vslia t actions savo3 the lives ofrrany of his fellow p[acoon ntentbers, His courageous performance of duty in a combs;Inc reflects great credo upon him, t-)c Combined/Joint Task Force- 180,aad the L''nitcd States Central Comrrtartd, lD FroJ;.29 September 2003 to 29 September 2003 i Clti'ES UNDER \lY HA. D 1N THE CITY OF NVASHINGTDN ON THIS 30TH DAY OF SEPTEMB ER 2003 N W lb 101�� N It R.V1NES .. A'I1,\I:SiI'It L'l',1Hf IiITY.f•..4 H:�1' IJ Ueutenaat General,US Army l Comrnar�ing 17 O W 4 ,. ♦ k x • w • INTEROFFICE MEMORANDUM To: Board of Selectmen From: Andrew W. Maylor,Town Manager Date: April 19, 2012 Re: Fiscal 2013 Budget Update I have attended three meetings with the Finance Committee regarding the Fiscal 2013 budget and I am scheduled for one more meeting on April 24th and then the public hearing is scheduled for May 81h. As of today the Finance Committee has not voted on any aspect of the General or Enterprise Fund budgets. Our budget assumptions regarding local aid have been based on the Governor's Budget which was released in late January. The next step in the state budget process was for House Ways and Means to release their budget which they did last week. Based on those figures North Andover will realize an increase of$113k in net additional local aid when compared to the Governor's Budget. Since it is unrealistic that we will see in future years the increase we saw this year in local aid from the state (at least$577k), I do not support amending the Town Manager's Recommended Budget that you approved last month by adding the possible increase in local aid provided for in the House Budget. To do so would increase the prospect that next year we would need to reduce existing services levels. Our reserve balances are lower than the accepted best practices for municipal governments and during the past several years we annually wondered if we were going to be able to deliver the services we had the year before. Our goal must be to develop a long term approach to providing sustainable service delivery that does not assume, or rely on, one-time revenues or property tax overrides. This is truly an obtainable goal if we commit to building our reserves while reducing our debt service as a percentage of budgeted revenues, reducing our energy costs, developing strategic partnerships and addressing the high cost of employee benefits. EPSTEIN & AUGUST, LLP ATTORNEYS AT LAW 101 ARCH STREET, 9" Floor BOSTON, MA 02110-1112 Tel: (617)951-9909 Fax: (617)951-2717 billaugustUSAnue aol.com William August,Esq. DRAFT February ,2012 Geoffrey Why Commissioner Department of Telecommunications and Cable 1000 Washington St, Suite 820. Boston, MA 02118 Re: Motion to Intervene of the Town of North Andover and Notice of Appearance In the Matter of Comcast Cable Communications February 1, 2012 cable rate filings (FCC Form 1240, and Form 1205) Dear Commissioner Why: Please accept this letter as the Town of North Andover's Motion to Intervene in the above captioned matter. The Town states as grounds for its motion that the Board of Selectmen as the License Issuing Authority finds that cable rates impact License matters for which the Issuing Authority is responsible, and the public has an interest in actions taken to maintain the reasonableness of rates, and Issuing Authority participation through intervention may promote these public interest objectives. Please also accept this letter as the Notice of Appearance for the undersigned special counsel to the Town. Copies of filings should be mailed to me as counsel to the Town in the matter. Thank you for your attention to this matter. Please call if you have any questions whatsoever. The Town of North Andover, By its special counsel: William August, Esq. cc: Andrew Maylor, Town Manager George Dague, Chairman, Cable Advisory Committee Johnson, Adele From: Maylor, Andrew Sent: Tuesday, March 13, 2012 5:05 PM To: Johnson, Adele Subject: Fwd: CAC approval of motion to intervene Attachments: motion to intervene north andover2012.doc; ATT00001.htm Please place this on the April 2 agenda. Regards, Andrew Maylor Sent from my iPhone Begin forwarded message: From: "billau ussttusakaol.com" <billau ustusa@aol.com> Date: March 13, 2012 2:48:08 PM EDT To: "Maylor, Andrew" <amaylor cr,townofnorthandover.com> Cc: " .dg_aguekatt.net" <g.daguekatt.net> Subject: CAC approval of motion to intervene Andrew, The Cable Committee unanimously approved recommending Board of Selectmen authorization of filing a motion to intervene in the pending Comcast rate case, at Mass. Dept. of Telecom and Cable. Motion to Intervene attached, for recommended Board of Selectmen approval. Comcast may have over- collected certain North Andover Institutional Network annual maintenance charges, so we want to intervene in the rate case which will give us the rights of a party to file discovery questions to Comcast on this issue. It's a nice technical issue that Comcast will respect and will give us some good discovery process leverage which will reinforce what we are working on in the renewal process. If you want to discuss further, please feel free to call or let me know how to proceed. Best regards, Bill August(cell tel: 617 548 3735) Bill August Epstein &August, LLP 101 Arch Street, Suite 900 Boston, MA 02110 tel. 617-951-9909 fax 617-951-2717 billaugustUSA(a aol.com The information contained in this transmission may contain privileged and confidential information. With respect to client communications use of this transmission is intended only for the use of the person(s) named above and with respect to such communications you are hereby notified that if you are not the intended recipient, any review, dissemination, distribution or duplication of this communication is strictly prohibited. Please mote the Massachusetts Secretary of State's office has determined tt,at roost ernails to and frorn rnunicipal offices and officials are public,records. For more;information please refer to:http://www.sec.state.ma.us/pre/preidx.htm. Please consider the enuironrnent before printing this ern<aiL 1 COMMUNITY DEVELOPMENT DIVISION Building (onser.vation Health Planning Zoning MEMORANDUM TO: Andrew W. Maylor,Town Manager FROM: Curt Bellavance, Director RE: Affordable Unit Resale DATE: March 20, 2012 CHAPA (Citizens' Housing and Planning Association), has notified the Town that the following affordable units are up for sale. CHAPA manages the resale of affordable units for Oakridge Village and Kittredge Crossing. 3 Harvest Drive, Unit 105 at Oakridge Village 109 Chickering Road, Unit 109D at Kittredge Crossing The Board of Selectmen has to determine if they want to exercise their right of first refusal. Our office would recommend that the Board of Selectmen should not exercise their right of first refusal for the affordable housing units. If the Town chooses to exercise its right,then it would be the responsibility of the Town to purchase the property or locate an individual to purchase the property. CHAPA, which is the monitoring agent for the Town and several other communities, has better resources to preserve the unit as affordable and has recently hired new staff to manage the marketing of the units. The timeframe is 120 days to find an applicant that meets the affordable criteria. Because the Town has been handling several affordable unit resale's during the past twelve months, our office has been working more closely with the Housing Partnership Committee and North Andover Housing Trust to ensure that the units stay affordable. The deadline to act is April 12. If the Board does not act the right of first refusal is deemed authorized. It is recommended that the Board of Selectmen not exercise their right of first refusal. 1600 Osgood Street,North Andover,Massachusetts 01845 Phone 978.688.9531 Fax 978.688.9542 Web www.townofnorthandover.com Johnson, Adele From: Bellavance, Curt Sent: Friday, March 16, 2012 11:22 AM To: Maylor, Andrew Cc: Johnson, Adele Subject: Affordable Resale Attachments: M - BOS - Resale of Afford Unit 2012-03.doc; CHAPA-waiver notice 03-2012.pdf Andrew: The Board of Selectmen have right of first refusal regarding the sale of affordable units. I drafted this memo for the BOS. I have done several of these memos in the past. The BOS have never voted to purchase the affordable units. Please let me know if you have any questions. Thanks, Curt. Curt T. Bellavance,AICP Director,Community Development Division Town of North Andover 1600 Osgood Street North Andover,MA 01845 Phone 978.688.9531 Fax 978.688.9542 Email cbellavance @townofnorthandover.com Web www.TownofNorthAndover.com Please note the Massachusetts;Secretary of State's office has determined that most emails to and from municipal offices and officials are public records.For more infamiation please refer to:http://www.sec.state.ma.us/pre/preidx.htm, Please consider the environment before printing this email I 1 I, TOWN OF NORTH ANDOVER FY 2013 Stevens Estate Fund Town Manager's Recommendation .1aRtFt A o � 4 Cwu Board of Selectmen Tracy M. Watson Rosemary C. Smedile William F. Gordon Donald B. Stewart Richard M. Vaillancourt Town Manager Andrew W Maylor Budget Director/Town Accountant Lyne Savage MARCH 2012 �I III I . Town of North Andover Office of the Town Manager Nortb Andover Town Hall p, 120 Main Street Nay-th Andover, MA 01845 e-mail. a, aylor°cu;townof ortb and over.coin ,4n(Jrew W Alalvlor Telephone (97(0688-9510 Town Man ago-er Fax (978)6889556 March 30, 2012 Executive Summary—Town Manager's Fiscal 2013 Stevens Estate Recommended Budget Dear Members of the North Andover Board of Selectmen and Finance Committee, The FY13 Town Managers Recommended Stevens Estate Budget totals$266,928 which represents an increase of 5.8%over the projected fiscal 2012 results and a decrease of 15.7%from the Town Meeting approved budget of$316,822. Since there is a direct correlation between expenses and revenues in regards to Stevens Estate operations,the lower than expected expenditures in FY12 are not a reflection of efficiencies as may be the case with the General Fund Budget, but instead reflect an inability to generate sufficient events to meet the expected FY12 milestones. The Stevens Estate operates as an Enterprise Fund per the provisions of Massachusetts General Law Chapter 44, section 53 F%. The purpose of this type of fund is to account for the activities separately from general government operations including the ability to retain accumulated profits or retained earnings. During the past twelve years the Estate has experienced a steady decline in User Charges from events from a high of$819,674 in FY01 to a low of$193,097 in FY09. The past three years the revenues have been relatively stable, although not sufficient enough to fund total expenditures. The accumulated retains earnings which hit a low of($179,344) at the end of FY08 are now at$0.The condition of the facility along with the economy has clearly had an effect on the Estate's financial viability. Given the limited time I have had to fully understand the operation of the Estate and to evaluate the steps that have been taken during the past year in an attempt to improve its profitability, I have decided to present the budget consistent with past years. Next fiscal year it is likely that I will make recommendations which alter the current methodology regarding the budget. Regardless of the financial condition of the business component of the Estate,we should not lose sight of the positive value that the building and grounds have on the quality of life of North Andover residents. Sincerely, Andrew W. Maylor Town Manager Town of North Andover FYI Town Managers Recommd Budget - Stevens Estate Fiscal Year: 2011-2012 From Date: 3/1/2012 To Date: 3/31/2012 Definition: FY13 Town Mgr Recommd 2012 YTD w 2013 Dept 2013 Town Mgr Account Description 2011 Actual 2012 Budget 2012 Adj Budget encumbrances Request Reccmd Dollar Chg 6126064.1.0.0990.1237.2.596100.0001 Transfer To General Fund $46,460 $46,460 $46,460 $34,845 $46,460 $46,460 $0 Budget-Control: Expense-2 $46,460 $46,460 $46,460 $34,845 $46,460 $46,460 $0 Dept/Loc: Transfers-0990 $46,460 $46,460 $46,460 $34,845 $46,460 $46,460 $0 6126064.1.0.1237.0000.1.511100.0001 Salaries-Full Time $47,895 $50,000 $50,000 $45,676 $50,000 $50,000 $0 6126064.1.0.1237.0000.1.512000.0001 Salaries-Part Time $44,787 $57,087 $57,087 $29,292 $60,000 $50,000 ($7,087) Budget-Control: Salary-1 $92,682 $107,087 $107,087 $74,969 $110,000 $100,000 ($7,087) 6126064.1.0.1237.0000.2.521000.0001 Electricity $9,839 $15,600 $15,600 $7,040 $15,600 $11,434 ($4,166) 6126064.1.0.1237.0000.2.521300.0001 Heating Fuel $28,256 $28,000 $28,000 $17,618 $29,200 $19,200 ($8,800) 6126064.1.0.1237.0000.2.523000.0001 Water $3,360 $4,800 $4,800 $1,865 $4,800 $3,300 ($1,500) 6126064.1.0.1237.0000.2.524000.0001 Repairs And Maintenance $4,647 $8,500 $8,500 $2,691 $8,500 $6,500 ($2,000) 6126064.1.0.1237.0000.2.527000.0001 Equipment Rental/lease $33,435 $28,790 $28,790 $17,605 $26,550 $21,550 ($7,240) 6126064.1.0.1237.0000.2.527200.0001 Laundry Services $6,700 $8,197 $8,197 $3,317 $8,200 $7,700 ($497) 6126064.1.0.1237.0000.2.531100.0001 Advertising $6,046 $10,400 $8,900 $6,458 $10,400 $6,400 ($4,000) 6126064.1.0.1237.0000.2.531600.0001 Contract Services $150 $1,576 $1,576 $40 $1,576 $576 ($1,000) 6126064.1.0.1237.0000.2.531900.0001 Food Delivery Services $854 $2,500 $2,000 $0 $2,500 $500 ($2,000) 6126064.1.0.1237.0000.2.532200.0001 Training And Education $305 $0 $0 $0 $0 $0 $0 6126064.1.0.1237.0000.2.533000.0001 Refunds $500 $1,584 $1,284 $0 $1,584 $1,584 $0 6126064.1.0.1237.0000.2.533500.0001 Liquor/Beer/Wine/Soda/Juice $17,160 $19,231 $19,231 $8,779 $19,231 $17,231 ($2,000) 6126064.1.0.1237.0000.2.534100.0001 Telephone $2,732 $2,700 $2,700 $1,851 $2,700 $2,700 $0 6126064.1.0.1237.0000.2.534200.0001 Postage $0 $240 $240 $0 $240 $0 ($240) Printed: 03/29/2012 12:54:01 PM Report: 2.9.22 Page: 1 rptGLGenBudgetRptUsingDefinition Town of North Andover FY13 Town Managers Recommd Budget - Stevens Estate Fiscal Year: 2011-2012 From Date: 3/1/2012 To Date: 3/31/2012 Definition: FY13 Town Mgr Recommd 2012 YTD w 2013 Dept 2013 Town Mgr Account Description 2011 Actual 2012 Budget 2012 Adj Budget encumbrances Request Reccmd Dollar Chg 6126064.1.0.1237.0000.2.540000.0001 Bank Service Charges $3,065 $4,729 $4,729 $1,904 $4,729 $3,229 ($1,500) 6126064.1.0.1237.0000.2.542000.0001 Office Supplies $1,390 $1,200 $1,500 $1,408 $1,200 $1,000 ($200) 6126064.1.0.1237.0000.2.542200.0001 Materials And Supplies $3,366 $2,364 $4,364 $3,711 $2,364 $2,364 $0 6126064.1.0.1237.0000.2.545600.0001 Building And Grounds $15,030 $17,100 $17,100 $12,257 $15,100 $12,100 ($5,000) 6126064.1.0.1237.0000.2.571700.0001 Liquor Licenses $3,300 $3,100 $3,100 $3,100 $3,100 $3,100 $0 6126064.1.0.1237.0000.2.578000.0001 Other Charges And Expense $141 $300 $600 $411 $300 $0 ($300) 6126064.1.0.1237.0000.2.585000.0001 Capital Purchase>$999<$49 $0 $2,364 $2,064 $0 $2,104 $0 ($2,364) Budget-Control: Expense-2 $140,276 $163,275 $163,275 $90,054 $159,978 $120,468 ($42,807) Dept/Loc: Stevens Estate-1237 $232,958 $270,362 $270,362 $165,022 $269,978 $220,468 ($49,894) Grand Total: $279,418 $316,822 $316,822 $199,867 $316,438 $266,928 ($49,894) End of Report Printed: 03/29/2012 12:54:01 PM Report: 2.9.22 Page: 2 rptGLGenBudgetRptUsingDefinition TOWN OF NORTH ANDOVER - STEVENS ESTATE ENTERPRISE FUND OPERATING STATEMENT WITH BUDGET FOR PERIOD 03/01/12 THROUGH 03/29/12 Fiscal Year: 2011-2012 FY12 MTD FY12 Year To Date Projections FYI 03/01/12-03/12/12 07/01111 - Budget Encumbrance Budget Balance Thru 6/30/12 Recmd 03/29/12 REVENUES REVENUE 10%increase Stevens Estate Receipts(+) $ 5,491.75 $195,888.43 $316,822.00 $ 0.00 $127,531.62 40.3% A$242,740.43 $267,014.47 Interest Income(+) $0.00 $150.48 $0.00 $0.00 ($150.48) 0.0% $0.00 Sub-total : REVENUE $ 5,491.75 $196,038.91 $316,822.00 $ 0.00 $127,381.14 40.2% $267,014.47 Total : REVENUES $ 5,491.75 $196,038.91 $316,822.00 $ 0.00 $127,381.14 40.2% $267,014.47 EXPENSES SALARIES Salaries(-) $2,935.90 $62,853.17 $107,087.00 $ 12,115.37 $32,118.46 30.5% $84,380`,54 $100,000.00 Sub-total :SALARIES ($2,935.90) ($62,853.17) ($107,087.00) ($ 12,115.37) ($32,118446) 30.5% ($84,380.54) ($100,000.00) EXPENDITURES Expenses(-) $ 2,354.38 $89,768.28 $163,275.00 $ 1,281.86 $72,224.86 46.3% $132,778.28 $120,468.00 Expenses Prior yr encumbrances(-) $0.00 $188.53 $0.00 $0.00 ($188.53) 0.0% $ 188.53 $0.00 Sub-total : EXPENDITURES ($ 2,354.38) ($89,956.81) ($163,275.00) ($ 1,281.86) ($72,036.33) 46.2% ($132,966:81) ($120,468.00) INTERFUND TRANSFERS Transfer to General Fund-Indirect C $3,871.67 $34,845.03 $46,460.00 $ 0.00 $11,614.97 25.0% $34,845.03 $46,460.00 Sub-total : INTERFUND TRANSFERS ($3,871.67) ($34,845.03) ($46,460.00) ($ 0.00) ($11,614.97) 25.0% ($34,845:03) ($46,460.00) Total : EXPENSES ($ 9,161.95) ($187,655.01) ($316,822.00) ($ 13,397.23) ($119,663.03) 37.8% ($252,192.38) ($266,928.00) NET ADDITION DEFICIT ($3,670.20) $ 8,383.90 $0.00 ($ 13,397.23) $ 7,718.11 0.0% $9,226.23 $ 86.47 Retained Earnings $ 2,184.51 Surplus/(Deficit) ($7.041.72) 3/29/2012,2:51 PM TOWN OF NORTH ANDOVER Steven's Estate at Osgood Hill FY2001 FY2002 FY2003 FY2004 FY2005 FY2006 FY2007 FY2008 FY2009 FY2010 FY2011 FY2012 Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Adopted Revenue: User Charges 819,674 662,767 677,582 450,656 423,944 507,693 471,156 259,237 193,097 285,188 239,043 316,822 Other Revenue - - - 4,700 2,550 - - - 2,950 - 157 - Total Revenues 819,674 662,767 677,582 455,356 426,494 507,693 471,156 259,237 196,047 285,188 239,200 316,822 Expenses: Salary 230,695 225,305 211,136 158,963 163,154 173,545 170,049 142,530 99,517 113,468 92,682 107,087 Expenses 389,159 464,106 415,922 265,208 230,156 271,689 259,685 244,338 140,685 124,180 150,272 163,275 Debt - - - - - - - - - - - - Capital Outlay - - 190,000 - - - - - - - - - InterPund Transfers - 54,758 72,000 91,900 85,959 65,000 83,119 71,391 64,176 40,141 46,460 46,460 Total Expenses 619,854 744,169 889,058 516,071 479,269 510,234 512,853 458,258 304,378 277,789 289,414 316,822 NetY-T-D Operating 199,820 (81,402) (211,476) (60,715) (52,775) (2,541) (41,697) (199,021) (108,331) 7,399 (50,214) - Beginning Fund Balance 270,463 470,283 388,881 177,405 116,690 63,915 61,374 19,677 (179,344) (91,380) 47,399 2,184 Ending Fund Balance 470,283 388,881 177,405 116,690 63,915 61,374 19,677 (179,344) (287,675) (83,981) (2,816) 2,184 Transfer from General Fund - - - - - - - - 196,2'95 131;380 5,000 Ending Fund Balance after Transfers 388,881 177,405 116,690 63,915 61,374 19,677 (179,344) (91,380) 47,399 2,184 3/2912012,1:24 PM TOWN OF NORTH ANDOVER 2012 ANNUAL TOWN MEETING WARRANT ARTICLES AS OF APRIL 2,2012 Alpha Num. Article Title Sponsor Board of Selectmen Finance Committee Planning Board A Reports of Special Committees Board of Selectmen B Reports of Receipts and Expenditures Board of Selectmen Authorization ofthe Town Manager or Superintendant of Schools Regarding Contracts C Board of Selectmen in Excess of Three Years D Authorization to Accept Grants of Easements Board of Selectmen E Authorization to Grant Easements Board of Selectmen F Compensation of Elected Officials Board of Selectmen G Prior Year Unpaid Bills Board of Selectmen H Establishment of Revolving Funds Board of Selectmen I Continuation of MGL,Chapter 59,Section 5K,Senior Work Program-Funding Council on Aging J Amend General Fund Appropriation for FY12 Board of Selectmen K Amend Water Fund Appropriation for FY12 Board of Selectmen L Amend Sewer Fund Appropriation for FY12 Board of Selectmen M Amend Stevens Estate at Osgood Hill Enterprise Fund Appropriation for FY12 Board of Selectmen N Amend Capital Plan Appropriations from Prior Years Board of Selectmen O General Fund Appropriation Fiscal Year 2013 Board of Selectmen P Water Enterprise Fund Appropriation Fiscal Year 2013 Board of Selectmen Q Sewer Enterprise Fund Appropriation Fiscal Year 2013 Board of Selectmen R Stevens Estate at Osgood Hill Enterprise Fund Appropriation-Fiscal Year 2013 Board of Selectmen S Capital Improvement Plan Appropriation Fiscal Year 2013 Board of Selectmen T Report of the Community Preservation Committee and Appropriation Board of Selectmen U Appropriation from Federal Early Retirement Reinsurance Program Board of Selectmen V Sale of Public Buildings Town Manager W Capital Stabilization Account Town Manager X Energy Services Company Project Funding Town Manager Y Finger Print Based Criminal Record Background Checks Town Manager Z Reduction of Community Preservation Act Surcharge CP-William Callahan AA Amend Chapter 69-7.1 of the Town Bylaws Fire Chief AB Amend Chapter 28.3 ofthe Town Bylaws Board of Selectmen AC Petition the General Court-Liquor Quota Increase-LaBottega-Turnpike St. CP-Angela Paolini AD Petition the General Court-Amend Town Charter-Change Election to June CP-George Vozeolas AE Petition the General Court-Amend Town Charter Town Meeting Proceedures Town Clerk AF Amend General Bylaws-Chapter 59-6-Annual Town Meeting Date Town Clerk AG Amend General Bylaws-Add Chapter 174-Trees DPW AH Amend Zoning Bylaw-Section 8.1.4-Off Street Parking General Requirements Planning Board Al Amend Zoning Bylaw-Section 4.137-Floodplain District Planning Board Ai Amend Zoning Bylaw-Section 4.135-Industrial S-Added Use Planning Board AK Amend Zoning Map-1080 Osgood Street-Map35 Parcel 19 from 12 to B-2 Planning Board AL Transfer to Stabilization Board of Selectmen AM Transfer to OPEB Stabilization Board of Selectmen AN Change Time of Elected Officials Assuming Office(Henry Fink Proposal) Board of Selectmen MASTER LI5T-2012 ANNUALTOWN MEETING-MARCH 28 2012Sheetl4/2/20126:55 PM TOWN OF NORTH ANDOVER 2012 ANNUAL TOWN MEETING WARRANT ARTICLES AS OF APRIL 2,2012 Alpha Num. Article Title Sponsor Board of Selectmen Finance Committee Planning Board A Reports of Special Committees Board of Selectmen B Reports of Receipts and Expenditures Board of Selectmen C Authorization of the Town Manager or Superintendant of Schools Regarding Contracts Board of Selectmen in Excess of Three Years D Authorization to Accept Grants of Easements Board of Selectmen E Authorization to Grant Easements Board of Selectmen F Compensation of Elected Officials Board of Selectmen G Prior Year Unpaid Bills Board of Selectmen H Establishment of Revolving Funds Board of Selectmen I Continuation of MGL,Chapter 59,Section 5K,Senior Work Program-Funding Council on Aging J Amend General Fund Appropriation for FY12 Board of Selectmen K Amend Water Fund Appropriation for FY12 Board of Selectmen L Amend Sewer Fund Appropriation for FY12 Board of Selectmen M Amend Stevens Estate at Osgood Hill Enterprise Fund Appropriation for FY12 Board of Selectmen N Amend Capital Plan Appropriations from Prior Years Board of Selectmen O General Fund Appropriation Fiscal Year 2013 Board of Selectmen P Water Enterprise Fund Appropriation Fiscal Year 2013 Board of Selectmen Q Sewer Enterprise Fund Appropriation Fiscal Year 2013 Board of Selectmen R Stevens Estate at Osgood Hill Enterprise Fund Appropriation Fiscal Year 2013 Board of Selectmen S Capital Improvement Plan Appropriation Fiscal Year 2013 Board of Selectmen T Report of the Community Preservation Committee and Appropriation Board of Selectmen U Appropriation from Federal Early Retirement Reinsurance Program Board of Selectmen V Sale of Public Buildings Town Manager W Capital Stabilization Account Town Manager X Energy Services Company Project Funding Town Manager Y Finger Print Based Criminal Record Background Checks Town Manager Z Reduction of Community Preservation Act Surcharge CID-William Callahan AA Amend Chapter 69-7.1 of the Town Bylaws Fire Chief AB Amend Chapter 28.3 of the Town Bylaws Board of Selectmen MASTER LIST-2012 ANNUAL TOWN MEETING-MARCH 28 2012Sheetl3/29/2012339 PM