Loading...
R-12-05-24-G3 - 5/24/2012 Y RESOLUTION NO. R-12-05-24-G3 WHEREAS, the City's Charter requires an annual audit of the financial records to be { t 1 performed by an independent certified public accountant; and WHEREAS, the City of Round Rock ("City") has duly advertised for proposals to retain audit services for the fiscal year ending September 30, 2012, and for each of the four subsequent fiscal i years; and WHEREAS, City Staff has evaluated said proposals and has recommended the most highly 4 g qualified provider of the desired audit services; and WHEREAS the Cit Council desires to select an accounting firm to perform the City's audit Y , services,Now Therefore 4, BE IT RESOLVED BY THE COUNCIL OF THE CITY OF ROUND ROCK,TEXAS, i That the selection of Brockway, Gersbach, Franklin & Niemeier as the most highly qualified i provider of the desired audit services is hereby approved. The City Council hereby finds and declares that written notice of the date, hour, place and subject of the meeting at which this Resolution was adopted was posted and that such meeting was ` open to the public as required by law at all times during which this Resolution and the subject matter hereof were discussed, considered and formally acted upon, all as required by the Open Meetings Act, Chapter 551, Texas Government Code, as amended. RESOLVED this 24th day of May, 2012. ark) ALAN MCGRAW, Mayor City of Round Rock, Texas ATTEST: - C/iw�� SARA L. WHITE, City Clerk 0 4dox\SCC1nts\0112\1204\MUNICIPAL\00250321.DOC/rmc 3 I R BROCKWAY Y. rip.GERSBACH MUFRANKLIN & NIEMEIER,P.C. CERTIFIED PUBLIC ACCOUNTANTS t May 7, 2012 P E S City of Round Rock,Texas 221 E. Main Street - Round Rock, Texas 78664-5299 I We are pleased to confirm our understanding of the services we are to provide the City of Round Rock, Texas for the year ended September 30, 2012. We will audit the financial statements of the governmental activities, the business-type activities, the aggregate discretely presented component units, each major fund, and the aggregate remaining fund information, which collectively comprise the basic financial statements of the City of Round Rock, Texas as of and for the year ended September 30, 2012. Accounting standards generally accepted in the United States of America provide for certain required supplementary information (RSI), such as management's discussion and analysis(MD&A),to supplement the City of Round Rock,Texas' basic financial statements. Such information, although not a part of the basic financial statements, is required by the Governmental Accounting Standards Board who considers it to be an essential part of financial reporting for placing the basic financial statements in-an appropriate operational, economic, or historical context. As part of our engagement, we will apply certain limited procedures to City of Round Rock, Texas' RSI in accordance with auditing standards generally accepted in the United States of America. These limited procedures will consist of inquiries of management regarding the methods of preparing the information and comparing the information for consistency with management's responses to our inquiries, the basic financial statements, and other knowledge we obtained during our audit of the basic financial statements. We will not express an opinion or provide any assurance on the information because the limited procedures do not provide us with sufficient evidence to express an opinion or provide any assurance. The following RSI is required by generally accepted accounting principles and will be subjected to certain limited procedures,but will not be audited: 1. Management's Discussion and Analysis 2. Budgetary Comparison Schedules 3. GASB—Required Supplementary Pension and OPEB Schedules EEXHIBIT »A» POST OFFICE BOX 4083 ■TEMPLE,TEXAs 76505-4083 ■ 254.773.9907 ■ FAX 254.773.1570 r s City of Round'Rock,Texas Page Two We have also been engaged to report on supplementary information other than RSI that accompanies the City of Q Round Rock, Texas' financial statements. We will subject the following supplementary information to the auditing procedures applied in our audit of the financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to fl, prepare the -financial statements or to the financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America and will provide an opinion-on it in relation to the financial statements as a whole: 1. Combining and Individual Fund Statements and Schedules 2. Schedule of Expenditures of Federal Awards The following other information accompanying the financial statements will not be subjected to the auditing procedures applied in our audit of the financial statements, and for which our auditor's report will not provide an opinion or any assurance. 1. Introductory Section 2. Statistical Data Audit Objectives - The objective of our audit is the expression of opinions as to whether your basic financial statements are fairly presented, in all material respects, in conformity with U. S. generally accepted accounting principles and to report on the fairness of the supplementary information referred to in the second paragraph when considered in relation to the basic financial statements as a whole.The objective also includes reporting on— • Internal control related to the financial statements and compliance with laws, regulations, and the provisions of contracts or grant agreements, noncompliance with which could have a material effect on the financial statements in accordance with Government Auditing Standards. • Internal control related to major programs and an opinion (or disclaimer of opinion) on compliance with laws,regulations,and the provisions of contracts or grant agreements that could have a direct and material effect on each major program in accordance with the Single Audit Act Amendments of 1996 and OMB Circular A-133,Audits.of States, Local Governments, and Non-Profit Organizations. The reports on internal control and compliance will each include a statement that the report is intended solely for the information and use of management, the body or individuals charged with governance, others within the entity, specific legislative or regulatory bodies, federal awarding agencies, and if applicable, pass-through entities and is not intended to be and should not be used by anyone other than these specified parties. t l r City of Round Rock,Texas Page Three Our audit will be conducted in accordance with auditing standards generally accepted in the United States of America; the standards for financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States; the Single Audit Act Amendments of 1996; and the provisions of OMB Circular A-133, and will include tests of accounting records, a determination of major program(s) in accordance with OMB Circular A-133 and will include test of accounting records, a determination of major program(s) in accordance with OMB Circular A-133, and other procedures we consider necessary to enable us to express such render the required reports. If our opinions on the financial statements or the Single Audit opinions and to x compliance opinions are other than unqualified, we will discuss the reasons with you in advance. If, for any reason, we are unable to complete the audit or are unable to form or have not formed opinions, we may decline to express opinions or to issue a report as a result of this engagement. Management Responsibilities Management is responsible for the basic financial statements and all accompanying information as well as all representations contained therein. Management is also responsible for identifying government award programs and understanding and complying with the compliance requirements, and for preparation of the schedule of expenditures of federal awards in accordance with the requirements of OMB Circular A-133. As part of the audit, we will assist with preparation of your financial statements, schedule of expenditures of federal awards, and related notes. You are responsible for making all management decisions and performing all management functions relating to the financial statements, schedule of expenditures of federal awards,and related notes and for accepting full responsibility for such decisions. You will be required to acknowledge in the management representation letter our assistance with the preparation of the financial statements and the schedule of expenditures of federal awards and that you have reviewed and approved the financial statements, schedule of expenditures of federal awards, and related notes prior to their issuance and have accepted responsibility for them. Further, you are required to designate an individual with suitable skill, knowledge, or experience to oversee any nonaudit services we-provide and for evaluating the adequacy and results of those services and accepting responsibility for them. Management is responsible for establishing and maintaining effective internal controls, including internal controls over compliance, and for evaluating and monitoring ongoing activities, to help ensure that appropriate goals and objectives are met and that. there is reasonable assurance that government programs are administered in compliance with compliance requirements. You are also responsible for the selection and application of accounting principles; for the fair presentation in the financial statements of the respective financial position of the governmental activities, the business-type activities, the aggregate discretely presented component units, each major fund, and the aggregate remaining fund information of the City of Round Rock, Texas and the respective changes in financial position and, where applicable, cash flows in conformity with U.S. generally accepted accounting principles; and for compliance with applicable laws and regulations and the provisions of contracts and grant agreements. Management is also responsible for making all financial records and related information available to us and for ensuring that management and financial information is reliable and properly recorded. Your responsibilities also include identifying significant vendor relationships in which the vendor has responsibility for program compliance and for the accuracy and completeness of that information. Your responsibilities include adjusting the financial statements to correct material misstatements and confirming to us in the representation letter that the effects of any uncorrected misstatements aggregated by us during the current engagement and pertaining to the latest period presented are immaterial, both individually and in the aggregate, to the financial statements taken as a whole. r } City of Round Rock,Texas Page Four _ You are responsible for the design and implementation of programs and controls to prevent and detect fraud, and for informing us about all known or suspected fraud or illegal acts affecting the government involving (1) _ management, (2) employees who have significant roles in internal control, and (3) others where the fraud or illegal acts could have a material effect on the financial statements. Your responsibilities include informing us of your knowledge of any allegations of fraud or suspected -fraud affecting the government received in communications from employees, former employees, grantors, regulators, or others. In addition, you are responsible for identifying and ensuring that the entity complies with applicable laws and regulations, contracts, agreements and grants. Additionally, as required by OMB Circular A-133, it is management's responsibility to follow up and take corrective action on reported audit findings and to prepare a summary schedule of prior audit findings and a corrective action plan. You are responsible for the preparation of the supplementary information in conformity with U.S. generally accepted accounting principles. You agree to include our report on the supplementary information in any document that contains and indicates that we have reported on the supplementary information. You also agree to include the audited financial statements with any presentation of the supplementary information that includes our report thereon. Management is responsible for establishing and maintaining a process for tracking the status of audit findings and recommendations. Management is also responsible for identifying for us previous financial audits, attestation engagements, performance audits, or other studies related to the objectives discussed in the Audit Objectives section of this letter. This responsibility includes relaying to us corrective actions taken to address significant findings and recommendations resulting from those audits, attestation engagements, performance audits, or studies. You are also responsible for providing management's views on our current findings, conclusions, and d corrective actions, for the report, and for the timing and format for recommendations, as well as your planne providing that information. Audit Procedures—General An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements; therefore, our audit will involve judgment about the number of transactions to be examined and the areas to be tested. We will plan and perform the audit to obtain reasonable rather than absolute assurance about whether the financial statements are free of material misstatement, whether from (1) errors, (2) fraudulent financial reporting, (3) misappropriation of assets, or (4) violations of laws or governmental regulations that are attributable to the entity or to acts by management or employees acting on behalf of the entity. Because the determination of abuse is subjective,Government Auditing Standards do not expect auditors to provide reasonable assurance of detecting abuse. Because an audit is designed to provide reasonable, but not absolute assurance and because we will not perform a detailed examination of all transactions, there is a risk that material misstatements or noncompliance may exist and not be detected by us. In addition, an audit is not designed to detect immaterial misstatements or violations of laws or governmental regulations that do not have a direct and material effect on the financial statements or major programs. However, we will inform you of any material errors and any fraudulent financial reporting or misappropriation of assets that comes to our attention. We will also inform you of any violations of laws or governmental regulations that come to our attention, unless clearly inconsequential and of any material abuse that comes to our attention. We will include such matters in the reports required for a Single Audit. Our responsibility as auditors is limited to the period covered by our audit and does not extend to any later periods for which we are not engaged as auditors. i ock,Texas City of Round R Page Five A Our procedures will include tests of documentary evidence supporting the transactions recorded in the accounts, and may include tests of the physical existence of inventories, and direct confirmation of receivables and certain other assets and liabilities by correspondence with selected individuals, funding sources, creditors, and financial institutions. We will request written representations from your attorneys as part of the engagement, and they may bill you for responding to this inquiry. At the conclusion of our audit, we will also require certain written representations from you about the financial statements and related matters. Audit Procedures—Internal Controls t Our audit will include obtaining an understanding of the entity and its environment, including internal control, sufficient to assess the risks of material misstatement of the financial statements and to design the nature, timing, and extent of further audit procedures. Tests of controls may be performed to test the effectiveness of certain controls that we consider relevant to preventing and detecting errors and fraud that are material to the financial statements and to preventing and detecting misstatements resulting from illegal acts and other noncompliance matters that have a direct and material effect on the financial statements. Our tests, if performed, will be less in scope than would be necessary to render an opinion on internal control and, accordingly, no opinion will be expressed in our report on internal control issued pursuant to Government Auditing Standards. As required by OMB Circular A-133, we will perform tests of controls over compliance to evaluate the effectiveness of the design and operation of controls that we consider relevant to preventing or detecting material noncompliance with compliance requirements applicable to each major federal award program. However, our tests will be less in scope than would be necessary to render an opinion on those controls and, accordingly, no opinion will be expressed in our report on internal control issued pursuant to OMB Circular A-133. An audit is not designed to provide assurance on internal control or to identify significant deficiencies. However, during the audit, we will communicate to management and those charged with governance internal control related matters that are required to be communicated under AICPA professional standards, Government Auditing Standards,and OMB Circular A-133. Audit Procedures—Compliance As part of obtaining reasonable assurance about whether the financial statements are free of material misstatement, we will perform tests of the City of Round Rock, Texas' compliance with applicable laws and regulations and the provisions of contracts and agreements, including grant agreements.However,the objective of those procedures will not be to provide an opinion on overall compliance and we will not express such an opinion in our report on compliance issued pursuant to Government Auditing Standards. OMB Circular A-133 requires that we also plan and perform the audit to obtain reasonable assurance about whether the auditee has complied with applicable laws and regulations and the provisions of contracts and grant agreements applicable to major programs. Our procedures will consist of tests of transactions and other applicable procedures described in the OMB Circular A-133 Compliance Supplement for the types of compliance requirements that could have a direct and material effect on each of City of Round Rock, Texas' major programs. The purpose of those procedures will be to express an opinion on the City of Round Rock, Texas' compliance with requirements applicable to each of its major programs in our report on compliance issued pursuant to OMB Circular A-133. is Q City of Round Rock,Texas Page Six Engagement Administration,Fees,and Other We may from time to time, and depending on the circumstances, use third-party service providers in serving your account. We may share confidential information about you with these service providers, but remain committed to maintaining the confidentiality and security of your information. Accordingly, we maintain internal policies, procedures, and safeguards to protect the confidentiality of your personal information. In addition, we will secure confidentiality agreements with all service providers to maintain the confidentiality of your information and we will take reasonable precautions to determine that they have appropriate procedures in place to prevent the unauthorized release of your confidential information to others. In the event that we are unable to secure an appropriate confidentiality agreement, you will be asked to provide your consent prior to the sharing of your confidential information with the third-party service provider. Furthermore, we will remain responsible for the work provided by any such third-party service providers. We understand that your employees will prepare all cash, accounts receivable, or other confirmations we request and will locate any documents selected by us for testing. At the conclusion of the engagement, we will complete the appropriate sections of the Data Collection Form that summarizes our audit findings. It is management's responsibility to submit the reporting package (including financial statements, schedule of expenditures of federal awards, summary schedule of prior audit findings, auditors' reports, and corrective action plan) along with the Data Collection Form to the federal audit clearinghouse. We will coordinate with you the electronic submission and certification. if applicable, we will provide copies of our report for you to include with the reporting package you will submit to pass-through entities.The Data Collection Form and the reporting package must be submitted within the earlier of 30 days after receipt of the auditors' reports or nine months after the end of the audit period, unless a longer period is agreed to in advance by the cognizant or oversight agency for audits. The audit documentation for this engagement is the property of Brockway, Gersbach, Franklin&Niemeier, P. C. and constitutes confidential information. However, pursuant to authority given by law or regulation, we may be requested to make certain audit documentation available to a federal agency providing direct or indirect funding or the U.S. Government Accountability Office for purposes of a quality review of the audit, to resolve audit findings, or to carry out oversight responsibilities. We will notify you of any such request. If requested, access to such audit documentation will be provided under the supervision of Brockway, Gersbach, Franklin & Niemeier, P. C. personnel. Furthermore, upon request, we may provide copies of selected audit documentation to the aforementioned parties. These parties may intend, or decide, to distribute the copies or information contained therein to others, including other governmental agencies. The audit documentation for this engagement will be retained for a minimum of five years after the report release or for any additional period requested by the City. If we are aware that a federal awarding agency, pass-through entity, or auditee is contesting an audit finding, we will contact the party(ies) contesting the audit finding for guidance prior to destroying the audit documentation.. I City of Round Rock, Texas Page Seven i We expect to begin our audit on approximately July, 2012 and to issue our reports no later than January, 2013. Steve Niemeier is the engagement partner and is responsible for supervising the engagement and signing the reports or authorizing another individual to sign them. Our fee for these services will be at our standard hourly rates; we agree that our gross fee, including expenses, will not exceed $ 97,700. Our standard hourly rates vary according to the degree of responsibility involved and the experience level of the personnel assigned to your 1 audit. Our invoices for these fees will be rendered each month as work progresses and are payable on policies, work may be suspended if your account becomes 30 days or presentation. In accordance with our firm . more overdue and may not be resumed until your account is paid in full. If we elect to terminate our services for nonpayment, our engagement will be deemed to have been completed upon written notification of termination, even if we have not completed our report(s). You will be obligated to compensate us for all time expended and to reimburse us for all out-of-pocket costs through the date of termination. The above fee is based on anticipated cooperation from your personnel and the assumption that unexpected circumstances will not be encountered during the audit. If significant additional time is necessary, we will discuss it with you and arrive at a new fee estimate before we incur the additional costs. We have attached Appendix C that provides the estimated audit fees for the next four years as included in our proposal submitted on March 6,2012. Government Auditing Standards require that we provide you with a copy of our most recent external peer review report and any letter of comment, and any subsequent peer review reports and letters of comment received during the period of the contract.Our 2009 peer review report accompanies this letter. We appreciate the opportunity to be of service to the City of Round Rock, Texas and believe this letter accurately summarizes the significant terms of our engagement. If you have any questions, please let us know. If you agree with the terms of our engagement as described in this letter, please sign the enclosed copy and return it to us. Sincerely, Brockway,Gersbach, Frpnklin&Niemeier,P.C. RESPONSE: This letter correctly sets forth the understanding of the City of Round Rock, Texas By: Title: Date: F 6 City of Round Rock,Texas Page Eight ATTACHMENT C ESTIMATED HOURS AND FEES FOR SERVICES FISCAL YEAR 2012 ESTIMATED HOURLY TOTAL TITLE HOURS RATE (Hours X Rate) PARTNERS 160 170 $ 27,200 MANAGERS 190 105 19,950 SUPERVISORY STAFF 410 77 31,570 STAFF 250 70 17,500 OTHER(Please Specify) Administrative support staff 30 50 1,500 Rounding (20) TOTALS FOR FISCAL YEAR 2012 1,040 $ 97,700 3 i City of Round Rock,Texas Page Nine 3 1 ATTACHMENT C E ESTIMATED HOURS AND FEES FOR SERVICES FISCAL YEAR 2013 ESTIMATED HOURLY TOTAL TITLE HOURS RATE (Hours X Rate) PARTNERS 160 172 $ 27,520 MANAGERS 190 107 20,330 SUPERVISORY STAFF 410 79 32,390 STAFF 250 72 18,000 OTHER(Please Specify) Administrative support staff 30 52 1,560 Rounding TOTALS FOR FISCAL YEAR 2013 1,040 $ 99,800 i i City of Round Rock,Texas Page"ren 3 ATTACHMENT C ESTIMATED HOURS AND FEES FOR SERVICES FISCAL YEAR 2014 i ESTIMATED HOURLY TOTAL 1 TITLE HOURS RATE (Hours X Rate) � i PARTNERS 160 174 $ 27,840 MANAGERS 190 109 20,710 s SUPERVISORY STAFF 410 81 33,210 STAFF 250 74 18,500 3 3 { a OTHER(Please Specify) 1 Administrative support staff 30 54 1,620 I Rounding 20 i TOTALS FOR FISCAL YEAR 2014 1,040 $ 101,900 q S 3 S i City of Round Rock, Texas Page Eleven j ATTACHMENT C i ESTIMATED HOURS AND FEES FOR SERVICES FISCAL YEAR 2015 ESTIMATED HOURLY TOTAL TITLE HOURS RATE (Hours X Rate) PARTNERS 160 176 $ 28,160 MANAGERS 190 111 21,090 SUPERVISORY STAFF 410 83 34,030 STAFF 250 76 19,000 OTHER(Please Specify) Administrative support staff 30 56 1,680 Rounding 40 TOTALS FOR FISCAL YEAR 2015 1,040 $ 104,000 I City of Round Rock,Texas Page Twelve ATTACHMENT C ESTIMATED HOURS AND FEES FOR SERVICES FISCAL YEAR 2016 ESTIMATED HOURLY TOTAL TITLE HOURS RATE (Hours X Rate) PARTNERS 160 178 $ 28,480 MANAGERS 190 113 21,470 SUPERVISORY STAFF 410 85 34,850 STAFF 250 78 19,500 ' OTHER(Please Specify) Administrative support staff 30 58 1,740 Rounding (40) TOTALS FOR FISCAL YEAR 2016 1,040 $ 106,000 Carneiro,Chumney&Co., L.C. Robert M. McAdams, CPA CERTIFIED PUBLIC ACCOUNTANTS Allen E. Robertson,Jr., CPA Paul Roth-RoFfy, CPA Edward H.Guerra, CPA Julia C. Norton,CPA Michael J. Schaub, CPA I I F i S E System Review Report September 22, 2009 r To the Shareholders of Brockway Gersbach Franklin & Niemeier PC and the Peer Review Committee of the Texas Society of CPAs We have reviewed the system of quality control for the accounting and auditing practice of : Brockway Gersbach Franklin & Niemeier PC (the firm) in effect for the year ended April 30, 2009. Our peer review was conducted in accordance with the Standards for Performing and Reporting on Peer Reviews established by the Peer Review Board of the American Institute of Certified Public Accountants. The firm is responsible for designing a system of quality control and complying with it to provide the firm with reasonable assurance of performing and reporting r in conformity with applicable professional standards in all material respects. Our responsibility is to express an opinion on the design of the system of quality control and the firm's compliance therewith based on our review. The nature, objectives, scope, limitations of, and the procedures performed in a System Review are described in the standards at www.aicpa.ora/prsummarv. As required by the standards, engagements selected for review included (engagements performed under the Government Auditing Standards and audits of employee benefit plans. In our opinion, the system of quality control for the accounting and auditing practice of Brockway Gersbach Franklin & Niemeier PC, in effect for the year ended April 30, 2009, has been suitably designed and complied with to provide the firm with reasonable assurance of performing and reporting in conformity with applicable professional standards in all material respects. Firms can receive a rating of pass, pass with deficiency(ies) or fail. Brockway Gersbach Franklin & Niemeier PC has received a peer review rating of pass. f i �. c� r -Helping Clients Succeed for more than 75 Years" 40 N.E.Loop 410,Suite 200•San Antonio,Texas 78216-5876 (210)342-8000•Fax(210)342-0866 E-mail:carneiro@carneiro.com •www.carnelro.com An Independent Member of the BDO Seidman Alliance ROUNDROCK,TEXAS City Council Agenda Summary Sheet PURPOSE.PASSION.PROSPERITY. i i Agenda Item No. G3. Consider a resolution selecting an accounting firm for the annual audit for the fiscal year Agenda Caption: ending September 30, 2012 and for each of the four subsequent years. Meeting Date: May 24, 2012 Department: Finance Staff Person making presentation: Cheryl Delaney Finance Director Item Summary: The City's charter requires an annual audit of the financial records to be performed by an independent certified public accountant. The objective of the audit is the expression of an opinion as to whether the City's financial statements are fairly presented in conformity with generally accepted accounting principles. Other objectives f include reporting on internal controls related to the financial statements and compliance with laws, regulations, and the provisions of contracts or grant agreements in accordance with Government Auditing Standards and Single Audit t Act requirements. The audit provides an independent examination of financial records, activities and operations to assess internal control practices, compliance with regulations, grant terms, bond covenants, contractual requirements and fairness of the presentation of financial information. The firm also provides valuable ideas and observations intended to help achieve the City's objectives in maintaining adequate financial controls, policies, and procedures. 4 In response to a Request for Proposals for audit services issued in February, the City received ten responses. The audit services selection committee evaluated the responses and interviewed the top three firms. The committee recommends award to Brockway, Gersbach, Franklin & Niemeier, P.C. } l Cost: $97,700 i Source of Funds: General Fund & Utility Fund F Date of Public Hearing(if required): N/A Recommended Action: Approval f r f a i i s i f i 4 i t Y E a x ` BROCKWAY rip. GERSBACH FRANKLIN & NIEMEIER,P.C. { CERTIFIED PUBLIC ACCOUNTANTS i i May 7, 2012 City of Round Rock, Texas : 221 E. Main Street Round Rock, Texas 78664-5299 We are pleased to confine our understanding of the services we are to provide the City of Round Rock, Texas for the year ended September 30, 2012. We will audit the financial statements of the governmental activities, the business-type activities, the aggregate discretely presented component units, each major fund, and the aggregate remaining fund information, which collectively comprise the basic financial statements of the City of Round Rock, Texas as of and for the year ended September 30, 2012. Accounting standards generally accepted in the United States of America provide for certain required supplementary information (RSI), such as management's discussion and analysis(MD&A),to supplement the City of Round Rock, Texas' basic financial statements. Such information, although not a part of the basic financial statements, is required by the Governmental Accounting Standards Board who considers it to be an essential part of financial reporting for placing the basic financial statements in an appropriate operational, economic, or historical context. As part of our engagement, we will apply certain limited procedures to City of Round Rock, Texas' RS1 in accordance with auditing standards generally accepted in the United States of America. These limited procedures will consist of inquiries of management regarding the methods of preparing the information and comparing the information for consistency with management's responses to our inquiries, the basic financial statements, and other knowledge we obtained during our audit of the basic financial statements. We will not express an opinion or provide any assurance on the information because the limited procedures do not provide us with sufficient evidence to express an opinion or provide any assurance. The following RSI is required by generally accepted accounting principles and will be subjected to certain limited procedures, but will not be audited: 1. Management's Discussion and Analysis 2. Budgetary Comparison Schedules 3. GASB—Required Supplementary Pension and OPEB Schedules l 61, `� "✓ POST OFFICE Box 4083 ■TEMPLE,TExns 76505-4083 ■ 254.773.9907 ■ FAx 254.773.1570 S City of Round Rock, Texas Page Two We have also been engaged to report on supplementary information other than RSI that accompanies the City of Round Rock, Texas' financial statements. We will subject the following supplementary information to the auditing procedures applied in our audit of the financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the -financial statements or to the financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America and will provide an E opinion on it in relation to the financial statements as a whole: 1. Combining and Individual Fund Statements and Schedules 2. Schedule of Expenditures of Federal Awards The following other information accompanying the financial statements will not be subjected to the auditing procedures applied in our audit of the financial statements, and for which our auditor's report will not provide an opinion or any assurance. g 1. Introductory Section 2. Statistical Data Audit Objectives The objective of our audit is the expression of opinions as to whether your basic financial statements are fairly presented, in all material respects, in conformity with U. S. generally accepted accounting principles and to report on the fairness of the supplementary information referred to in the second paragraph when considered in relation to the basic financial statements as a whole. The objective also includes reporting on— • Internal control related to the financial statements and compliance with laws, regulations, and the provisions of contracts or grant agreements, noncompliance with which could have a material effect on the financial statements in accordance with Government Auditing Standards. i' • Internal control related to major programs and an opinion (or disclaimer of opinion) on compliance with laws,regulations, and the provisions of contracts or grant agreements that could have a direct and material effect on each major program in accordance with the Single Audit Act Amendments of 1996 and OMB Circular A-133,Audits of States, Local Governments, and Non-Profit Organizations. ' The reports on internal control and compliance will each include a statement that the report is intended solely for the information and use of management, the body or individuals charged with governance, others within the entity, specific legislative or regulatory bodies, federal awarding agencies, and if applicable, pass-through entities and is not intended to be and should not be used by anyone other than these specified parties. r r f: v k; y; t City of Round Rock, Texas Page Three i Our audit will be conducted in accordance with auditing standards generally accepted in the United States of i America; the standards for financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States; the Single Audit Act Amendments of 1996; and the provisions of OMB ! Circular A-133, and will include tests of accounting records, a determination of major program(s) in accordance with OMB Circular A-133 and will include test of accounting records, a determination of major program(s) in accordance with OMB Circular A-133, and other procedures we consider necessary to enable us to express such opinions and to render the required reports. if our opinions on the financial statements or the Single Audit compliance opinions are other than unqualified, we will discuss the reasons with you in advance. If, for any reason, we are unable to complete the audit or are unable to form or have not formed opinions, we may decline to express opinions or to issue a report as a result of this engagement. i It Management Responsibilities Management is responsible for the basic financial statements and all accompanying information as well as all representations contained therein. Management is also responsible for identifying government award programs and understanding and complying with the compliance requirements, and for preparation of the schedule of expenditures of federal awards in accordance with the requirements of OMB Circular A-133. As part of the audit, we will assist with preparation of your financial statements, schedule of expenditures of federal awards, and related notes. You are responsible for making all management decisions and performing all management functions relating to the financial statements, schedule of expenditures of federal awards, and related notes and for accepting full responsibility for such decisions. You will be required to acknowledge in the management representation letter our assistance with the preparation of the financial statements and the schedule of expenditures of federal awards and that you have reviewed and approved the financial statements, schedule of expenditures of federal awards, and related notes prior to their issuance and have accepted responsibility for them. Further, you are required to designate an individual with suitable skill, knowledge, or experience to oversee any nonaudit services we provide and for evaluating the adequacy and results of those services and accepting responsibility for them. Management is responsible for establishing and maintaining effective internal controls, including internal controls over compliance, and for evaluating and monitoring ongoing activities, to help ensure that appropriate goals and objectives are met and that there is reasonable assurance that government programs are administered in compliance with compliance requirements. You are also responsible for the selection and application of accounting principles; for the fair presentation in the financial statements of the respective financial position of the governmental activities, the business-type activities, the aggregate discretely presented component units, each major fund, and the aggregate remaining fund information of the City of Round Rock, Texas and the respective changes in financial position and, where applicable, cash flows in conformity with U.S. generally accepted accounting principles; and for compliance with applicable laws and regulations and the provisions of contracts and grant agreements. Management is also responsible for making all financial records and related information available to us and for ensuring that management and financial information is reliable and properly recorded. Your responsibilities also include identifying significant vendor relationships in which the vendor has responsibility for program compliance and for the accuracy and completeness of that information. Your responsibilities include adjusting the financial statements to correct material misstatements and confirming to us in the representation letter that the effects of any uncorrected misstatements aggregated by us during the current engagement and pertaining to the latest period presented are immaterial, both individually and in the aggregate, to the financial statements taken as a whole. t / 1 1� i 1 1 City of Round Rock, Texas Page Four j i You are responsible for the design and implementation of programs and controls to prevent and detect fraud, and for informing us about all known or suspected fraud or illegal acts affecting the government involving (1) j management, (2) employees who have significant roles in internal control, and (3) others where the fraud or illegal acts could have a material effect on the financial statements. Your responsibilities include informing us of your knowledge of any allegations of fraud or suspected fraud affecting the government received in communications from employees, former employees, grantors, regulators, or others. In addition, you are responsible for identifying and ensuring that the entity complies with applicable laws and regulations, contracts, equired by OMB Circular A-133, it is management's responsibility to agreements and grants. Additionally, as r follow up and take corrective action on reported audit findings and to prepare a summary schedule of prior audit findings and a corrective action plan. You are responsible for the preparation of the supplementary information in conformity with U.S. generally accepted accounting principles. You agree to include our report on the supplementary information in any document that contains and indicates that we have reported on the supplementary information. You also agree to include the audited financial statements with any presentation of the supplementary information that includes our report thereon. Management is responsible for establishing and maintaining a process for tracking the status of audit findings and recommendations. Management is also responsible for identifying for us previous financial audits, attestation engagements, performance audits, or other studies related to the objectives discussed in the Audit Objectives section of this letter. This responsibility includes relaying to us corrective actions taken to address significant findings and recommendations resulting from those audits, attestation engagements, performance audits, or _ studies. You are also responsible for providing management's views on our current findings, conclusions, and recommendations, as well as your planned corrective actions, for the report, and for the timing and format for providing that information. Audit Procedures—General An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements; therefore, our audit will involve judgment about the number of transactions to be examined and the areas to be tested. We will plan and perform the audit to obtain reasonable rather than absolute assurance about whether the financial statements are free of material misstatement, whether from (1) errors, (2) fraudulent financial reporting, (3) misappropriation of assets, or (4) violations of laws or governmental regulations that are attributable to the entity or to acts by management or employees acting on behalf of the entity. Because the determination of abuse is subjective, Government Auditing Standards do not expect auditors to provide reasonable assurance of detecting abuse. Because an audit is designed to provide reasonable, but not absolute assurance and because we will not perform a detailed examination of all transactions, there is a risk that material misstatements or noncompliance may exist and not be detected by us. In addition, an audit is not designed to detect immaterial misstatements or violations of laws or governmental regulations that do not have a direct and material effect on the financial statements or major programs. However, we will inform you of any material errors and any fraudulent financial reporting or misappropriation of assets that comes to our attention. We will also inform you of any violations of laws or governmental regulations that come to our attention, unless clearly inconsequential and of any material abuse that comes to our attention. We will include such matters in the reports required for a Single Audit. Our responsibility as auditors is limited to the period covered by our audit and does not extend to any later periods for which we are not engaged as auditors. City of Round Rock, Texas Page Five Our procedures will include tests of documentary evidence supporting the transactions recorded in the accounts, and may include tests of the physical existence of inventories, and direct confirmation of receivables and certain other assets and liabilities by correspondence with selected individuals, funding sources, creditors, and financial institutions. We will request written representations from your attorneys as part of the engagement, and they may bill you for responding to this inquiry. At the conclusion of our audit, we will also require certain written representations from you about the financial statements and related matters. YAudit Procedures—Internal Controls Our audit will include obtaining an understanding of the entity and its environment, including internal control, sufficient to assess the risks of material misstatement of the financial statements and to design the nature, timing, and extent of further audit procedures. Tests,of controls may be performed to test the effectiveness of certain controls that we consider relevant to preventing and detecting errors and fraud that are material to the financial statements and to preventing and detecting misstatements resulting from illegal acts and other noncompliance matters that have a direct and material effect on the financial statements. Our tests, if performed, will be less in scope than would be necessary to render an opinion on internal control and, accordingly, no opinion will be expressed in our report on internal control issued pursuant to Government Auditing Standards. k As required by OMB Circular A-133, we will perform tests of controls over compliance to evaluate the effectiveness of the design and operation of controls that we consider relevant to preventing or detecting material noncompliance with compliance requirements applicable to each major federal award program. However, our tests will be less in scope than would be necessary to render an opinion on those controls and, accordingly, no opinion will be expressed in our report on internal control issued pursuant to OMB Circular A-133. An audit is not designed to provide assurance on internal control or to identify significant deficiencies. However, during the audit, we will communicate to management and those charged with governance internal control related matters that are required to be communicated under AICPA professional standards, Government Auditing Standards, and OMB Circular A-133. Audit Procedures---Compliance As part of obtaining reasonable assurance about whether the financial statements are free of material misstatement, we will perform tests of the City of Round Rock, Texas' compliance with applicable laws and regulations and the provisions of contracts and agreements, including grant agreements. However, the objective of those procedures will not be to provide an opinion on overall compliance and we will not express such an opinion in our report on compliance issued pursuant to Government Auditing Standards. OMB Circular A-133 requires that we also plan and perform the audit to obtain reasonable assurance about i whether the auditee has complied with applicable laws and regulations and the provisions of contracts and grant agreements applicable to major programs. Our procedures will consist of tests of transactions and other applicable procedures described in the OMB Circular A-133 Compliance Supplement for the types of compliance requirements that could have a direct and material effect on each of City of Round Rock, Texas' major programs. The purpose of those procedures will be to express an opinion on the City of Round Rock, Texas' compliance with requirements applicable to each of its major programs in our report on compliance issued pursuant to OMB Circular A-133. t 4t F I I City of Round Rock, Texas Page Six I Engagement Administration,Fees,and Other We may from time to time, and depending on the circumstances, use third-party service providers in serving your account. We may share confidential information about you with these service providers, but remain committed to maintaining the confidentiality and security of your information. Accordingly, we maintain internal policies, procedures, and safeguards to protect the confidentiality of your personal information. In addition, we will secure confidentiality agreements with all service providers to maintain the confidentiality of your information and we will take reasonable precautions to determine that they have appropriate procedures in place to prevent the unauthorized release of your confidential information to others. In the event that we are unable to secure an appropriate confidentiality agreement, you will be asked to provide your consent prior to the sharing of your confidential information with the third-party service provider. Furthermore, we will remain responsible for the work provided by any such third-party service providers. We understand that your employees will prepare all cash, accounts receivable, or other confirmations we request and will locate any documents selected by us for testing. At the conclusion of the engagement, we will complete the appropriate sections of the Data Collection Form that summarizes our audit findings. It is management's responsibility to submit the reporting package (including f financial statements, schedule of expenditures of federal awards, summary schedule of prior audit findings, auditors' reports, and corrective action plan) along with the Data Collection Form to the federal audit clearinghouse. We will coordinate with you the electronic submission and certification. If applicable, we will provide copies of our report for you to include with the reporting package you will submit to pass-through i entities.The Data Collection Form and the reporting package must be submitted within the earlier of 30 days after receipt of the auditors' reports or nine months after the end of the audit period, unless a longer period is agreed to f in advance by the cognizant or oversight agency for audits. The audit documentation for this engagement is the property of Brockway, Gersbach, Franklin &Niemeier, P. C. and constitutes confidential information. However, pursuant to authority given by law or regulation, we may be requested to make certain audit documentation available to a federal agency providing direct or indirect funding or the U.S. Government Accountability Office for purposes of a quality review of the audit, to resolve audit findings, or to cant' out oversight responsibilities. We will notify you of any such request. If requested, access to such audit documentation will be provided under the supervision of Brockway, Gersbach, Franklin & Niemeier, P. C. personnel. Furthermore, upon request, we may provide copies of selected audit documentation to the aforementioned parties. These parties may intend, or decide, to distribute the copies or information contained therein to others, including other governmental agencies. t The audit documentation for this engagement will be retained for a minimum of five years after the report release or for any additional period requested by the City. If we are aware that a federal awarding agency, pass-through entity, or auditee is contesting an audit finding, we will contact the party(ies) contesting the audit finding for guidance prior to destroying the audit documentation. a i I i City of Round Rock, Texas s Page Seven I i We expect to begin our audit on approximately July, 2012 and to issue our reports no later than January, 2013. P g Steve Niemeier is the engagement partner and is responsible for supervising the engagement and signing the reports or authorizing another individual to sign them. Our fee for these services will be at our standard hourly 9 rates; we agree that our gross fee, including expenses, will not exceed $ 97,700. Our standard hourly rates vary according to the degree of responsibility involved and the experience level of the personnel assigned to your I audit. Our invoices for these fees will be rendered each month as work progresses and are payable on presentation. In accordance with our firm policies, work may be suspended if your account becomes 30 days or more overdue and may not be resumed until your account is paid in full. If we elect to terminate our services for nonpayment, our engagement will be deemed to have been completed upon written notification of termination, even if we have not completed our report(s). You will be obligated to compensate us for all time expended and to reimburse us for all out-of-pocket costs through the date of termination. The above fee is based on anticipated cooperation from your personnel and the assumption that unexpected circumstances will not be encountered during the audit. If significant additional time is necessary, we will discuss it with you and arrive at a new fee estimate before we incur the additional costs. We have attached Appendix C that provides the estimated audit fees for the next four years as included in our proposal submitted on March 6, 2012. Government Auditing Standards require that we provide you with a copy of our most recent external peer review report and any letter of comment, and any subsequent peer review reports and letters of comment received during the period of the contract. Our 2009 peer review report accompanies this letter. We appreciate the opportunity to be of service to the City of Round Rock, Texas and believe this letter accurately 1 summarizes the significant terms of our engagement. If you have any questions, please let us know. If you agree with the terms of our engagement as described in this letter, please sign the enclosed copy and return it to us. E Sincerely, A b� g Brockway,Gersbach, Frfmklin&Niemeier, P. C. RESPONSE: \ n } This letter correctly sets forth the understanding of the City of Round Rock, Texas By: Y t yl�Title: Date: s s 1 1 4 t 4 ) . � City oRound Rock, Texas Page Eight | ) ATTACHMENT C | ESTIMATED HOURS AND FEES FOR SERVICES FISCAL YEAR 2012 [ � [ ESTIMATED HOURLY TOTAL ( TITLE HOURS RATE (Hogsk Rat) ( . ( . [ PARTNERS 16 17 $ 27,200 { . ( MANAGERS 19 10 19,950 ( { � t SUPERVISORY STAFF 410 77 31,57 [ STAFF 250 7 17,500 ( OTHER(Please Specify) } Administrative support staff ]O 50 1,50 ' } Rounding (20 TOTALS FOR FISCAL YEAR 2012 1;4 $ 97,700 � � | � { { ( � - [ ( . � ( ( [ ( ( ( ( ) - � Ci of Ron Rock, Texas ) P p Nin ATTACHMENT C ) : | ESTIMATED HOURS AND FEES FOR SERVICES ( FISCAL Y£AR 2013 ( � . | ESTIMATED HOURLY TOTAL TITLE HOURS RATE (Hours k Rate { � - ( PARTNERS 16 17 $ 2;2 [ � [ MANAGERS 19 10 20,330 ( SUPERVISORY STAFF 410 7 32,390 STAFF 250 7 18,000 ( { . ( OTHER(Please Specify) [ Administrative support Sag 30 52 1,56 ( ( ( [ Rounding [ TOTALS FOR FISCAL YEAR 2013 1,040 $ 99,800 [ / ( ( \ [ [ [ ( [ [ [ ( [ [ . [ / [ [ 9 R Y, ' City of Round Rock, Texas Page Ten ATTACHMENT C ESTIMATED HOURS AND FEES FOR SERVICES FISCAL YEAR 2014 ESTIMATED HOURLY TOTAL TITLE HOURS RATE (Hours X Rate) PARTNERS 160 174 $ 27,840 MANAGERS 190 109 20,710 SUPERVISORY STAFF 410 81 33,210 STAFF 250 74 18,500 i OTHER(Please Specify) Administrative support staff 30 54 1,620 Rounding 20 3' i TOTALS FOR FISCAL YEAR 2014 1,040 $ 101,900 4. a F i 4 F f f 3 . � � | � Ci of Round Rock, Texas . [ Page E1vn ( [ ATTACHMENT C ESTIMATED HOURS AND£££S FOR SERVICES FISCAL YEAR 2l5 ( ESTIMATED HOURLY TOTAL \ TITLE HOURS ATE (Hours k Rate) � � ( . [ ( PARTNERS 16 17 $ 28,16 ( � { MANAGERS 19 111 21$9 ( [ . [ SUPERVISORY STAFF 410 8 34,030 ( � ( STAFF 250 7 19,000 { [ OTHER(Please Specify) Administrative support Sag 30 56 1,68 . . [ ( , [ [ Rounding 4 | TOTALS FOR FISCAL YEAR2015 1,040 $ 30;0 � ( [ [ ( � { ( { � ( ( \ { . � � City of Round Rock, Texas [ Page Twelve ( \ ! ATTACHMENT C { [ ESTIMATED HOURS AND FEES FOR SERVICES ( FISCAL YEAR 2l6 E � ( ( ESTIMATED HOURLY TOTAL [ TITLE HOURS RATE (Hours k Rate . ( { PARTNERS 16 178 % 28,48 \ MANAGERS 19 113 21&7 \ SUPERVISORY STAFF 410 85 14,850 i STAFF 250 78 1$50 \ ( OTHER(Please Specify) { Administrative support mag 30 58 1,740 / � ( � � | . � [ Rounding (40 ( ) . � TOTALS FOR FISCAL YEAR 2 16 1,040 $ 106,000 [ � [ � ( � ( \ ( � ( E . [ � [ 1 [ � ( ( { � { ( { 1 Carneiro,Chumney&Co., L.C. Robert M. McAdams, CPA CERTIFIED PUBLIC ACCOUNTANTS Allen E. Robertson, Jr., CPA Paul Roth-RoFfy, CPA Edward H. Guerra, CPA Julia C. Norton,CPA Michael J. Schaub, CPA f } A System Review Report i September 22, 2009 b S: To the Shareholders of Brockway Gersbach Franklin & Niemeier PC and the Peer Review Committee of the Texas Society of CPAs i We have reviewed the system of quality control for the accounting and auditing practice of Brockway Gersbach Franklin & Niemeier PC (the firm) in effect for the year ended April 30, 2009. Our peer review was conducted in accordance with the Standards for Performing and Reporting on Peer Reviews established by the Peer Review Board of the American Institute of x. Certified Public Accountants. The firm is responsible for designing a system of quality control t and complying with it to provide the firm with reasonable assurance of performing and reporting in conformity with applicable professional standards in all material respects. Our responsibility is to express an opinion on the design of the system of quality control and the firm's compliance therewith based on our review. The nature, objectives, scope, limitations of, and the procedures i performed in a System Review are described in the standards at www.aicpa.org/Drsummary. As required by the standards, engagements selected for review included (engagements performed under the Government Auditing Standards and audits of employee benefit plans. In our opinion, the system of quality control for the accounting and auditing practice of Brockway Gersbach Franklin & Niemeier PC, in effect for the year ended April 30, 2009, has been suitably designed and complied with to provide the firm with reasonable assurance of performing and reporting in conformity with applicable professional standards in all material respects. Firms can receive a rating of pass, pass with deficiency(ies) or fail. Brockway Gersbach Franklin & Niemeier PC has received a peer review rating of pass. F" r f: "Helping Clients Succeed for more than 75 Years" 40 N.E. Loop 410,Suite 200•San Antonio,Texas 78216-5876 (210)342-8000•Fax(210)342-0866 E-mail:carneiro@carneiro.com -www.carneiro.com An Independent Member of the BDO Seidman Alliance