GA ABOO .RI Div S5 1m-1+ STATE OF GEORGIA DEPARTMENT OF AUDITS 254 WASHINGTON STREET ATLANTA. GEORGIA 30334 AUDIT REPORT SEMINOLE COUNTY BOARD OF EDUCATION DONALSONVILLE, GEORGIA YEAR ENDED JUNE 30, 1994 SEMINOLE 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 FEDERAL FINANCIAL ASSISTANCE EXHIBITS 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 GOVERNMENTAL FUND TYPES AND EXPENDABLE TRUST FUND 4 C COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - ACTUAL AND BUDGET GOVERNMENTAL FUND TYPES 6 D NOTES TO THE GENERAL PURPOSE FINANCIAL STATEMENTS 7 ADDITIONAL FINANCIAL INFORMATION COMBINING STATEMENTS SPECIAL REVENUE FUND E COMBINING BALANCE SHEET 18 F COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES 20 CAPITAL PROJECTS FUND G COMBINING BALANCE SHEET 22 H COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES 23 SEMINOLE COUNTY BOARD OF EDUCATION - TABLE OF CONTENTS - ~ SECTION! FINANCIAL ADDITIONAL FINANCIAL INFORMATION SCHEDULES l SCHEDULE OF FEDERAL FINANCIAL ASSISTANCE 24 2 ANALYSIS OF CASH AND CASH EQUIVALENTS 26 3 ACCOUNTS RECEIVABLE 27 4 DEBT SERVICE REQUIREMENTS TO MATURITY 28 SCHEDULE OF REVENUE 5 STATE FUNDS 29 6 LOCAL AND OTHER FUNDS 30 SCHEDULE OF EXPENDITURES BY OBJECT 7 GOVERNMENTAL FUND TYPES 31 8 LOTTERY PROGRAMS 32 9 FIDUCIARY FUND TYPE EXPENDABLE TRUST FUND 33 ANALYS!S OF MINIMUM EXPENDITURE REQUIREMENTS GENERAL FUND - QUALITY BASIC EDUCATION PROGRAMS 10 OVERALL 35 11 BY PROGRAM 36 12 SCHEDULE OF COMPENSATION OF BOARD MEMBERS 38 SECTION II COMPLIANCE COMPLIANCE REPORT BASED ON AN AUDIT OF THE FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS SINGLE AUDIT REPORT ON COMPLIANCE WITH THE GENERAL REQUIREMENTS APPLICABLE TO FEDERAL FINANCIAL ASSISTANCE PROGRAMS SINGLE AUDIT OPINION ON COMPLIANCE WITH SPECIFIC REQUIREMENTS APPLICABLE TO MAJOR FEDERAL FINANCIAL ASSISTANCE PROGRAMS SINGLE AUDIT REPORT ON COMPLIANCE WITH SPECIFIC REQUIREMENTS APPLICABLE TO NONMAJOR FEDERAL FINANCIAL ASSISTANCE PROGRAM TRANSACTIONS SEMINOLE COUNTY BOARD OF EDUCATION -TABLE OF CONTENTS- SECTION III INTERNAL CONTROL REPORT ON INTERNAL CONTROL STRUCTURE IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS SINGLE AUDIT REPORT ON THE INTERNAL CONTROL STRUCTURE USED IN ADMINISTERING FEDERAL FINANCIAL ASSISTANCE PROGRAMS SECTION IV FINDINGS AND IMPROPER OR QUESTIONED COSTS SCHEDULE OF FINDINGS AND IMPROPER OR QUESTIONED COSTS SECTION! FINANCIAL CLAUDE L. VICKERS STATE AUDITOR (404) 656-2174 DEPARTMENT OF AUDITS 254 Washington Street, S.W., Suite 214 Atlanta, Georgia 30334-8400 June 20, 1995 Honorable Zell Miller, Governor Members of the General Assembly Members ofthe State Board ofEducation and Superintendent and Members ofthe Seminole County Board of Education INDEPENDENT AUDITOR'S COMBINED REPORT ON GENERAL PURPOSE FINANCIAL STATEMENTS AND SUPPLEMENTARY INFORMATION SCHEDULE OF FEDERAL FINANCIAL ASSISTANCE Ladies and Gentlemen: We have audited the general purpose financial statements (Exhibits A through D) of the Seminole County Board of Education, as of and for the year ended June 30, 1994, as listed in the table of contents. These financial statements are the responsibility of the Board's management. Our responsibility is to express an opinion on these financial statements based on our audit. Except as discussed in the following paragraph, we conducted our audit in accordance with generally accepted auditing standards, Government Auditing Standards, issued by the Comptroller General of the United States, and the provisions of the Office of Management and Budget Circular A-128, "Audits of State and Local Governments". Those standards and 0MB Circular A-128 require that we plan and perform the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements. An audit also includes assessing the accounting principles used and 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. We did not observe the taking of either the Federal donated commodities inventory or purchased foods inventory at June 30, 1994, nor could we satisfy ourselves as to the accuracy of the amounts stated as inventories through alternative procedures. 94ARL-13 As described in the notes to the general purpose financial statements, the Board's financial 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. * 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, 1994, a portion ofsalaries and the corresponding employer's cost of related benefits earned for contractual services completed prior to June 30, 1994. Also funds received, subsequent to June 30, 1994, from the Georgia Department ofEducation for the State's share of these 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, 1993, were improperly recorded in the year ended June 30, 1994. 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 of these variances or omissions have not been determined, but are believed to be material. In our opinion, except for the effects ofsuch adjustments, ifany, on the Special Revenue Fund, as might have been determined to be necessary had we been able to satisfy ourselves as to the accuracy ofthe food service inventories as discussed in the third paragraph, and except for the effects on the general purpose financial statements of the matters referred to in the preceding paragraph, the general purpose financial statements present fairly, in all material respects, the financial position of the Seminole County Board ofEducation as of June 30, 1994, and the results of its operations for the year then ended, in conformity with generally accepted accounting principles. Our audit was conducted for the purpose of forming an opinion on the general purpose financial statements ofthe Seminole County Board ofEducation taken as a whole. The combining statements (Exhibits E through H) and the financial schedules (Schedules 1 through 12 which includes the Schedule of Federal Financial Assistance) are presented for purposes ofadditional analysis and are not a required part of the general purpose financial statements ofthe Seminole County Board ofEducation. Such information has been subjected to the auditing procedures applied in the audit ofthe general purpose financial statements and, in our opinion, except for the effect of adjustments, if any, on the Special Revenue Fund, as might have been determined to be necessary had we been able to satisfy ourselves as to the accuracy of the food service inventories as discussed in the third paragraph, and except for the effects of the matters referred to in the fourth paragraph, such information is fairly presented in all material respects in relation to the general purpose financial statements taken as a whole. 94ARL-13 A copy ofthis report has been filed as a pennanent 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, ~~ Claude L. Vickers State Auditor CLV:jy 94ARL-13 SEMINOLE COUNTY BOARD OF EDUCATION - 1- ASSETS Cash and Cash Equivalems Accoun1s Receivable Inventories Food Donated Commodities Purchased Food Amount Available in Debt Service Fund Amaunt1x> be Provided in FubJre Years For Payment of Bond Debt GENERAL FUND GOVERNMENTAL FUND TYPES SPECIAL CAPITAL REVENUE PROJECTS FUND FUND DEBT SERVICE FUND $ 1,318,341.70 $ 275,045.82 $ 116,162.04 $ 147,774.37 5,642.04 114,241.78 447,366.07 2,205.72 11,458.42 9,500.65 TotalAssets $ 1,323,983.74 $ 410246.67 $ 563,528.11 $ 149980.09 LIABILITIES AtjD FUND EQUITY ~ Acccunts Payable Salaries Payable Expired Grant Balances Payable Retainages Payable Deferred Revenue General Obligation Bonds Payable Total Liabilities FUND EQUITY Fund Balances Reserved For Bus Replacement Funds For Continuation of Federal Programs For Debt Service For Expired Grant Balances/Questioned Costs For Inventories Food Donated Commocfrties Purchased Food For State Capital Outlay Projects Unreserved Undesignated Total Fund Equity $ $ 12,064.55 $ 15,338.87 $ 27,423.42 $ 1,296,560.32 $ 1,323,983.74 $ 18,988.33 80,086.51 8,104.61 $ 69,934.69 177,114.14 $ 3,053.91 2,939.95 11,458.42 9,500.65 $ 26,952.93 $ 206,179.60 233,132.53 $ 263,585.10 263,585.10 $ 149,980.09 291,383.82 291,383.82 $ 8,559.19 299,943.01 $ 149,980.09 0.00 149,980.09 Total Liabilities and Fund Equity $ 1,323,983.74 $ 410,246.67 $ 563528.11 $ 149,980.09 The notes 1x> the general purpose financial statements are an integral part of this statement -2- EXHIBIT"A" FIDUCIARY FUND TYPES EXPENDABLE TRUST FUND $ 11,565.18 ACCOUNT GROUP GENERAL LONG-TERM DEBT TOTALS (Memorandum Onll) JUNE 30, 1994 JUNE 30, 1993 $ 1,868,889.11 $ 1,885,495.67 569,455.61 119,681.77 11,458.42 9,500.65 21,651.78 8,468.74 $ 149,980.09 149,980.09 161,858.69 135,019.91 135,019.91 183,141.31 $ 11 565.18 $ 265000.00 $ 2744303.79 $ 2 380,297.96 $ 18,988.33 $ 18,212.26 80,086.51 76,689.42 8,104.61 5,584.31 263,585.10 69,934.69 $ 265,000.00 265,000.00 345,000.00 $ 265,000.00 $ 725,699.24 $ 445,465.99 $ 11,565.18 $ 11,565.18 11565.18 $ $ 12,084.55 $ 29,853.75 3,053.91 7,069.59 149,980.09 161,858.69 18,278.82 3,313.55 11,458.42 9,500.65 291,383.82 21,651.78 8,468.74 306,076.79 $ 495,740.26 $ 538,292.89 1,522,864.29 1,396,519.08 $ 2,018,604.55 $ 1,934,811.97 265000.00 $ 2 744,303.79 $ 2 380,297.96 . 3. SEMINOLE COUNTY BOARD OF EDUCATION COMBINFD STATEMENT OF REVENUES EXPENDITURES AND CHANGES IN FUND BALANCES GOVERNMENTAL FUND TYPES AND EXPENDABLE TRUST FUND YEAR ENDED JUNE 30 1994 REVENUES State Funds Federal Funds Local and Other Funds Tclal Revenues EXPENDITURES Current Instruction Support Services Pupil Services Improvement of Instructional Services Educational Media Services General Administration School Administration Business Administration Maintenance and Operation of Plant Studant Transportation Services Central Support Services Other Support Services Food Services Operation Other Operations of Non-Instructional SO!Vices Capital Outlay Debt Service Principal Interest Paying Agant Fees Total Expenditures Excess of Revenues over (under) Expenditures OTHER FINANCING SOURCES /USES) Operating Transfers In Operating Transfers Out Total Other Financing Sources (Uses) Excess of Revenues and Other Financing Sources over (under) Expenditures and Other Financing Uses FUND BALANCE JULY 1 Food lnventc,y - Net Change In Period Donated Commodities Purchased Food GENERAL FUND SPECIAL REVENUE FUND GOVERNMENTAL CAPITAL PROJECTS FUND $ 5,200,696.00 $ 110,697.64 $ 2,665,921.22 1,104,319.26 1660553.32 117649.73 19885.73 $ 6 861 249.32 $ 1 332 666.63 $ 2 685 806.95 $ 4,019,869.30 $ 174,395.04 252,149.67 296,830.57 156,705.87 486,256.80 159,316.76 499,461.90 368,682.51 6,300.00 81,444.59 168,652.38 588,533.62 14,929.70 5,685.86 14,208.64 31,301.69 2,158.57 52,520.13 595,493.57 $ 2,798.499.92 $ 6 670 065.39 $ 1 304 831.78 $ 2 798 499.92 $ 191183.93 $ 27834.85 $ -112692.97 $ $ -109 586.94 $ -109 586.94 $ 11,586.94 $ 98,000.00 11 586.94 s_-"se"'ooo="'oo=- $ 81,596.99 $ 1,242,386.75 39,421.79 $ -14,692.97 202,872.19 314,635.98 -10,193.36 1031.91 FUND BALANCE JUNE 30 $ 1,323,983.74 $ 233, 132.53 $ 299,943.01 The notes to the general purpose financial statements are an integral part of this statement. -4- EXHIBIT"B" FUND TYPES DEBT SERVICE FUND TOTAL FIDUCIARY FUND TYPE EXPENDABLE TRUST FUND TOTALS {Memorandum Onl~ YEAR ENDED JUNE 30 1994 JUNE 30 1993 $ 7,977,314.86 1,104,319.26 $ 71345.15 1 869 433.93 $ $ 71 345.15 $ 10 951 068.05 $ $ 115.82 7,977,314.86 $ 1,104,319.26 1869549.75 5,177,167.00 970,104.22 1924842.BO 115.82 $ 10 951183.87 $ 8072114.02 $ 4,608,402.92 174,395.04 267,079.37 302,516.43 170,914.51 486,256.B0 159,316.76 530,763.59 370,841.08 58,820.13 595,493.57 81,444.59 $ 2,967,152.30 $ 60,000.00 22,710.00 513.75 60,000.00 22,710.00 513.75 $ 83223.75 $ 10 B56 620.84 $ $ -11878.60 $ 94447.21 $ $ 4,608,402.92 $ 4,388,460.33 1,609.00 174,395.04 267,079.37 302,516.43 170,914.51 486,256.B0 159,316.76 530,763.59 370,841.08 58,820.13 595,493.57 83,053.59 2,967,152.30 173,342.87 259,044.06 190,119.87 127,085.43 427,678.86 117,244.30 455,497.23 315,055.70 115,480.22 585,929.51 90,383.52 320,197.12 60,000.00 22,710.00 513.75 55,000.00 26,285.00 516.25 1609.00 $ 10858229.84 $ 7647320.27 -1493.18 S 92954.03 $ 424793.75 $ 109,586.94 -109586.94 $ 0.00 $ 109,586.94 $ -109586.94 $ 0.00 $ 2,560.46 -2560.46 0.00 $ -11,878.60 $ 94,44721 $ 161,858.69 1,921,753.61 -1,493.18 $ 13,058.36 92,954.03 $ 424,793.75 1,934,811.97 1,507,302.80 -10,193.36 1031.91 -10,193.36 1031.91 -1,854.13 4569.55 $ 149980.09 $ 2,007 039.37 $ 11,565.18 $ 2,018,604.55 $ 1,934,811.97 -5- $EMINQI E COUNTY BOARD OF EDUCATION CQMBlNf;Q STATEMENT QF REVENUES EXPfNPITURES ANP CHANGES IN Fl INP BAl ANCES ACTUAL AND BUDGEJ -GOVERNMSNTAL FUNP IYPES YEAR ENDED JUNE 30 1994 EXHIBIT"C" ~ State Funds Federal Funds Local and Other Funds Total Revenues EXPENQITUBES Currant lnslnldion Support Services Pupil Services Improvement ol lnslnx:tional Services Educational Madia SeMces General Administration School Administration Business Administration Maintenance and Ope.ration of Plant Student TranspoROPER OR QUESTIONED COSTS YEAR ENDED JUNE 30 1994 CURRENT YEAR AUDIT FOLLOW-UP/RESOLUTION . Failure to File Corrective Action Plan Federal Financial Assistance Nonrnaterial Noncompliance Audit Control Number 7251-94-07 Our audit disclosed that the Board failed to submit corrective action plans for the 1993 audit report as required by 0MB Circular A-128 to the Southwest Georgia Regional Development Center and the Berrien County Board ofEducation from whom the Board received Job Training Partnership Act funds (CFDA 17.250) and Elementary and Secondary Education Act - Chapter 1 - Migratory Education funds (CFDA 84.011), respectively. This condition occurred because management was not aware of the provisions of 0MB Circular A-128. The Board should implement procedures to submit corrective action plans in a timely manner as required. ELIGIBILITY Failure to Maintain Applications Federal Financial Assistance Major/Nonrnajor Program Reportable Condition Nonrnaterial Noncompliance Amount: $2,939.95 Audit Control Number 7251-94-08 During the year under review, $2,939.95 was received from the Georgia Department of Education as reimbursement ofmeals served at the Seminole County Primary School as claimed on the Monthly "DE form 106" report for the National School Lunch (CFDA 10.555) and School Breakfast (CFDA 10.553) Programs. This amount represents reimbursement of$ I,93 5.10 for the National School Lunch Program and $1,004.85 for the School Breakfast Program for which the Board was unable to provide the required applications. The Code ofFederal Regulations, 7CFR Part 210.15 (b) requires, in part, the Board shall maintain: "Currently approved and denied applications for free and reduced price lunches and a description of the verification activities..." SEMINOLE COUNTY BOARD OF EDUCATION SCHEDULE OF FINDINGS AND IMPROPER OR QUESTIONED COSTS YEAR ENDED JUNE 30 1994 CURRENT YEAR ELIGIBILITY Failure to Maintain Applications Federal Financial Assistance Major/Nonmajor Program Reportable Condition Nonmaterial Noncompliance Amount: $2,939.95 Audit Control Number 7251-94-08 This condition occurred because management failed to maintain all applications for students listed on the Seminole County Primary School's Master List of Free and Reduced Price Meal Applications. The Board should implement procedures to ensure that applications for free and reduced priced meals are maintained for eligible students as required. This questioned cost should be refunded to the Georgia Department of Education. Note: The Seminole County Board ofEducation was provided an opportunity to include pertinent comments from the Board's management concerning these audit findings, conclusions and recommendations. The Board has elected not to provide comments for inclusion in this report.