Loading...
HomeMy WebLinkAbout1993-01-19; City Council; 12037; SOLICITATION OF REQUEST FOR PROPOSALS RFP FOR FINANCIAL AUDITI' 2 2 z 0 F 0 a 6 z 3 0 0 AB # 1Ai037 TITLE: DEPT.' MTG. 01/19/93 SOLICITATION OF REQUEST FOR CITY I CITY I DEPT. F1N RE&MMEMbEb A€!T16N! PROPOSALS (RFP) FOR FINANCIAL AUDIT Adopt Resolution No. 73-1 3 authorizing the solicitation of Requests for Proposals t certain audit firms to perfom the City's financial audit for fiscal years 1992-93, 1993-9 and 1994-95. ITEM EXPLANATION: The City has retained the certified public accounting firm of KPMG Peat Manvick to perfor! audit services for the City for the last five years. Although the Finance Department satisfied with their services, periodically it is necessary to request proposals from pub1 accounting firms to assure service and price competitiveness. A Request for Proposal (RFP) for professional auditing services has been prepared by tl: Finance Department. The RFP is for a three year period and includes the following items t Audit of the City of Carlsbad's Comprehensive Annual Financial Report t Agreed-upon procedures for calculation of the Gam Limit b Audit of the Public Improvement Corporation b Audit of the Parking Authority t Audit of the Redevelopment Agency b Audit of the Encina Financing Joint Powers Authority t Single Audit It will be sent to selected major public accounting firms and to several auditing firms th have expressed interest in participating in the process. Responses to the RFP are to 1 received by February 26. Staff will bring recommendations back to Council for fin selection in March. FISCAL IMPACT: All of the 1992-93 auditing budget of $36,000 will be utilized for the services related to t 1991-92 audit. Cost of the 1992-93 audit will be included in the 1993-94 operating budg EXHIBITS : 1. Resolution No. 5'3 -13 authorizing the solicitation of Request for Proposals certain audit firms to perform the City's financial audit for fiscal years 1992-93, 195 94, and 1994-95. 2. Request for Proposal Bid List 1992/93 Audit. 3. XequLest for Proposals for Professional Auditing Services January, 1993. ’ L ve 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 0 e RESOLUTION NO. 9 3 - 13 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF CARLSBAD, CALIFORNIA, AUTHORIZING SOLICITATION OF REQUEST FOR PROPOSALS [RFP) FOR FINANCIAL AUDIT WHEREAS, an audit of the City of Carlsbad financial records is required by the City Council, WHEREAS, a Request for Proposal (RFP) for professional auditing services by public accounting firms has been prepared by the Finance Department, WHEREAS, funding is expected to be made available in the 1993-94 Operating Budget. NOW, THEREFORE, BE IT RESOLVED by the City Council for the City of Carlsbad, California, as follows: 1. 2. The above recitations are true and correct. The Finance Department is authorized to solicit proposals from public accounting firms for professional auditing services. PASSED, APPROVED AND ADOPTED at a regular meeting of the City Council on the 19th day of JANUARY, 1993, by the following vote, to wit: AYES: Council Members Lewis, Kulchin, Nygaard, Finnila NOES: None ABSENT: Council Member Stanton ATTEST: (SEAL) I LC 8 @"- I/ * 'd. 'NQUEST FOR PROPOSAL BID LI 1992193 AUDIT Calderon, Jaham & Osborn Certified Public Accountants 1236 State Street Suite 1400 El Centro CA 92243 (619) 352-6022 Conrad & Associates certified Public Accountants Deloitte, Touche Suite C Certified Public Accountants 1100 Main Street Suite 1900 Imine CA 92714 750 "B" Street (714) 474-2020 Peterson & Co. I Certified Public Accountants Price Waterhouse Suite 500 Certified Public Accountants 3655 Nobel Drive Suite 2400 San Diego CA 92122-1089 750 "B" Street (619) 597-4100 SanDiego CA 92101 Diehl, Evans & Company Certified Public Accountants Arthur Anderson 2965 Roosevelt Street Carlsbad CA 92008-2389 Suite 1600 (619) 729-2343 701 "B" Street Coopers & Lybrand Certified Public Accountants 402 West Broadway San Diego CA 92101-3504 (619) 525-2300 San Diego CA 92101-8198 (619) 232-6500 (619) 231-1200 Certified Public Accountants SanDiego CA 92101 KPMG Peat Marwick (619) 699-6600 Certified Public Accountants Suite 3000 750 "B" Street SanDiego CA 92101 (619) 525-3300 Ernst & Young Certified Public Accountants Suite 1100 501 W. Broadway SanDiego CA 92101 (619) 236-1100 Moreland & Associates Certified Public Accountants Suite 840 610 Newport Center Drive Newport Beach CA 92660 (714) 760-9788 B:\AGREEMENTS\AUDITRFP.LST -.. 0 0 I' 'l , CiTY OF CARLSBAD REQUEST FOR PROPOSALS FOR PROFESSIONAL AUDITING SERVICES JANUARY, 1993 CITY OF CARLSBAD 1200 CARLSBAD VILLAGE DRIVE CARLSBAD, CA 92008 0 0 jc CITY OF CARLSBAD REQUEST FOR PROPOSALS TABLE OF CONTENTS I. INTRODUCTION A. General Information B. Term of Engagement 11. NATURE OF SERVICES REQUIRED A. General B. C. D. Reports to be Issued E. Special Considerations F. Scope of Work to be Performed Auditing Standards to be Followed Working Paper Retention and Access to Working Papers Ill. DESCRIPTION OF THE GOVERNMENT A. 8. Background Information C. D. Pension Plans E. Component Units F. Joint Ventures G. Computer Systems H. Internal Audit Function I. Name and Telephone Number of Contact Persons/Organization Charts Federal and State Financial Assistance Availability of Prior Reports and Working Papers IV. TIME REQUIREMENTS A. Proposal Calendar B. Notification and Contract Dates C. Audit Schedule D. E. Final Reports ASSISTANCE TO BE PROVIDED TO THE AUDITOR A. Finance Department and Clerical Assistance 8. Internal Audit Staff Assistance C. Electronic Data Processing (EDP) Assistance D. Statements and Schedules to be Prepared by the Staff E. Work Area, Telephone, Photocopying and FAX Machines Entrance Conferences, Progress Reporting and Exit Conferences V. * 1 0 0 '< VI. PROPOSAL REQUIREMENTS A. General Requirements 1. 2. Inquiries 3. Submission of Proposals Preproposal Conference and On-site Inspections B. Technical Proposal 1. General Requirements 2. Independence 3. 4. Firm Qualifications and Experience 5. 6. 7. Specific Audit Approach 8. License to Practice in State of California Partner, Supervisory and Staff Qualifications and Experience Similar Engagements with Other Government Entities Identification of Anticipated Potential Audit Problems C. Cost Proposal 1. Total All-Inclusive Maximum Price 2. 3. Manner of Payment Rates for Additional Professional Services VII. EVALUATION PROCEDURES A. Audit Committee B. Review of Proposals C. Evaluation Criteria 1. Mandatory Elements 2. Technical Qualifications 3. Price D. Oral Presentations E. Final Selection F. Right to Reiect Proposals k e 0 Jf APPENDICES A. B. C. D. Gann Limit Verification Procedures E. Organizational Charts City of Carlsbad General Purpose Financial Statements, Fiscal Year 1991 -92 City of Carlsbad Schedule of Federal Financial Assistance, Fiscal Year 1990-91 Management Letter, Fiscal Year 1990-91 F, Example Contract 4 i 0 0 ’< CITY OF CARLSBAD REQUEST FOR PROPOSALS 1. INTRODUCTION A. General Information The City of Carlsbad is requesting proposals from qualified firms of certified public accountants to audit its financial statements for the three fiscal years ending June 30 1993, June 30, 1994, and June 30, 1995, with the option of auditing its financial statements for each of the two subsequent fiscal years. These audits are to be performed in accordance with generally accepted auditing standards, the standards set forth for financial audits in the General Accounting Office’s (GAO) Government Auditinq Standards (1 988), the provisions of the Federal Single Audit Act of 1984 anc U.S. Office of Management and Budget (OMB) Circular A-128, Audits of State and Local Govern me nts . There is no expressed or implied obligation for the City of Carlsbad to reimburse responding firms for any expenses incurred in preparing proposals in response to thi request. A preproposal conference for all the firms interested in submitting a proposal will be held at 3:OO p.m. on February 9, 1993 at Carlsbad City Hall, 1200 Carlsbad Village Drive, in the Council Chambers to answer questions about the engagement. After this preproposal conference, any inquiries concerning the request for proposals should be addressed to the Finance Director, Lisa Hildabrand. All interested audit firms will be provided with a copy of the minutes of the preproposal conference. To be considered, four (4) copies of a proposal must be received by Lisa Hildabranc at 1200 Carlsbad Village Drive, Carlsbad, CA 92008 by 4:OO p.m. on February 26, 1993. The City of Carlsbad reserves the right to reject any or all proposals submittec Proposals submitted will be evaluated by a four member Audit Committee, consistins of individuals from the Finance department and the City Manager’s office. During the evaluation process, the Audit Committee and the City of Carlsbad reserve the right, where it may serve the City of Carlsbad’s best interest, to request addition: information or clarifications from proposers, or to allow corrections of errors or omissions. At the discretion of the City of Carlsbad or the Audit Committee, firms submitting proposals may be requested to make oral presentations as part of the evaluation process. The City of Carlsbad reserves the right to retain all proposals submitted and to use any ideas in a proposal regardless of whether that proposal is selected. Submissior of a proposal indicates acceptance by the firm of the conditions contained in this request for proposals, unless clearly and specifically noted in the proposal submittec and confirmed in the contract between the City of Carlsbad and the firm selected. 5 1 c 0 0 It is anticipated the selection of a firm will be completed by March 12, 1993. Following the notification of the selected firm and Council approval, it is expected a contract will be executed between both parties by March 31 , 1993. B, Term of Engagement A three-year contract is contemplated, with an option to extend the contract for two additional years, subject to the annual review and recommendation of the Finance Director, the satisfactory negotiation of terms (including a price acceptable to both the City of Carlsbad and the selected firm), the approval of the Carlsbad City Council and the annual availability of an appropriation. II. NATURE OF SERVICES REQUIRED A. General The City of Carlsbad is soliciting the services of qualified firms of certified public accountants to audit its financial statements as well as the financial statements of its component units for the fiscal years ending June 30, 1993, June 30, 1994, and June 30, 1995, with the option to extend the contract for each of the two subsequent fisca years. These audits are to be performed in accordance with the provisions containec in this request for proposals. In addition, the City requires on-going, infrequent consulting services for financial issues that may occur throughout the year. No additional charges are to be made b the selected audit firm for these financial consulting services. B. Scope of Work to be Performed The City desires the auditor to express opinions on the fair presentation of the general purpose financial statements for the following entities in conformity with generally accepted accounting principles: 1. City as defined under GASB #1 and NCGA Statement #3 (these will be included in the comprehensive annual financial report) 2. Public Improvement Corporation of the City of Carlsbad 3. Parking Authority of the City of Carlsbad 4. Carlsbad Redevelopment Agency 5. Encina Financing Joint Powers Authority The auditor is not required to audit the supporting schedules contained in the comprehensive annual financial report (CAFR). However, the auditor is to provide a 6 a 0 +t "in-relation-to" opinion on the supporting schedules based on the auditing procedur applied during the audit of the general purpose financial statements. The auditor is not required to audit the statistical section of the report. The auditor is not required to audit the schedule of Federal financial assistance. However, the auditor is to provide an "in-relation-to" report on that schedule based c the auditing procedures applied during the audit of the financial statements. The auditor is also required to perform any additional tests or procedures as outlined in the Single Audit Act of 1984 and in the U.S. Office of Management and Budget (OM Circular A-1 28, Audits of State and Local Governments. In addition to the audit reports and management letter, the auditor shall perform certain Gann limit verification procedures for each of the years in the three year period for both the City of Carlsbad and the Carlsbad Municipal Water District. An example of these is contained in Appendix D. The auditor is also expected to provil informal advice and consultation throughout the year on matters relating to accounting and financial reporting. This would not include any task which entails significant research or a formal report. C. Auditing Standards To Be Followed To meet the requirements of this request for proposals, the audit shall be performed in accordance with generally accepting auditing standards as set forth by the American Institute of Certified Public Accountants, the standards for financial audits set forth in the U.S. General Accounting Office's Government Auditina Standards (1988), the provisions of the Single Audit Act of 1984 and the provisions of U.S. Offic of Management and Budget (OMB) Circular A-128, Audits of State and Local Governments. D. Reports to be Issued Following the completion of the audit of the fiscal year's financial statements, the auditor shall issue: I. A report on the fair presentation of the financial statements in conformity witt generally accepted accounting principles. 2. A report on the internal control structure based on the auditors' understanding of the control structure and assessment of control risk. 3. A report on compliance with applicable laws and regulations. 4. An "in-relation-to" report on the schedule of Federal financial assistance. 5. A report on the internal control structure used in administering Federal financial assistance programs. 7 ‘ e e ‘t 6. A report on compliance with specific requirements applicable to major Feder: financial assistance programs. 7. A report on compliance with specific requirements applicable to nonmajor Federal financial assistance programs. 8. A report on compliance with general requirements for both major and nonmajor Federal financial assistance programs. 9. Agreed-upon procedures reports regarding verification of the Gann limit. In the required reports on internal controls, the auditor shall communicate any reportable conditions found during the audit. A reportable condition shall be definec as a significant deficiency in the design or operation of the internal control structure, which could adversely affect the organization’s ability to record, process, summarize and report financial data consistent with the assertions of management in the financi statements. Reportable conditions that are also material weaknesses shall be identified as such i the report. Nonreportable conditions discovered by the auditors shall be reported in a separate letter to management, which shall be referred to in the reports on internal controls. The reports on compliance shall include a instances of noncompliance. Auditors shall be required to make an immediate, written report of all irregularities an illegal acts or indications of illegal acts of which they become aware to the City Council, City Manager, City Attorney, and Financial Management Director. E. Special Considerations 1. The City may send its CAFR to the Government Finance Officers Association of the United States and Canada for review in their Certificate of Achievement for Excellence in Financial Reporting program as well as to the California Society of Municipal Finance Officers for review in their reporting program. It is anticipated that the auditors will be required to provide special assistance to the City to me€ the requirements of these programs. The City has received both awards in the past. 2. The schedule of Federal financial assistance and related auditor’s report, as well as the reports on the internal controls and compliance are not to be included in the comprehensive annual financial report, but are to be issued separately. 8 * 0 0 #i 3. The Management Letter from the City’s most recent financial statement audit is attached to this document (Appendix C). Of those findings and other weaknesses, management believes that the following have not been resolved: a) With the exception of the General Fund, computerized monthly or quarterly condensed version of revenue/expenditure reports are not yet available. However, monthly reporting of financial data is being made to management and quarterly reporting to City Council. Recording of interest on contractor deposits continues to be recorded in the General Fund. No mandatory vacation policy exists. No reevaluation of the internal audit function nor annual internal audit plan is currently underway. b) c) No formal plan for disaster recovery has been developed, d) e) F. Working Paper Retention and Access to Working Papers All working papers and reports must be retained, at the auditor’s expense, for a minimum of three (3) years, unless the firm is notified in writing by the City of the need to extend the retention period. The auditor will be required to make working papers available, upon request, to the following parties or their designees: . Parties designated by the Federal or State governments or by the City as part of an audit quality review process Auditors of entities of which the City is a subrecipient of grant funds . In addition, the firm shall respond to the reasonable inquiries of successor auditors and allow successor auditors to review working papers relating to matters of continuing accounting significance. Ill. DESCRIPTION OF THE GOVERNMENT A. Name and Telephone Number of Contact Persons/Organizational Chart/Location of Off ices The auditor’s principal contact with the City will be Lisa Hildabrand, Finance Director or a designated representative, who will coordinate the assistance to be provided by the City to the auditor. Organizational charts of the City and the Finance department are attached (Appendi: E) - B. Background Information The City serves an area of 42 square miles with a population of 65,500. The City’s fiscal year begins on July 1 and ends on June 30. 9 I < e e The City provides the full range of services normally associated with a municipality including police, fire, parks and recreation, library, planning and zoning, building anc engineering, various maintenance services and administration. The City provides water and sewer services through the Carlsbad Municipal Water District, a subsidiaq district of the City. Solid waste collection is provided through a franchise arrangement with a local refuse collection service. The City has a total payroll of $21 million covering 480 full-time employees and 250 part-time employees. The City is organized into 19 departments and agencies. The accounting and financial reporting functions of the City are centralized, More detailed information on the government and its finances can be found in the 1992-93 Operating and Capital Budget and the 1991 -92 Comprehensive Annual Financial Report. Please contact Earlene Roper at 434-2867 to obtain copies. C. Federal and State Financial Assistance The City has received Federal financial assistance under the following programs for fiscal year 1991 -92: Catalog of Federal Domestic 1991 -92 Assistance # Program Expenditures Major Program: 14.1 56 Lower Income Housing Assistance Program (Section 8 - Existing Housing and State Agency Program $1,862,000 14.21 8 Community Development Block GranVEntitlement Grants 31 3,000 Nonmajor Programs: 14.777 Housing Voucher Program 252,000 13.633 Special Programs for the Aging, Title 111, Parts A & B Special Programs for the Aging, 8,000 13.636 Title Ill, Part C 165,000 10 I 0 e at Catalog of Federal Domestic 1 991 -92 Assistance # Program Expenditures Nonmajor Program (contd.) : 15.904 National Park Service, Dept. of the Interior (Historic Preservation) 1,000 84.034 Library Partnerships-for- Change (Latino Outreach) 69,000 In addition, the police asset forfeiture fund will be subject to the single audit in 1992- 93. Expenditures from this fund totaled $340,000 in fiscal year 1991 -92. D. Pension Plans The City participates in the California Public Employees Retirement System (PERS), an agent multiple-employer plan. Actuarial services for the plan is provided by PERS E. Component Units The City is defined, for financial reporting purposes, in conformity with the Governmental Accounting Standards Board's Codification of Governmental Accounting and Financial Reportinq Standards, Section 21 00. Using these criteria, component units are included in the City's financial statements. All component units have a fiscal year end of June 30 and are to be audited as part of the City's financial statements. The management of the City identified the following component units for inclusion in the City's financial statements: Public lmprovement Corporation - A non-profit corporation established for the purpos of financing and constructing improvements. Bonds have been issued for the Hosp Grove project. Parking Authority - Created pursuant to Parking Law of 1949 and authorized by Council in 1966. In 1969 and 1981 Parking Revenue Bonds were issued by the Authority for parking facilities at Plaza Camino Real Mall. The City makes annual lease payments to the authority. Carlsbad Redevelopment Agency - The agency was established in 1976 to eliminate blighted influences within the "Village Area," stimulate and attract private investment, generate added employment, and expand the city's sales tax revenue. In 1988, the agency issued tax allocation bonds to fund major infrastructure improvements. 11 1 I I a 0 F. Joint Ventures The City does participate in joint ventures with other governments as follows: Name of Name of Other Type of Joint Venture Participatinn Government(s1 Services Provided Encina Financing Buena Sanitation District In 1989, issued bonds totaling Joint Powers Leucadia Water District $33.5 million to finance Authority City of Vista expansion of the Encina Water Encina Buena Sanitation District Formed to operate the Encina Wastewater Leucadia Water District Water Pollution Control Facility Authority City of Vista Pollution Control Facility. City of Encinitas Vallecitos Water District G. Computer Systems HARDWARE Tvpe of Eauipment Number Networked? Hewlett Packard 3000/ 83 ports Yes Compaq PC numerous Yes 70 MP3 Operating System SOFTWARE Vendor Maior Applications Tamas Sierra Permits OnSite Fleet Maintenance Datastream Water Billing Knowles Clerk Indexing G/L, A/P, Purchase Orders, Payroll H. Internal Audit Function The City has one auditor whose primary focus is directed to external audits of Transient Occupancy Tax (TOT), business license tax, and sales tax. This individual reports to the Finance Director and does internal auditing on an as-requested basis only. 12 1 0 0 c I. Availability of Prior Audit Reports and Working Papers Interested proposers who wish to review prior years’ audit reports and management letters should contact Lisa Hildabrand at 1200 Carlsbad Village Drive, Carlsbad, 434 2867. The City will use its best efforts to make prior audit reports and supporting working papers available to proposers to aid their response to this request for proposals. IV. TIME REQUIREMENTS A. Proposal Calendar The following is a list of key dates up to and including the date proposals are due tc be submitted: Request for proposal issued January 20,1993 Preproposal conference February 9, 1993 Due date for proposals February 26, 1993 B. Notification and Contract Dates Selected firm notified March 12, 1993 Contract date March 26,1993 C. Audit Schedule The planning phase of the audit engagement may commence upon notification to tt- auditor of the acceptance of their proposal. The auditor shall provide the City with t audit plan and a list of schedules to be prepared by City personnel by the earlier of April 30 or prior to the beginning of fieldwork. Interim fieldwork would be expected t be performed in April or May with the final phase of fieldwork commencing in Augusi The City will have the books closed and all agreed upon schedules available for the auditors by August 20. The auditor shall have drafts of the final reports and recommendations to management available for review by the finance director by the following dates: CAFR September 30 Public Improvement Corp. August 31 Parking Authority August 31 Carlsbad Redevelopment Agency September 30 13 c e 0 Encina Financing Joint Powers Authority Single Audit October 31 Gann Limit Verifications August 31 August 31 Draft statistical data will be provided by the Finance department. D. Entrance Conferences, Progress Reporting and Exit Conferences An entrance conference should be scheduled prior to beginning interim fieldwork. Progress reports are expected on at least a monthly basis to the Finance Director. An exit conference to summarize the results of field work and to review significant findings is expected on the last day of field work or shortly thereafter. E. Final Reports The Finance department will complete their review of the draft report as expeditiousl) as possible. This process is not expected to exceed two weeks. During that period, the auditor should be available for any meetings that may be necessary to discuss the drafts. Once all issues for discussion are resolved, the final signed report shall b delivered to the Finance Director within ten working days. It is anticipated that this process will be completed and the final reports delivered by the following dates: CAFR October 31 Public Improvement Corp. September 30 Parking Authority September 30 Carlsbad Redevelopment Agency November 15 Encina Financing Joint Powers Authority September 30 Single Audit November 30 Gann Limit Verifications September 30 The final camera-ready comprehensive annual financial report and one double-sided of the CAFR will be the responsibility of the City. bound copy should be delivered to the Finance Director. All other copies to be mac 14 c i 0 0 The auditor is responsible for the printing and binding of the following numbers of other reports: Public improvement Corporation 15 Parking Authority 20 Carlsbad Redevelopment Agency 30 Encina Financing Joint Powers Authority 40 Single Audit 55 Gann Limit Verifications 5 V. ASSISTANCE TO BE PROVIDED TO THE AUDITOR AND REPORT PREPARATION A. Finance Department and Clerical Assistance The Finance Department staff and responsible management personnel will be available during the audit to assist the firm by providing information, documentation and explanations. The preparation of confirmations will be the responsibility of City, with the assistance of the auditor. In addition, reasonable clerical support will be made available to the auditor for the preparation of routine letters and memoranda. 6. Internal Audit Staff Assistance The internal audit staff of City will not be available to assist the auditor in performing audit tests. C. Electronic Data Processing (EDP) Assistance EDP personnel will be available to provide systems documentation and explanations, The auditor will not be provided computer time and the use of the City’s computer hardware and software unless mutually agreed upon. However, various computer reports will be provided to the auditor as required. 15 ? 1 f e 0 D. Statements and Schedules to be Prepared by the Staff of the City. The staff of City will prepare the following statements and schedules for the auditor. Additional statements or schedules may be prepared if mutually agreed upon in advance. - CAFR Single Audit Lotus Trial Balance Budgetary Statements Cash and Investments Cash with Fiscal Agent Interest Income Detail Income Statements Amortization of Discounts Footnote Disclosures Operating Transfers/ Fixed Asset Lead Sheet & Detail Accumulated Depreciation Income Statements GFAAG Schedule Leave Receivable Accounts Receivable Aging Analysis TOT Monthly Revenue by Source Property Tax Schedule Carlsbad Redevelopment Agencv Arbitrage Calculations Balance Sheets (per CAFR) P & L Analytical Review Income Statements (per CAFR) Payroll Detail Combining Balance Sheet/ Vacation Accrual Income Statement PERS Summary of Covered Payroll Schedule of Programs and Expenditure! Public Improvement Corporation Balance Sheets Residual Equity Transfers Parkinq Authority Balance Sheets Debt Amortization Schedule Budgetary Statements and Contributions Encina Financing Joint Powers Authority Balance Sheets Footnote Disclosures Income Statements E. Work Area, Telephones, Photocopying and FAX Machines The City will provide the auditor with reasonable work space, desks and chairs. The auditor will also be provided with access to a telephone line, photocopying facilities and FAX machines. Long-distance telephone and/or FAX communications will be charged to the auditor. 16 r a 0 VI. PROPOSAL REQUIREMENTS A. General Requirements 1. Preproposal Conference and On-site Inspections A conference for firms interested in submitting proposals will be held at 3:OO p.m on Tuesday, February 9, in the City of Carlsbad Council Chambers, 1200 Carlsbad Village Drive. Both verbal and written questions will be accepted during the conference. Minutes of the preproposal conference will be distributed to all firms requesting such minutes. Representatives of the various departments within the City will be available to discuss their operations and conduct on-site inspections for interested proposer! upon request. 2. Inquiries Inquiries concerning the request for proposals and the subject of the request for proposals must be made to: Lisa Hildabrand, Finance Director City of Carlsbad 1200 Carlsbad Village Drive Carlsbad, CA 92008 (61 9) 434-2867 CONTACT WITH PERSONNEL OF THE CITY OTHER THAN LISA HILDABRAND, FINANCE DIRECTOR, REGARDING THIS REQUEST FOR PROPOSALS MAY BE GROUNDS FOR ELIMINATION FROM THE SELECTION PROCESS. 3. Submission of Proposals Four copies of the Proposal are required to be received by February 26, 1993 for a proposing firm to be considered. The Proposal should include the following sections: a. Title Paqe Title page showing the request for proposals subject; the firm’s name; the the proposal. b. Table of Contents name, address and telephone number of the contact person; and the date 01 17 0 0 * c. Transmittal Letter A signed letter of transmittal briefly stating the proposer’s understanding of the work to be done, the commitment to perform the work within the time period, a statement why the firm believes itself to be best qualified to perforr the engagement and a statement that the proposal is a firm and irrevocable offer for fiscal years 1992-93, 1993-94 and 1994-95. d. Technical Proposal The technical proposal should follow the order set forth in Section VI B of th request for proposals. THERE SHOULD BE NO DOLLAR UNITS OR TOTAL COSTS INCLUDED IN THE TECHNICAL PROPOSAL SECTION e. Cost Proposal This section should be last and separately identified with a title page. All dollar units and/or total costs should be shown in this section, not in the technical proposal. f. Appendices or Exhibits Include as needed. The total proposal (not including appendices or exhibits) should not exceed twentyfive (25) paqes. Proposers should send the completed proposals to the following address: Ruth Fletcher, Purchasing Officer City of Carlsbad 1200 Carlsbad Village Drive Carlsbad, CA 92008 8, Technical Proposal 1. General Requirements The purpose of the Technical Proposal is to demonstrate the qualifications, competence and capacity of the firms seeking to undertake an independent aud, of the City in conformity with the requirements of this request for proposals. As such, the substance of proposals will carry more weight than their form or mannc of presentation. The Technical Proposal should demonstrate the qualifications o the firm and of the particular staff to be assigned to this engagement. It should also specify an audit approach that will meet the request for proposals requirements. 18 0 e PROPOSALS ARE NOT TO EXCEED TWENTY-FIVE (25) PAGES The Technical Proposal should address all the points outlined in the request for proposals. Cost information should only be included in the Cost Proposal section. The Proposal should be prepared simply and economically, providing a straight-forward, concise description of the proposer’s capabilities to satisfy the requirements of the request for proposals. While additional data may be presented, the following subjects, items Nos. 2 through 8, must be included. They represent the criteria against which the proposal will be evaluated. The information may be presented in the body of the text or as appendices. 2. Independence The firm should provide an affirmative statement that is independent of the City a defined by generally accepted auditing standards. The firm also should provide an affirmative statement that it is independent of all of the component units of the City as defined by those same standards. The firm should also list and describe the firm’s professional relationships involving the City or any of its component units/agencies, for the past five (5) years, together with a statement explaining why such relationships do not constitute a conflict of interest relative to performing the proposed audit. In addition, the firm shall give the City written notice of any professional relationships entered into during the period of this agreement. 3. License to Practice in State of California. An affirmative statement should be included that the firm and all assigned key professional staff are properly licensed to practice in the State of California, 4. Firm Qualifications and Experience The proposer should state the size of the firm, the size of the firm’s governmenta audit staff, the location of the office from which the work on this engagement is tl be performed and the number and nature of the professional staff to be employe in this engagement. If the proposer is a joint venture or consortium, the qualifications of each firm comprising the joint venture or consortium should be separately identified and th firm that is to serve as the principal auditor should be noted, if applicable. The firm is also required to include a summarization of the results of its most recent external quality control review, with a statement whether that quality contrc review included a review of specific government engagements. 19 > 0 0 The firm shall also provide information on the results of any Federal or State des reviews or field reviews of its audits during the past three (3) years. In addition, the firm shall provide information on the circumstances and status of any disciplinary action taken or pending against the firm during the past three (3) years with State regulatory bodies or professional organizations. 5. Partner, Supervisory and Staff Qualifications and Experience Identify the principal supervisory and management staff, including the specialists who would be assigned to the engagement. Indicate whether each such person is registered or licensed to practice as a certified public accountant in the State of California. Provide information on the government auditing experience of each person, including information on relevant continuing professional education for the past three (3) years and membership in professional organizations relevant to the performance of this audit. Provide as much information as possible regarding the number, qualifications, experience and training, including relevant continuing professional education, of the specific staff to be assigned to this engagement. Indicate how the quality of staff over the term of the agreement will be assured. Engagement partners, managers, other supervisory staff and specialists may be changed if those personnel leave the firm, are promoted or are assigned to another office. These personnel may also be changed for other reasons with the express prior written permission of the City. However, in either case, the City retains the right to approve or reject replacements, engagement partner, manager, and in-charge as well as other supervisors and Consultants and firm specialists mentioned in response to this request for proposal can only be changed with the express prior written permission of the City, which retains the right to approve or reject replacements. Other audit personnel may be changed at the discretion of the proposer providec that replacements have substantially the same or better qualifications or experience. 6. Similar Engagements With Other Government Entities For the firm’s office that will be assigned responsibility for the audit, list the most significant engagements (maximum of 5) performed in the last five years that are similar to the engagement described in this request for proposal. These engagements should be ranked on the basis of total staff hours. Indicate the scope of work, date, engagement partners, total hours, and the name and telephone number of the principal client contact. 20 0 e * 7. Specific Audit Approach The proposal should set forth a summarized work plan, including an explanation of the audit methodology to be followed, to perform the services required in Section II of this request for proposal. Proposers will be required to provide the following information an their audit approach: a. Proposed segmentation of the engagement b. Level of staff and number of hours to be assigned to each proposed segmen of the engagement DOLLARS SHOULD ONLY BE INCLUDED IN THE COST PROPOSAL SECTlOl c. Sample size and the extent to which statistical sampling is to be used in the engagement d. Extent of use of EDP software in the engagement e. Approach to be taken to gain and document an understanding of the City’s internal control structure Approach to be taken in determining laws and regulations that will be subjec‘ to audit test work g. Approach to be taken in drawing audit samples for purposes of tests of compliance f. 8. Identification of Anticipated Potential Audit Problems The proposal should identify and describe any anticipated potential audit problems, the firm’s approach to resolving these problem and any special assistance that will be requested from the City. C. Cost Proposal 1. Total All-Inclusive Maximum Price The dollar cost bid should contain all pricing information relative to performing th. audit engagement as described in this request for proposal. The total all-inclusivt maximum price to be bid is to contain all direct and indirect costs including all out-of-pocket expenses. 21 I J 0 e The total maximum price should be further delineated by components as shown in the following matrix: Fiscal Year* Component 1992-93 1993-94 1994-95 CAFR $ $ $ Public Improvement Corp. Parking Authority Carlsbad Redevelopment Agency Single Audit Encina Financing Joint Powers Authority Gann Limit Verifications Total All-Inclusive Maximum Price $xx $xx $xx Pricing may be stated either as a fixed dollar amount in each of the years or as a fixed dollar amount in the first year with an inflator in the subsequent years. If the proposal includes an inflator, the index to be used must be stated. * The City will not be responsible for expenses incurred in preparing and submittir the proposal. Such costs should not be included in the proposal. 2. Rates for Additional Professional Services Informal advice and consultation not requiring significant research or a formal report shall be included in the Total All-Inclusive Maximum Price. However, if it should become necessary for City to request the auditor to render additional services to either supplement the services requested in this RFP or to perform additional work as a result of the specific recommendations included in any repc issued on this engagement, then such additional work shall be performed only if set forth in an addendum to the contract between City and the firm. Hourly rate! for any such additional work agreed to between City and the firm should be set forth in the cost proposal. 3. Manner of Payment Progress payments will be made on the basis of hours of work completed durins the course of the engagement and out-of-pocket expenses incurred in accordance with the firm’s dollar cost bid proposal. Interim billing shall cover a period of not less than a calendar month. The final ten percent (10%) of the Tot All-inclusive Maximum Price will be paid upon delivery of the firm’s final reports. 22 0 0 e VII. EVALUATION PROCEDURES A. Audit Committee Proposals submitted will be evaluated by a four member Audit Committee, consisting of individuals from the Finance department and the City Manager’s office. B. Review of Proposals The Audit Committee will use a point formula during the review process to score proposals. Each member of the Audit Committee will first score each technical proposal by each of the criteria described in Section VI1 C below. The full Audit the individual scores to arrive at a composite technical score for each firm. At this point, firms with an unacceptably low technical score will be eliminated from further consideration. After the composite technical score for each firm has been established, the cost proposals will be reviewed and additional points will be added to the technical score based on the price bid. The maximum score for price will be assigned to the firm offering the lowest total all-inclusive maximum price. Appropriate fractional scores wi be assigned to other proposers. The City reserves the right to retain all proposals submitted and use any idea in a proposal regardless of whether that proposal is selected. Committee will then convene to review and discuss these evaluations and ta cambin C. Evaluation Criteria Proposals will be evaluated using three sets of criteria. Firms meeting the mandaton criteria will have their proposals evaluated and scored for both technical qualification and price. The following represent the principal selection criteria which will be considered during the evaluation process. 1. Mandatory Elements a. The audit firm is independent and licensed to practice in the State of California. b. The firm has no conflict of interest with regard to any other work performed by the firm for the City. c. The firm adheres to the instructions in this request for proposal on preparing and submitting the proposal d. The firm has a record of quality audit work, 23 r / 0 e 2. Technical Quality: (Maximum Points - 80) a. Expertise and Experience (I) The firm’s past experience and performance on comparable government engagements with an emphasis on local experience. engagement and the quality of the firm’s management support personne to be available for technical consultation. (2) The quality of the firm’s professional personnel to be assigned to the (3) The firm’s past experience auditing housing and aging federal financial assistance programs. (4) The firm’s past experience in meeting GFOA and CSMFO requirements tl receive CAFR award. (5) Experience in providing on-going financial consulting services to municipalities. b. Audit Approach (1) Adequacy of proposed staffing plan for various segments of the engagement (2) Adequacy of sampling techniques (3) Adequacy of analytical procedures 3. Price: (Maximum Points - 20) COST WILL NOT BE THE PRIMARY FACTOR IN THE SELECTION OF AN AUDIT FIRM D. Oral Presentations During the evaluation process, the Audit Committee may, at its discretion, request ai one or all firms to make oral presentations. Such presentations will provide firms with an opportunity to answer any questions the Audit Committee may have or a firm’s proposal. Not all firms may be asked to make such oral presentations. E. Final Selection The Carlsbad City Council will select a firm based upon the recommendation of the Audit Committee. 24 r I 0 W It is anticipated that a firm will be selected by March 12, 1993. Following notification of the firm selected and Council approval, it is expected a contract will be executed between both parties by March 26, 1993. F. Right to Reject Proposals Submission of a proposal indicates acceptance by the firm of the conditions contained in this request for proposal unless clearly and specifically noted in the proposal submitted and confirmed in the contract between the City and the firm selected. The City reserves the right without prejudice to reject any or all proposals. 25 I 0 0 4 APPENDICES A. City of Carlsbad General Purpose Financial Statements B. City of Carlsbad Schedule of Federal Financial Assistance C. 1991 Management Letter D. Gann Limit Verification Procedures E. Organizational Charts F. Example Contract r I APPEN 0 w Peat Ma rw ic k Certified Public Accountants 750 B Street San Diego. CA 92101 Independe nt Auditors' Reuor t The Honorable Members of City Council City of Carlsbad, California: We have audited the general purpose financial statements of the Cit Carlsbad, California, as of and for the year ended June 30, 1992, as list the accompanying table of contents. These general purpose fina statements are the responsibility of the City's management. responsibility is to express an opinion on these general purpose fina statements based on our audit. We conducted our audit in accordance with generally accepted aud standards. Those standards require that we plan and perform the aud: obtain reasonable assurance about whether the general purpose fina statements are free of material misstatement. An audit includes examinin a test basis, evidence supporting the amounts and disclosures in the ge purpose financial statements. An audit also includes assessing the accou principles used and significant estimates made by management, as we: evaluating the overall financial statement presentation. We believe tha audit provides a reasonable basis for our opinion. In our opinion, the general purpose financial statements referred to present fairly, in all material respects, the financial position of the of Carlsbad, California, as of June 30, 1992, and the results of operations and the cash flows of its proprietary funds for the year then in conformity with generally accepted accounting principles. Our audit wag made for the purpose of forming an opinion on the ge purpose financial statements taken as a whole. The combining, indil fund, and individual account group financial statements and schedules 3 in the accompanying table of contents are presented for purposes of addit analysis and are not a required part of the general purpose fin2 statements of the City of Carlsbad, California. Such information has subjected to the auditing procedures applied in the audit of the gf purpose financial statements and, in our opinion, is fairly stated i material respects in relation to the general purpose financial statc taken as a whole. Kt& @Qt&&&b& October 9, 1992 Member F .rn 01 27 Klvnveld Peal Marwck Goerdeler w w F CITY OF CARLSBAD Combined Balance Sheet All Fund Types and Account Groups June 30, 1992 2 Special Debt Capi Assets and Other Debits Notes General Revenue Service Projq Cash and investments 4 $ 10,350,930 6,471,040 4,862,787 39,33' Deferred compensation Rece ivab le s : - - - investments 8 Loans - 164,488 - Taxes 1,024,177 17,846 3 25 1 Accounts, net 66,140 67,377 - Due from other funds 13 627,912 - - Due from other governments - 17,143 - Inventory 33,358 - - Prepaid expenditures 43,500 165,881 - 2 Accrued interest 418,495 90,808 86,415 50 35 funds 12 10,340,785 - - 2,49 Advances to other Restricted assets: Cash and Accrued interest - - - - - - investments 4 Property, plant and Amount available in Amount to be - - - equipment 9 net 5 debt service funds - - - provided for retirement of term debt general long- - - - Total assets and other debits $ 22.905. 297 5.99 4.583 4.949.527 42.7 See accompanying notes to combined f inancia1 statements. 28 m w e Proprietary Fiduciary Fund Types Fund TVD~ Accoun t Groups Tot: Internal General Long- (Memorz Enter Dr i s e Service Aaencv Fixed Assets Term Debt m 31,947,353 8,833,881 14,114,913 - - 115,911 - - 4,712,077 - - 4,71; - 161 - - - 1,05: 2,239,462 6,446 - - - 2,40t 591,844 145,208 50,653 - - 1,89( - 80; - 371 - - - - - 12,83: - - 551 - - 20! - - - - - - 174,781 - - - - - - - 443,511 81,631 - - - - 6,584,168 - - - - 6,58 1 96,891,191 2,641,150 - 63,036,204 - 162,56 - - - - 4,904,027 4,90 13,072 - - - - - - - - 25.641.595 25.64 138.885.384 11.708.3 16 18.877,643 63.036. 204 30.545 622 340 63 29 (Con w w CITY OF CARLSBAD Combined Balance Sheet, Continued All Fund Types and Account Groups June 30, 1992 Governme ntal Fund TvDes Special Debt Capit, Service Proiec Accounts payable $ 958,557 80,156 2,000 265, Liabilities Notes General Revenue 5, Accrued wages payable 1,804,655 54,603 - Accrued interest payable 78,334 - - Due to other funds 13 - 283,143 - 344! Due to other governments - 33,898 - Estimated claims payable - - - Assessments payable - - - Current portion of Deposits payable - Advances from other funds 12 - - - 12,833, - - - long-term debt 11 - - 46 9 Deferred compensation Current 1 iab i 1 it ies - - - payable 8 payable from restricted assets - accrued interest payable - - - Deferred revenue 3,254,678 - 43,500 160 Special assessment debt - - - Bonds payable 11 with governmental commitment 11 capital leases 9,11 - - - participation 11 agreement 11 - - - Obligations under Certificates of Installment purchase - - - - - - Total liabilities $ 6.096. 224 451.806 45.500 14.07: See accompanying notes to combined financial statements. 30 w v Proprietary Fiduciary Fund Types Fund Type ACCCW t Groups To ta Enter Dr i s e Service Agencv Fixed Assets Term Debt onlv Internal General Long- (Memora - 2 , 341 915,280 111,376 8 , 660 - - - 2,195 284 , 605 46,477 - - - 221 142 , 734 - - - - 802 174,781 - - - - - - - 12,833 - - 1,731,492 - - 1,765 - - 2 , 188 - 2 , 188,889 - - - 4,527,533 - - 4,527 - - 685 685,000 - - 238 , 944 - 7,897,881 - - 8,606 - - 4,712,077 - - 4,712 - - 351 2,070,778 - - - - 5,52! - - - - 12,960,000 12,96( 351,855 - - - - - - 8,465,000 8,461 - - - - 1,030,622 1,03( 11,022,770 - - - 8,090,000 19,ll' 12.68' 12.689.800 - - - - 28.576.547 2.346.742 18.877.6 43 - 30.545.622 101.01' 31 (Cont 0 e CITY OF CARLSBAD Combined Balance Sheet, Continued All Fund Types and Account Groups June 30, 1992 Governmental Fund Types Special Debt Capit; Service Projeq Notea General Revenue Total liabilities, brought forward $ 6.096. 224 451.80Q 45.50Q 14,079. Fund Equity and Other Credits Investment in general Contributed capital 15 Fund balance : fixed assets - - - - - - Reserved 14 7,995,039 2,459,327 4,904,027 4,487 Un res e rved 14 8,814,034 4,083,456 - 24,161 Res e rved 14 Unr e s e rved 14 Retained earnings: - - - - - - Total fund equity and other credits 16.809 .O 73 6.542.783 4.904.027 28.649 Total liabilities, fund equity and other credits $ 22.905, 297 6.99 4.58% 4.949.527 42.728 See accompanying notes to combined financial statements. 32 1 1 0 0 Proprietary Fiduciary Fund TvDes Fund Tvpe Accoun t Groups Tota Internal Genera 1 Long- (Memora EnterDrise Service Agencv Fixed Assets Term Debt onlv 28.576.547 2.346.742 18.877.6 43 - 30.545.622 101.019 63,036 75 , 48 7 , 426 5,5 71,402 - - - 81,058 - - - - - 19,845 - - - - - 37,055 - - 3 , 35r 31,467,026 3 790.1 72, - - - 35.257 - - - 63,036,204 - 3,354,383 - - 110.308.835 9.36 1.574 - 63.036. 204 - 239.611 138.885.38 2 11.708.3 16 18,877.6 43 63,036.204 30.545.622 340,63( 33 J 0 0 CITY OF CARLSBAD Combined Statement of Revenues, Expenditures and Changes in Fund Balance - All Governmental Fund Types For the year ended June 30, 1992 Gene Taxes $ 26,424 j Revenues : Licenses and permits 1,729, Intergovernmental State subventions 2,489< Charges for services 4,562, Fines and forfeits 312 Interest income 2,152 Interdepartmental services 1,916 Contributions from property owners Miscellaneous 338 To tal revenues 39,925 Expenditures: Current: General government 5,069 Community development 7,323 Public works Welfare Culture and recreation 6,960 Maintenance and utilities 4,228 Public safety 15,647 Capital outlay Debt service : Principal retirement Interest and fiscal charges Total expenditures 39.22: Excess (deficiency) of revenues over expenditures 69’ Operating transfers in 5,39 Operating transfers out (53 Total other financing sources (uses) 4,85 Other financing sources (uses): Excess (deficiency) of revenues and other financing sources over expenditures and other financing uses 5,55 12,zo Fund balarice at beginning of year, as adjusted (note 21) Residual equity transfers out (96 Residual equity transfers in Fund balance at end of year See accompanying notes to combined financial statements. 34 $ 16.80 W 0 To tal Special Debt Capital (Memo rar Revenue Service Projects OnlV: 317,673 2,116 , 142 3 , 228 , 324 32,086, - - - 1,729, 4 , 176 , 247 - 1 , 910 , 891 6,087 , - - - 2,489, 1,616,812 - 1 , 579 , 724 7,759, - - - 312, 340 , 838 345 , 040 1 , 988 , 147 4,826 , 1,916, - - 446,813 446 91 6.570.930 2.461.182 9.483.163 58,440, - - - 119.360 - 329.264 786.1 440 , 115 - 815,177 6,324, - - - 15,647, - - - 7,323, 1 , 257,859 - - 1,257, 2,287,271 - - 2,287, 340,271 - - 7,301, - - - 4,228, - - 5,639,898 5,639, - 1,175,000 - 1,175, - 2.799.795 - 2.799. 4.325.516 3.97 4.795 6.455.075 23AzLL 2.245.414 (1 .513.613) 3.028.088 4.455. 560 1,714,117 6 , 160 , 374 13 , 269 , - (1.227.947) (11.506.524) ( 13.269 ,, 560 486.170 (5.3 46.15Q) - 2 , 245 , 974 (1,027,443) (2,318,062) 4,455, 932 839,850 172,858 1,022, 9.542.782 4.904.O27 28.649.145 2IMQL 4,297 , 761 5,094,417 31,640,578 53,238, (1.884) (2.797) (846.229 ) 11.811, 35 I > 0 CITY OF CARLSBAD Combined Statement of Revenues , Expenditures and Changes in Fund Balance - Budget and Actual (Budgetary Basis) All Governmental Fund Types For the year ended June 30, 1992 General Fund Actual on Varianc Budge tar y Favorab Budaet Basis (Unf avora Taxes $ 29,505,000 26,424,175 (3,080,8: Licenses and permits 2,185,000 1,729,058 (455 , 9 Intergovernmental - - - Revenues : State subventions 2,830,000 2,489,454 (340,5 Charges for services 4,475,000 4,562,688 87,6 Fines and forfeits 550 , 000 312,984 (237,O In teres t income 2,000,000 2,152,267 152,2 Interdepartmental services 2,038,000 1,916,323 (121,6 Miscellaneous 250 .OOQ 338. 212 88.2 Total revenues 43.833.000 39 925 . 161 (3.907.8 Expenditures: Current: General government 7,722,061 5,242,016 2,480,O Public safety 16,592,947 15,679,674 913 , 2 Community development 8,957,296 7,775,736 1,181,5 Welfare Culture and recreation 7,515,414 7,002,720 512,t Maintenance and utilities 5,409,250 5,057,399 351,1 - - - Public works - - - Debt service : Principal retirement - - - Interest and fiscal charges - - - Total expenditures 46.196.968 40.757.5 45 Ei&E!d Excess (deficiency) of revenues over expenditures (2.363.968 1 (832.384) 1.531.1 Other financing sources (uses): Operating transfers in 5,394,102 5,394,102 - Operating transfers out (5 34.682) (534.682) - sources (uses) 4,859. 4 20 4.859. 42Q - Total other financing Excess (deficiency ) of revenues and other financing sources over expenditures and other financing uses 2,495,452 4,027,036 1,531, Fund balance at beginning of year, as adjusted (note 21) 12,205,755 12,205,755 Residual equity transfers in - 9 , 243 9! Residual equity transfers out - (960.773) (960, Fund balance at end of year $ 14.701.207 15.281.261 580. See accompanying notes to combined financial statements. 36 1 0 0 ,’ Spec ial Revenue Funds Debt Service Funds Actual on Variance Actual on Varianc Budgetary Favorable Budgetary Favorab (Unf avora Budaet Bas is (Unfavorable 1 Budaet Bas is 360,000 317,673 (42,327) 1,469,510 1,302,947 (166,56 - - - - - - 2,722,849 4,176,247 1,453,398 - - - - - - - - - - - - 1,795,200 1,616,812 (178 , 388 ) - - - - - - 122,200 337,771 215,571 241 , 300 148,884 (92,41 76.56 - 2 119.360 42.798 - - - - - - - - 5.076.811 6.567.863 1.491.052 1.710,810 1,451,831 (258,97 598,622 504,569 94,053 - - - 2,010,247 1,279,428 730,819 - - - 2,468,304 2,287 , 943 180,361 - - - - - - - - - - - - - - - - - - 674,902 490,837 184,065 - - - - - - - 420,000 420,000 - - - - - - 1.368. 712 1.367.965 71 5.75 2.075 4.562.777 1.189.298 1.788.7 12 1.787.965 71 (675.264) 2.005.086 2,680.350 (77.90 2) (336.134) (258.2: 560 560 - 1,125 , 238 1,125 , 238 - - - - 1.155.038 1.155.038 - - 560560 - (29.800 1 (29.80Q 1 (674,704) 2,005,646 2 , 680 , 350 (107 , 702) (365 , 934) (258 $2 4,247,328 4,247,328 - 1,285,938 1,285,938 - - (1.884) (1.884) - (2.797) (2.7 3.572.624 6.252.022 2.679.398 1.178.236 1.757.057 578.E - 932 932 - 839 , 850 839 ,e 37 (Cont < I e 0 CITY OF CARLSBAD Combined Statement of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual (Budgetary Basis) All Governmental Fund Types, Continued For the year ended June 30, 1992 Total (Memorandum On lg 1 Actual on Varianc Budgetary Favorab Basis (Unfavora Licenses and permits 2,185,000 1,729,058 (455,91 Intergovernmental 2,722,849 4,176,247 19453 , 3 State subventions 2,830,000 2,489,454 (340,s Charges for services 6 , 270 , 200 6,179,500 (90,7 Fines and forfeits 550,000 312,984 (237,O Interest income 2,363,500 2,638,922 275,4 Interdepartmental services 2,038,000 1,916,323 (121,6 Miscellaneous 326.562 457.57 2 131,c Total revenues 50.620.621 47.944.855 (2,675.7 Budnet Revenues : Taxes $ 31,334,510 28,044,795 (3,289,7 Expenditures: Current: General government 8,320,683 5,746,585 2,574 ,C Public safety 16,592,947 15,679,674 913, Z Community development 8,957,296 7,775,736 1,181,: Pub 1 i c wo r ks 2,010,247 1,279,428 730, E Welfare 2,468,304 2,287,943 180 , Culture and recreation 8,190,316 7,493,557 696, Maintenance and utilities 5,409,250 5,057,399 351 ,I Debt service: Principal retirement 420,000 420,000 - Total expenditures 53.737.755 47.108- 28 7 6.629. over expenditures (3.117.134) 836.568 3.953. Interest and fiscal charges 1.368.7 12 1.367.965 Excess (deficiency) of revenues Other financing sources (uses): Operating transfers in 6,519,900 6,519,900 - Operating transfers out (1.689.720) (1.689.7 20) 4 Total other financing sources (uses 1 4.830, 18Q 4.830. 180 Excess (deficiency) of revenues and other financing sources over expenditures and other financing uses 1,713,046 5,666,748 3,953 Fund balance at beginning of year, Residual equity transfers in - 850,025 850 Residual equity transfers out - (965.454) -as. as adjusted (note 21) 17,739,021 17,739,021 Fund balance at end of year $ 19,452.067 23.290.340 3.838 See accompanying notes to combined financial statements. 38