f\~.O\) .{l\ :.t~ 1''1~ \'''\1-Q,% AUDIT REPORT DOUGLAS COUNTY BOARD OF EDUCATION DOUGLASVILLE, GEORGIA YEAR ENDED JUNE 30, 1998 '''-------------------- STATE OF GEORGIA DEPARTMENT OF AUDITS AND ACCOUNTS 254 WASH I NGTON STREET ATLANTA, GEORGIA 30334-8400 DOUGLAS COUNTY BOARD OF EDUCATION - TABLE OF CONTENTS - SECTION I ~ FINANCIAL INDEPENDENT AUDITOR'S COMBINED REPORT ON GENERAL PURPOSE FINANCIAL STATEMENTS AND SUPPLEMENTARY INFORMATION SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS EXlllBITS GENERAL PURPOSE FINANCIAL STATEMENTS COMBINED STATEMENTS - OVERVIEW A COMBINED BALANCE SHEET ALL FUND TYPES AND ACCOUNT GROUP 2 B COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES ALL GOVERNMENTAL FUND TYPES 4 C COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL (NON-GAAP BASIS) GENERAL AND SPECIAL REVENUE FUNDS 7 D STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND BALANCES FIDUCIARY FUND TYPE - NONEXPENDABLE TRUST FUND 8 E STATEMENT OF CASH FLOWS FIDUCIARY FUND TYPE - NONEXPENDABLE TRUST FUND 9 F NOTES TO THE GENERAL PURPOSE FINANCIAL STATEMENTS 10 ADDmONAL FINANCIAL INFORMATION COMBINING STATEMENTS SPECIAL REVENUE FUND G COMBINING BALANCE SHEET 24 H COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES 25 CAPITAL PROJECTS FUND I COMBINING BALANCE SHEET 26 J COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES 28 DEBT SERVICE FUND K COMBINING BALANCE SHEET 30 L COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES 31 DOUGLAS COUNTY BOARD OF EDUCATION - TABLE OF CONTENTS - SECTION I FINANCIAL ADDmONAL FINANCIAL INFORMATION SCHEDULES 1 SCHEDULE OF REQUIRED SUPPLEMENTARY INFORMATION 33 2 SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS 34 3 SCHEDULE OF STATE REVENUE 36 4 SCHEDULE OF APPROVED LOCAL OPTION SALES TAX PROJECTS 38 5 SCHEDULE OF EXPENDITURES LOTTERY PROGRAMS 39 ANALYSIS OF MINIMUM EXPENDITURE REQUIREMENTS GENERAL FUND - QUALITY BASIC EDUCATION PROGRAMS 6 OVERALL 41 7 BY PROGRAM 42 SECTION II COMPLIANCE AND INTERNAL CONTROL REPORTS REPORT ON COMPLIANCE AND ON INTERNAL CONTROL OVER FINANCIAL REPORTING BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS REPORT ON COMPLIANCE WITH REQUIREMENTS APPLICABLE TO EACH MAJOR PROGRAM AND INTERNAL CONTROL OVER COMPLIANCE IN AC;CORDANCE WITH OMB CIRCULAR A-133 SECTIONID AUDITEE'S RESPONSE TO PRIOR YEAR FINDINGS AND QUESTIONED COSTS SUMMARY SCHEDULE OF PRIOR YEAR FINDINGS AND QUESTIONED COSTS DOUGLAS COUNTY BOARD OF EDUCATION - TABLE OF CONTENTS - SECTION IV FINDINGS AND QUESTIONED COSTS SCHEDULE OF FINDINGS AND QUESTIONED COSTS SECTION I FINANCIAL RUSSELL W. HINTON STATE AUDITOR (404) 656-2174 DEPARTMENT OF AUDITS AND ACCOUNTS 254 Washington Street, S.w., Suite 214 Atlanta, Georgia 30334-8400 April 2, 1999 Honorable Roy E. Barnes, Governor Members of the General Assembly Members of the State Board ofEducation and Superintendent and Members of the Douglas County Board of Education INDEPENDENT AUDITOR'S COMBINED REPORT ON GENERAL PURPOSE FINANCIAL STATEMENTS AND SUPPLEMENTARY INFORMATION SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Ladies and Gentlemen: We have audited the accompanying general purpose financial statements of the Douglas County Board of Education, as of and for the year ended June 30, 1998, as listed in the table of contents. These general purpose financial statements are the responsibility ofthe Douglas County Board ofEducation's management. Our responsibility is to express an opinion on these general purpose financial statements based on our audit. We conducted our audit in accordance with generally accepted auditing standards and the standards applicable to fInancial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the fInancial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements. An audit also ~cludes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall financial statement presentation. We believe that our audit provides a reasonable basis for our opinion. As described in the notes to the general purpose fInancial statements, the Board's fmancial statements have been prepared using certain accounting practices and policies which, in our opinion, vary in some respects from generally accepted accounting principles. These variances are described as follows: * The general purpose financial statements of the Board did not contain a General Fixed Assets Account Group to account for property and equipment owned by the Board which should be included to conform to generally accepted accounting principles. 98ARL-13B * School activity accounts maintained at the individual schools are not included in the general purpose financial statements. To conform to generally accepted accounting principles, these accounts should be included in the general purpose financial statements. * The Board did not recognize as expenditures, in the year ended June 30, 1998, a portion of salaries and the corresponding employer's cost ofrelated benefits earned for contractual services completed prior to June 30, 1998. Also funds received, subsequent to June 30, 1998, from the Georgia Department ofEducation for the State's share ofthese unrecorded salaries and related benefits were not recorded as revenue in the year under review. Conversely, the similar expenditures and related revenues for contractual services completed prior to June 30, 1997, were improperly recorded in the year ended June 30, 1998. To conform to generally accepted accounting principles, revenues should be recorded when available and measurable and expenditures should be recorded when incurred, rather than when funds are received or disbursed. The aggregate effects on the general purpose financial statements ofthese variances or omissions have not been determined, but are believed to be material. In our opinion, except for the effects on the general purpose financial statements of the matters referred to in the preceding paragraph, the general purpose financial statements referred to above present fairly, in all material respects, the financial position ofthe Douglas County Board of Education as of June 30, 1998, and the results of its operations and the cash flows of its nonexpendable trust fund for the year then ended, in conformity with generally accepted accounting principles. In accordance with Government Auditing Standards, we have also issued our report dated April 2, 1999, on our consideration ofthe Douglas County Board of Education's internal control over financial reporting and our tests of its compliance with certain provisions of laws, regulations, contracts and grants. The year 2000 supplementary information on Schedule "1" is not a. required part of the basic financial statements but is supplementary information required by the Governmental Accounting Standards Board. We have applied certain limited procedures, which consisted principally of inquiries of management regarding the methods of measurement and presentation ofthe supplementary information. However we did not audit the information and do not express an opinion on it. In addition, we do not provide assurance that Douglas County Board of Education is or will become year 2000 compliant, that the Board's year 2000 remediation efforts will be successful in whole or in part, or that parties with which Douglas County Board of Education does business are or will become year 2000 compliant. Our audit was performed for the purpose of forming an opinion on the general purpose financial statements of the Douglas County Board of Education taken as a whole. The accompanying combining statements (Exhibits G through L) and the financial schedules (Schedules 2 through 7), which includes the Schedule of Expenditures of Federal Awards as required by U. S. Office of Management and Budget Circular A-133, Audits ofStates, Local Governments, and Non-Profit Organizations, are presented for purposes of additional analysis and are not a required part of the general purpose financial statements. Such information has been subjected to the auditing procedures applied in the audit of the general purpose financial statements and in our opinion, except for the effects ofthe matters referred to in the third paragraph, such information is fairly presented in all material respects in relation to the general purpose financial statements taken as a whole. 98ARL-13B A copy of this report has been filed as a permanent record in the office of the State Auditor and made available to the press ofthe State, as provided for by Official Code of Georgia Annotated Section 50-6-24. Respectfully submitted, ~w: Sub-Total - K-3 Grades 4 - 5 r> Grades 6 - 8 (*) Grades 9 -12 (*). High SChool Laboratories (*) Vocational Education Laboratories (*) Total General and Career Education Programs SPECIAL EDUCATION PROGRAMS Regular Programs Category I (*) Category II (*) Category III (*) Category IV (*) Sub-Total - Regular Category VI (Gifted) (*) Total Special Education Programs REMEDIAL EDUCATION PROGRAM M Total Fourteen Weighted Programs MEDIA CENTER PROGRAMS Salaries Operations Total Media center Programs Total Fourteen Weighted and Media Center Programs ALLOTMENTS FROM DEPARTMENT OF EDUCATION REQUIRED ORIGINAL ~ ORIGINAL MID-TERM $ 3,432,207.00 $ 3,088,986.30 $ 9,062,102.00 8,155,891.80 $ 12,494,309.00 90 $ 11,244,878.10 $ 3,814,237.00 90 3,432,813.30 6,658,204.00 90 5,992,383.60 3,803,242.00 90 3,422,917.80 2,328,206.00 90 2,095,385.40 2,423,679,00 90 2,181,311,10 $ 31 ,521 ,8n.00 $ 28,369,689.30 $ 0.00 0.00 1,535,830.00 1,535,830.00 $ 5,615,799.00 $ 5,054,219.10 $ 0.00 $ 5,615,799.00 1,563,831.00 $ 7,179,630.00 $ 1,146,644.00 $ 39,848,151,00 90 '$ 5,054,219.10 $ 90 1,407,447.90 $ 6,461,667.00 $ 90 $ 1,031,979.60 $ $ 35,863,335,90 $ 0.00 0,00 0,00 1,535,830.00 $ 1,090,374.00 90 $ 981,336,60 $ 0.00 253,903.00 90 228,512.70 0.00 $ 1,344,2n.00 $ 1,209,849.30 $ 0.00 $ 41,192,428.00 $ 37,073,185.20 $ 1,535,830.00 STAFF DEVELOPMENT PROGRAMS Cost of Instruction Professional Development Total Staff Development Programs (*) Identifies Fourteen Weighted Programs. See notes to the general purpose financial statements. $ 124,6n.00 305.301.00 $ 124,6n.00 $ 305.301.00 $ 429,978,00 100 $ 429,978.00 $ 0.00 0.00 . . .00.0., - 42 - SCHEDULE...,. TOTAL REQUIRED ACTUAL EXPENDITURES SALARIES OPERATIONS TOTAL AMOUNT OF UNDEREXPENDITURE FOR REQUIRED ALLOTMENT $ 3,088,986.30 $ 3,936,816.99 $ 126,084.21 $ 4,062,901.20 8,155,891.80 9,419,756.23 334,521.81 9,754,278.04 $ 11,244,878.10 $ 13,356,573.22 $ 460,606.02 $ 13,817,179.24 $ 0.00 3,432,813.30 5,159,552.02 180,553.70 5,340,105.72 0.00 5,992,383.60 8,202,728.93 211,203.22 8,413,932.15 0.00 4,958,747.80 6,188,865.31 153,680.81 6,342,546.12 0.00 2,095,385.40 2,116,657.11 99,181.24 2,215,838.35 0.00 2,181,311.10 2,634,265.95 314,898.88 2,949,164.83 0.00 $ 29,905,519.30 $ 37,658,642.54 $ 1,420,123.87 $ 39,078,766.41 $ 5,054,219.10 $ 300,866.25 $ 1,116,346.73 5,261,860.13 397,278.06 9,541.94 $ 10,522.46 146,214.55 7,895.18 310,408.19 1,126,869.19 5,408,074.68 405,173.24 $ 5,054,219.10 $ 7,076,351.17 $ 174,174.13 $ 7,250,525.30 0.00 1,407,447.90 1,626,595.98 58,330.39 1,684,926.37 0.00 $ 6,461,667.00 $ 8,702,947.15 $ 232,504.52 $ 8,935,451.67 $ 1,031,979.60 $ 1,122,066.08 $ 29,156.38 $ 1,151,222.46 0.00 $ 37,399,165.90 $ 47,483,655.77 $ 1,681,764.77 $ 49,165,440.54 $ 981,336.60 $ 1,861,284.33 S 1,861,284.33 0.00 228,512.70 $ 356,869.03 356,869.03 0.00 $ 1,209,849.30 $ 1,861,284.33 $ 356,869.03 $ 2,218,153.36 $ 38,609,015.20 $ 49,344,940.10 $ 2,038,653.80 $ 51,383,593.90 $ 0.00 $ 124,677.00 305,301.00 $ ......==4_29~,9==7:;;;8=.0=0 $ 299,871.65 $ 299,871.65 141,426.92 141,426.92 $ 441,298.57 $ 441,298.57 $ ..0.0...,0 - 43 - SECTION II COMPLIANCE AND INTERNAL CONTROL REPORTS RUSSELL W. HINTON STATE AUDITOR (404) 656-2174 DEPARTMENT OF AUDITS AND ACCOUNTS 254 Washington Street, S.W., Suite 214 Atlanta, Georgia 30334-8400 April 2, 1999 Honorable RoyE. Barnes, Governor Members ofthe General Assembly Members ofthe State Board ofEducation and Superintendent and Members ofthe Douglas County Board of Education REPORT ON COMPLIANCE AND ON INTERNAL CONTROL OVER FINANCIAL REPORTING BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS Ladies and Gentlemen: We have audited the financial statements ofDouglas County Board ofEducation as of and for the year ended June 30, 1998, and have issued our report thereon dated April 2, 1999. This report was qualified for various departures from generally accepted accounting principles, as identified in the auditor's report on the general purpose financial statements. We conducted our audit in accordance with generally accepted auditing standards and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General ofthe United States. Compliance As part of obtaining reasonable assurance about whether Douglas County Board of Education's financial statements are free ofmaterial misstatement, we performed tests ofits compliance with certain provisions of laws, regulations, contracts and grants, noncompliance with which could have a direct and material effect on the determination of financial statement amounts. However, providing an opinion on compliance with those provisions was not an objective of our audit and accordingly, we do not express such an opinion. The results of our tests disclosed no instances of noncompliance that are required to be reported under Government Auditing Standards. Internal Control Over Financial Reporting In planning and performing our audit, we considered Douglas County Board of Education's internal control over financial reporting in order to determine our auditing procedures for the purpose of expressing our opinion on the financial statements and not to provide assurance on the internal control over financial reporting. However, we noted a certain matter involving the internal control over financial reporting and its 98YB-40 operation that we consider to be a reportable condition. Reportable conditions involve matters coming to our attention relating to significant deficiencies in the design or operation ofthe internal control over financial reporting that, in our judgement, could adversely affect Douglas County Board of Education's ability to record, process, summarize and report financial data consistent with assertions ofmanagement in the financial statements. The reportable condition is described in the accompanying Schedule ofFindings and Questioned Costs as item FS-6481-98-01. A material weakness is a condition in which the design or operation of one or more of the internal control components does not reduce to a relatively low level the risk that misstatements in amounts that would be material in relation to the financial statements being audited may occur and not be detected within a timely period by employees in the normal course ofperforming their assigned functions. Our consideration ofthe internal control over financial reporting would not necessarily disclose all matters in the internal control that might be reportable conditions and accordingly, would not necessarily disclose all reportable conditions that are also considered to be material weaknesses. However, the reportable condition described above is considered to be a material weakness. This report is intended for the information of management, the Federal cognizant agency, Federal awarding agencies and pass through entities. This restriction is not intended to limit the distribution ofthis report which is a matter of public record. Respectfully submitted, ~tA.~ Russell W. Hinton State Auditor RWH:gp 98YB-40 RUSSELL W. HINTON STATE AUDITOR (404) 656-2174 DEPARTMENT OF AUDITS AND ACCOUNTS 254 Washington Street, S.w., Suite 214 Atlanta, Georgia 30334-8400 April 2, 1999 Honorable RoyE. Barnes, Governor Members ofthe General Assembly Members ofthe State Board of Education and Superintendent and Members ofthe Douglas County Board ofEducation REPORT ON COMPLIANCE WITH REQUIREMENTS APPLICABLE TO EACH MAJOR PROGRAM AND INTERNAL CONTROL OVER COMPLIANCE IN ACCORDANCE WITH OMB CIRCULARA-133 Ladies and Gentlemen: Compliance We have audited the compliance of Douglas County Board of Education with the types of compliance requirements described in the U.S. Office ofManagement and Budget (OME) Circular A-133 Compliance Supplement that are applicable to each of its major Federal programs for the year ended June 30, 1998. Douglas County Board of Education's major Federal programs are identified in the accompanying Schedule of Findings and Questioned Costs. Compliance with the requirements of laws, regulations, contracts and grants applicable to each of its major Federal programs is the responsibility of Douglas County Board of Education's management. Our responsibility is to express an opinion on Douglas. County Board of Education's compliance based on our audit. We conducted our audit of compliance in accordance with generally accepted auditing standards; the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States; and OMB Circular A-133,Audits ofStates, Local Governments, and Non-Profit Organizations. Those standards and OMB Circular A-133 require that we plan and perform the audit to obtain reasonable assurance about whether noncompliance with the types of compliance requirements referred to above that could have a direct and material effect on a major Federal program occurred. An audit includes examining, on a test basis, evidence about the Douglas County Board of Education's compliance with those requirements and performing such other procedures as we considered necessary in the circumstances. We believe that our audit provides a reasonable basis for our opinion. Our audit does not provide a legal determination on Douglas County Board of Education's compliance with those requirements. 98SA-1O In our opinion, the Douglas County Board of Education complied, in all material respects, with the requirements referred to above that are applicable to each of its major Federal programs for the year ended June 30, 1998. Internal Control Over Compliance The management of Douglas County Board of Education is responsible for establishing and maintaining effective internal control over compliance with requirements of laws, regulations, contracts and grants applicable to Federal programs. In planning and performing our audit, we considered Douglas County Board ofEducation'sinterna1 control over compliance with requirements that could have a direct and material effect on a major Federal program in order to determine our auditing procedures for the purpose of expressing our opinion on compliance and to test and report on internal control over compliance in accordance with OMB Circular A-133. Our consideration ofthe internal control over compliance would not necessarily disclose all matters in the internal control that might be material weaknesses. A material weakness is a condition in which the design or operation ofone or more ofthe internal control components does not reduce to a relatively low level ofrisk that noncompliance with applicable requirements of laws, regulations, contracts and grants that would be material in relation to a major Federal program being audited may occur and not be detected within a timely period by employees in the normal course of performing their assigned functions. We noted no matters involving the internal control over compliance and its operation that we consider to be material weaknesses. This report is intended for the information of management, the Federal cognizant agency, Federal awarding agencies and pass through entities. This restriction is not intended to limit the distribution ofthis report which is a matter of public record. Respectfully submitted, ,?;..cr tiJ.~ Russell W. Hinton State Auditor RWH:gp 98SA-IO SECTION ill AUDITEE'S RESPONSE TO PRIOR YEAR FINDINGS AND QUESTIONED COSTS DOUGLAS COUNTY BOARD OF EDUCATION AUDITEE'SRESPONSE SUMMARY SCHEDULE OF PRIOR YEAR FINDINGS AND OUESTIONED COSTS YEAR ENDED JUNE 30. 1998 PRIOR YEAR FINANCIAL STATEMENT FINDINGS AND OUESTIONED COSTS FINDING CONTROL NUMBER AND STATUS 6481-93-07 6481-96-01 FS-6481-97-01 FS-6481-97-02 Further Action Not Warranted Further Action Not Warranted Previously Reported Corrective Action Implemented Unresolved - See Corrective Action/Responses CORRECTIVE ACTIONIRESPONSES GENERAL FIXED ASSETS Failure to Maintain General Fixed Assets Account Group Finding Control Number FS-6481-97-02 We concur with this finding. Due to current staffing limitations and budgetary considerations prohibiting the hiring of additional staff, the Board has decided not to pursue the recording of general fixed assets on the financial statements. The general purpose financial statements will be incomplete and not in accordance with generally accepted accounting principles. SECTION IV FINDINGS AND QUESTIONED COSTS DOUGLAS COUNTY BOARD OF EDUCATION SCHEDULE OF FINDINGS AND OUESTIONED COSTS YEAR ENDED JUNE 30, 1998 I SUMMARY OF AUDITOR'S RESULTS 1. Type of Report Issued on the Financial Statements The auditor's opinion on the Douglas County Board ofEducation's financial statements was qualified for various departures from generally accepted accounting principles. 2. Reportable Conditions in Internal Control DisClosed by the Audit ofthe Financial Statements The audit report for the Douglas County Board ofEducation disclosed a financial statement reportable condition related to the following control category. General Fixed Assets The reportable condition described above is considered to be a material weakness. 3. Noncompliance Material to the Financial Statements The audit ofthe Douglas County Board ofEducation disclosed no instances ofnoncompliance that were deemed to be material to the financial statements. 4. Reportable Conditions in Internal Control Over Major Programs The audit report for the Douglas County Board of Education did not disclose any reportable conditions in internal control over major programs. 5. Type of Report Issued on Compliance for Major Programs The auditor's opinion on the Douglas County Board of Education's report on compliance with requirements applicable to major programs was unqualified. 6. Audit Findings Required to be Reported by Section .5lOCa) ofOMB Circular A-133 The Douglas County Board ofEducation's audit did not disclose audit findings required to be reported by section .51O(a) ofOMB Circular A-133. 7. Major Programs Federal awards audited as major programs are as follows: 10.550 Food and Nutrition Program - Food Distribution Program 10.553 Food and Nutrition Program - Food Services - School Breakfast Program 10.555 Food and Nutrition Program - Food Services - National School Lunch Program 8. Type "A" Program Dollar Threshold The dollar threshold for type "A" programs was $300,000.00. 9. Low Risk Auditee The Douglas County Board ofEducation was audited as a low risk auditee based on a waiver granted by the U. S. Department of Education. - 1- DOUGLAS COUNTY BOARD OF EDUCATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 1998 IT FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS GENERAL FIXED ASSETS Failure to Maintain General Fixed Assets Account Group Reportable Condition - Material Weakness Repeated From Prior Year Finding Control Number: FS-6481-98-01 The Douglas County Board of Education did not maintain a system-wide General Fixed Assets Account Group within the formal accounting records as required by generally accepted accounting principles. This condition results in the general purpose financial statements of the Board being incomplete and not in accordance with generally accepted accounting principles. Appropriate action should be taken by the Board to establish accounting controls and procedures to provide for maintenance ofa General Fixed Assets Account Group. These subsidiary records should include an inventory ofland, buildings and equipment owned by the Board and should include, but may not be limited to, date acquired, acquisition cost, estimated replacement cost, location and description. Detailed records should be maintained of all additions and deletions to the General Fixed Assets Account Group. Management's Response: The Douglas County Board ofEduc~tion concurs with the finding but will not initiate reporting fixed assets on the financial statements because ofthe prohibitive cost ofassessment, valuation, and accounting for those assets. ill FEDERAL AWARD FINDINGS AND QUESTIONED COSTS No matters were reported. -2-