,~A, A W Sunc 214 AIIJnla, Gcorg1J 30334-g.\OO June 25, 2003 Honorable Sonny Perdue, Governor Members of the General Assembly Members of the State Board ofEducat10n and Supenntendent and Members of the City of Bremen Board of Education INDEPENDENl AUDITOR'S COMBINED REPORT ON GENERAL-PURPOSE FINANCIAL STATEMENTS AND SUPPLEMENTARY INFORMATION SCHEDULE OF EXPENDITIJRES OF FEDERAL AWARDS Ladies and Gentlemen We have audited the accompanying general-purpose financial statements of the City of Bremen Aoard of Educat10n. as of and for the year ended June 30, 2002, as listed in the table of contents lbese general-purpose financial statements are the respons1b1lity of the City of Bremen Board of Educauon's management Our responsibility 1s to express an op1mon on these general-purpose financial statements based on our audit We conducted our audn in accordance wnh auditing standards generally accepted in the Umtcd States of Amenca and the standards applicable to financial audns contained in Government Auditing Standards. issued by the Comptroller General of the United States Those standards rcqmre that we plan and perform the audit to obtain reasonable assurance about whether the financial statement~ are free of matenal misstatement An audn includes examining, on a test basis. evidence supporting the amounts and disclosures in the financial statements An audit also includes assessing the accounting pnnc1ples used and s1gmficant estimates made by management, as well as evaluating the overall financial statement presentat10n We believe that our audit provides a reru.onable basis for our opinion As described in the notes to the general-purpose financial statements, the Board of Education's financial statements have heen prepared using certain accounung practices and policies which. in our op1mon. vary in some respects from generally accepted accounting pnnc1ples These vanances are de~cnbed as follows 2002ARL-13 The general-purpose financial statements of the Board of Education did not contain a General Fixed Assets Account Group to account for property and equipment owned by the Board of Education which should be included to conform to generally accepted accountmg pnnciples School activity accounts mamtamed at the md1v1dual schools are not mcluded m the general-purpose financial statements To conform to generally accepted accounting pnnc1ples, these accounts should be included m the general-purpose financial statements The Board of Education did not recogmze as expenditures, m the year ended June 30. 2002, a portion of salanes and the correspondmg employer's cost of related benefits earned for contractual services completed prior to June 30, 2002 Also funds received, subsequent to June 30, 2002, from the Georgia Department of Education for the State's share of these unrecorded salanes and related benefits were not recorded as revenue m the year under review. Conversely, the similar expenditures and related revenues for contractual services completed pnor to June 30, 2001, were improperly recorded m the year ended June 30, 2002 To conform to generally accepted accountmg prmc1ples, revenues should be recorded when available and measurable and expenditures should be recorded when mcurred, rather than when funds are received or disbursed The aggregate effects on the general-purpose financial statements of these vanances or om1ss1ons have not been determined, but are believed to be matenal In our opimon, except for the effects on the general-purpose financial statements of the matters referred to m the precedmg paragraph, the general-purpose financial statements referred to above present fairly, m all material respects, the financial position of the City of Bremen Board of Educallon as of June 30, 2002, and the results of its operallons and the cash flows of its nonexpendable trust fund for the year then ended, m conformity with accounllng pnnc1ples generally accepted in the United States of Amenca In accordance with Government Aud1tmg Standards, we have also issued our report dated June 25, 2003, on our consideration of the City of Bremen Board ofEducallon's mtemal control over financial reportmg and our tests of its compliance with certain provisions oflaws, regulations, contracts and granu, That report 1s an integral part of an audit performed in accordance with Government Aud1tmg Standards and should be read m conJuncllon with this report in considenng the results of our audit Our audit was performed for the purpose of formmg an opimon on the general-purpose financial statements of the City of Bremen Board of Education taken a~ a whole The accompanying combmmg statements (Exhibits G through J) and the financial schedules (Schedules l through 5). which includes the Schedule of Expenditures of Federal Awards as required by U S Office of Management and Budget Circular A-133, Audits of States, Local Governments, and Non-Profit Orgam=atwns. are presented for purposes of additional analysis and are not a required part of the general-purpose financial statements Such mformation has been subjected to the aud1tmg 2002ARL-13 procedures applied in the audit ofthe general-purpose financial statements and m our opinion. except for the effects ofthe matters referred to in the thud paragraph, such information 1s fairly stated, in all material respects, m relation to the general-purpose financial statements taken as a whole A copy ofthis report has been filed as a permanent record m the office of the State Auditor and made available to the press ofthe State. as provided for by Official Code of Georgia Annotated Section 506-24. Respectfully submitted, RWHgp 2002ARL-l3 CITY OF BREMEN BOARD OF EDUCATION - HARALSON COUNTY --- - - ------- CIJY OF BREMEN BOARD OF EDUCATION - HARALSON COUNTY COMBINED BALANCE SHEET ALL FUND TYPES ANP ACCOUNT GROUP JUNE 30 2002 ~ Cash and Cash Equivalents Investments Accounts Receivable Prepaid Items Inventories Food Donated Commodllies Pt.dlased Food Amount Available m Debt SeMce Fund Amount to be Provided In Future Years For Payment ot Bond Debt Caprtal Lease Agreements Total Assets GENERAL FUND GOVERNMENTAL FUND TYPES SPECIAL CAPITAL REVENUE PROJECTS FUND FUND s s s 703,224 37 169 690 60 4,671,890 14 54,164 48 68,011 61 425 145 70 670911 1,675 60 s s s 757 368 85 2661287 12 51097:035 84 blABl6ITIEl;; AND FIJNQ EQ!IITY UABILmES Accounts Payable Salal1e1 Payable Expired Grant Balances Payabla Contracts Payabla Retamages Payable Capital Lease Agreements General Obllgahon Bonds Payable Total uabilllles FUND EOUIIY Fund Balances Reserved For Bus Roplacemont Funds For Debt Service For Endowment Corpus For lnventones Food Donated Commodrties PurchaM!d Food For Purpose of Bond Issue For SPLOST Protects Unreserved Undes,gnated Total Fund Equity s 63 476 37 s 56 856 71 s 2200 12,681 22 100 329 77 9660 20 027 13 2,225 24 s 76 157 59 s s 157,283 26 22 274 37 s 19,661 00 s 670911 1,675 60 s 4,652,604 90 222 156 57 661 570 26 100 619 13 0 00 s s s 681,231 26 109 003 64 5 074 761 47 Total uablhtles and Fund Equity s 757 368 65 s The notes to the general-purpose financial &tatement& are an lr\tegral part of ttns statement -2 - s 26628712 5 097 035 64 EXHIBIT "A" DEBT SERVICE FUND FIDI./CIARY FUND TYPE TRUST FUND s s 85 907 64 000 ACCOUNT GROUP GENERAL LONG-TERM DEBT TOTALS {Memorandum Onl;i) JUNE 30, 2002 JUNE 30, 2001 s s 5 630 912 75 1,6TT,827 65 20 000 00 567,321 99 267,005 22 652 57 s 85,907 64 870911 1 675 60 85 907 64 8,683 68 2,844 29 1 760 22 s 85 907 64 s 5,299 092 38 59,304 50 5 299 092 38 59 304 50 1,083,239 78 157 054 91 s s s 000 514441304 50 11.650,923 95 3 219 068 32 s 120 355 08 s 143 860 19 113,010 99 96,234 27 9680 431 70 20,027 13 s 59,304 50 2 225 24 59 304 50 9 028 10 157 054 91 5,385,000 00 5 385 000 00 1 085 000 00 s s 5,444,304 50 s 5 700 019 74 1 491 609 17 $ 85 907 64 000 s s 85 907 64 s s 85 907 64 s s 19,661 00 $ 15,219 00 85 907 64 1 760 22 20 000 00 670911 1 675 60 4,852 604 90 222 156 57 8,683 68 2,844 29 182,199 19 768,709 68 000 782 189 39 728 042 89 000 s 5,950,904 21 s 1 727459 15 s s s 0 00 544430450 11,6501923 95 3,2191068 32 . 3. CITY OF BREMEN BOARD OF EDUCATION HARALSON COUNTY COMBINED STATEMENT OF REVENUES EXPENDITURES AND CHANGES IN FUND BALANCES ALL GOVERNMENTAL FUND TYPES YEAR ENDED JUNE JO 2002 REVENUES State Funds Federal Funds Taxes Other Funds Total Revenues EXPENDITURES Current lnstruchon Support Services Pupil Services Improvement of Instructional Sarvas Educational Med,a Services General Administration School Admlnlstrabon Business Administrabon Maintenance and Operation of Plant Student Tranoportabon Services Cen1ral Support Serv1ces Other Support ServlC89 Food Services OperaUon En1erpnse Operabons Cspltal OuUay Deb1Serv,ce Principal Interest To1al Expend~ures Excess of Revenues over (under) Expenditures QTt!!;R FINANCING QURC!i (USES} Proceeds from General Obltgabon Bonds Par Value Capital Lease,, Operating Transfers In Operating Transfe~ Out To1al Other F1nancmg Sources (Uses) Excess of Revenues and Other Flnanang Sources over (under) Expenchtures and Other Financing Uses FUND BALANCE JULY 1 Food lnven1ory. Net Change 1n Penod Donated Commodnles Purchased Food GENERAL FUND SPECIAL REVENUE FUND $ 7,039,706 31 $ 5351362 1,212,019 28 425 839 21 444,157 19 643,434 30 325,576 89 s $ 8,731,078 42 1413 168 38 s 6,479,092 22 $ 226,839 23 151,10424 192 104 58 207,127 25 624,872 80 75,912 53 582,362 49 52,075 45 27 879 93 4 516 55 85,033 92 579,827 24 47,800 51 240,134 28 85 53 27,361 88 5,456 51 10,734 78 508,42542 15,09517 2 465 62 s s 8,706,482 18 1419826 15 s s 24 596 24 -6 657 77 s 21,514 89 s -1795342 s 3 561 47 $ 17,95H2 17 953 42 $ 28,157 71 s 11,295 65 653,073 55 100,651 45 -1,97457 -116869 FUND BALANCE JUNE 30 $ s_ _ 681 231 26 1,,09=0_03._84._ The notes to the general-purpose finanCl&I statements are an Integral part of this statement .4. EXHIBIT "B" CAPITAL PROJECTS FUND DEBT SERVICE FUND TOTALS (Memorandum On!);) YEAR ENDED JUNE 30, 2002 JUNE 30, 2001 s 149,166 ~9 s s 7,633,030 39 7,386,743 85 s 519,305 37 662,953 00 696,947 92 2,394,277 65 738,325 10 2,363,339 52 81 559 89 2 618 79 835 594 78 753 476 34 s 750 032 15 $ 665 571 79 $ 1155985074 $ 1124188481 $ 102 000 00 1 152,851 38 s 10417013 9 951 59 s $ 1 368 973 10 s -618 940 95 $ s s 7,058,919 48 6,554,282 60 274,639 74 391 238 52 192,19011 234,48913 624,872 80 177 912 53 567,819 00 62,810 23 27,879 93 512,941 97 85 033 92 1,152,851 38 238,700 90 481,880 73 181,36548 209,146 09 643,61648 90 261 91 571,744 03 53,532 56 3,819 65 31,978 20 506,74816 71,586 51 779,026 31 630000 00 13863102 768 631 02 $ s -103 059 23 749,265 30 15104843 s 12,263,912 45 s -704 061 71 643,733 43 67 888 76 11109111 80 132 773 01 s s 4,742,793 35 s $ 4 742 793 35 s s 4 123 852 40 950 909 07 187,206 65 $ s 187 206 65 4,930,000 00 s 21 514 89 17,953 42 -17 953 42 s 4 951 514 89 140,795 39 1179954 -1179954 140 795 39 s 84,147 42 1 760 22 4,247,453 18 $ 1 706,594 29 273,568 40 1432,41805 -1,974 57 -1 168 69 855 51 -247 67 s 5074 76147 $ 85 907 64 $ - 5. _ C[TY Of BREMEN BOARD OF EDUCATION - HARALSON COUNTY COMBINED STATEMENT OF REVENUES EXPENDITIJRES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL - (NON-GAAP BASIS! GENERAL AND SPECIAL REVENUE FUNDS YEAR ENDED JUNE 30 2002 EXHIBIT c GENERAL FUND BUDGET ACTUAL REVENUES Stale Funds Federal Funds Taxe& Other Funds Total Revenues s s 8 822 835 00 7 039 708 31 50 000 00 53 513 82 1,200 000 00 1.212 019 28 34 10000 25 839 21 $ 8. 18.935 00 $ 8.731,07B 2 EXPENDITURES Current lnstrucbon Support Services Pupil SeMCeS Improvement of ln1trudk>nal SeMces EoocabOnal Madia Selvlces General Adnunistratton Schod AdmmistratK>n Business AdmriMalrrtenance 811d Operaban of Plant Swdent TranspOrtatlon Sennces Central Support SeMces Other Support SeMces Food Serw:es Openlbon En1erprt&e OperabOns DebtServk:e Total Expenditures Excess of Revenues over (under) "-"n and IS presented on the mod1fted aca\l8I ba&ls of account.lg which ,s the basis of accounting used In the presentation of the general-purpose financial statements See notes to the general-purpose flnanc&al statements - 29 - CITY OF BREMEN BOARD OF EPUCAJION HARALSON COUNTY SCHEDULE OF STATE REVENUE YEAR ENPEP JUNE 30 2002 SCHEDULE"? AGENCYtfUNPING GRANTS Educabon, Geoon (!1-12) Program YOC811onel Laboratory (!1-12) Program Students with Olsab1hbes Category I CStogory II CStogorylll Cotego6-2174 DEPARTMENT OF AUDITS AND ACCOUNTS 254 W.1.shmgton Street.~ W Suite 214 AtlJnta. Georgi 30334-8400 June 25. 2003 Honorable Sonny Perdue, Governor Members of the General Assembly Members of the State Board of Education and Supenntendent and Members of the City of Bremen Board ofEducallon REPORT ON COMPLIANCE WITH REQUIREMENTS APPLICABLE ro EACH MAJOR PROGRAM AND ON INTERNAL CONTROL OVER COMPLIANCE IN ACCORDANCE WI fH 0MB CIRCULAR A-133 Ladies and Gentlemen. Compliance We have audited the compliance of City of Bremen Board ofEducat1on with the types ofcompliance requirements described in the US Ojjice of Management and Budget (0MB) C1rc11lar A-133 Comphance Supplement that are applicable to each of1ts maJor Federal programs for the year ended June 30, 2002 City of Bremen Board of Education's major Federal programs arc 1dent1fied in the Summary of Auditor's Results Section of the accompanying Schedule of Findings and Questwned Costs Compliance with the requirements of laws, regulauons, contracts and grants applicable to each of its maJor lederal programs 1s the respons1b1lity of City of Bremen Board of Education's management. Our respons1b1lity 1s to express an opm1on on City of Bremen Board of l::ducat1on's compliance based on our audit We conducted our audit of compliance m accordance with aud1tmg standards generally accepted m the Umted States of Amenca. the standard~ applicable to financial audits contamed m Government Aud1tmg Standards. issued by the Comptroller General of the Umted States. and 0MB Circular Al 33. A11d111 of States, Local Governments. and Non-Profit Orgam=atwns 1 hose standards and 0MB Circular A-133 require that we plan and perform the audit to obtam re~onable a~sumnce ahout whether noncompliance with the types ofcompliance requirements referred to above that could have a direct and material effect on a maJor Federal program occurred An audit includes exam ming, on a test bas1~. evidence about the City of Bremen Board of Educat10n's compliance with those requirements and perfonnmg ~uch other procedure~ as we considered necessary in the c1rcumstances We believe that our audit provides a reasonable baMs for our op1mon Ou, audit does not provide a legal detenninauon on City of Bremen Board ofEducallon's compliance 1th those requ1remen~ w, 2002SA-I0 In our opimon, the Cny of Bremen Board of Educat10n complied. in all matenal respects, With the reqmrements referred to above that are applicable to each of its maJor Federal programs for the year ended June 30, 2002. Internal Control Over Compliance The management of City of Bremen Board of Education 1s responsible for establishing and maintaining effective mtcrnal control over compliance With requirements of laws, regulations. contracts and grants applicable to Federal programs In planmng and performing our audit, we considered City of Bremen Board of Education's internal control over compliance With reqmrements that could have a direct and material effect on a maJor Federal program in order to determine our audning procedures for the purpose of expressing our op1mon on compliance and to test and report on internal control over compliance in accordance With 0MB Circular A-133 Our cons1derauon of the internal control over compliance would not necessanly disclose all matters in the internal control that might be matenal weaknesses A material weakness 1s a cond1tton in which the design or operatton of one or more ofthe internal control components does not reduce to a relattvely low level of nsk that noncompliance With applicable requirements oflaws, regulattons, contracts and grants that would be matenal in relat10n to a maJor Feder-di program being audited may occur and not be detected within a ttmely penod by employees in the normal course of performing thetr assigned functions. We noted no matters involving the internal control over compliance and its operatton that we consider to be matcnal weaknesses Thi~ report is intended solely for the informat10n and use ofthe management. members ofthe City of Bremen Board ofEducatton, Federal awardmg agencies and pass-through entitles and 1s not mtended to be and should not be used by anyone other than these specified parties ---~Respectfully submitted, RWHgp 2002SA-I0 State Auditor SECTION Ill AUDITEE'S RESPONSE TO PRIOR YEAR FINDINGS AND QUESTIONED COSTS CITY OF BREMEN BOARD OF EDUCATION - HARALSON COUNTY AUDITEE'S RESPONSE SUMMARY SCHEDULE OF PRIOR YF AR FINDINGS AND QUESTIONED COSTS YcAR ENDED JUNE 30, 2002 PRIOR YcAR FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS FINDING CONTROL NUMBER AND STATUS FS-7631-00-01 FS-7631-01-01 Further Action Not Warranted Unresolved - See Corrective Action/Responses CORRECTIVE ACTION/RESPONSES GENERAL FIXED ASSETS Failure to Maintain General Fixed Assets Account Group FmdmgControl Number: FS-7631-01-01 The School District has contracted v.,1th Amencan Appraisal Associates to cap1taliLe assets m excess of $10,000 00 and to mamtam an inventory of computer eqmpment and assets valued at $1,000.00 to $9,999.00. The School District 1s currently workmg m con3unct1on with the Depart111ent of Education to add the fixed asset software (FASgov Capital Assets Inventory) to the PC Genesis program. PRIOR YEAR FEDERAL AWARD FINDINGS AND QUESTIONED COSTS FINDING CONTROL NUMBER AND STATUS FA-7631-01-01 Previously Reported Correcllve Action Implemented SECTION IV FINDINGS AND QUESTIONED COSTS CITY OF BREMEN BOARD OF EDUCATION - HARALSON COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 2002 SUMMARY OF AUDITOR'S RESULTS Type of Report Issued on the Financial Statements The auditor's opinion on the City of Bremen Board of Education's financial statements was qualified for various departures from generally accepted accounting pnnc1ples 2. Reportable Conditions in Internal Control Disclosed by the Audit of the Financial Statements The audit report for the City of Bremen Board ofEducal!on disclosed a financial statement reportable cond1t10n related to the following control category General Fixed Assets The reportable condition described above 1s considered to be a matenal weakness 3 Noncomphance Matenal to the Financial Statements The audit of the City of Bremen Board of Education disclosed no instances of noncompliance that were deemed to be matenal to the financial statements 4 Reportable Condit10ns in Internal Control Over Ma1or Programs The audit report for the City of Bremen Board of Education did not disclose any reportable conditions in internal control over major programs 5 Type of Report Issued on Compliance for Ma1or Programs The auditor's op1ruon on the City of Bremen Board of Education's report on comphance with reqmrements apphcable to major programs was unquahfied 6 Audit Fmdmgs Required to be Reported by Section 510(a) ofOMB Circular A-133 The City of Bremen Board of Education's audit did not disclose audit findings reqmred to be reported by section 510(a) ofOMB Circular A-133 7 Major Programs Federal awards audited as ma1or programs are as follows IO 553 Food and Nutnt1on Program - Food Services - School Breakfast Program I 0.555 Food and Nutrit10n Program - Food Services - Nat10nal School Lunch Program 84.010 Elementary and Secondary Educat10n Act - Title I - Grants to Local Educat10nal Agencies 8 Type "A" Program Dollar Threshold The dollar threshold for type "A" programs was $300,000 00 9 Low Risk Aud1tee The City of Bremen Board of Educat10n did not qualify as a low nsk audnee as defined by Section 530 of 0MB Circular A-133 - I- CITY OF BREMEN BOARD OF EDUCATION - HARALSON COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 2002 II FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS GENERAL FIXED ASSETS Failure to Maintain General Fixed Assets Account Group Reportable Cond111on - Material Weakness Repeated From Prior Year Finding Control Number FS-7631-02-01 The City of Bremen Board of Education did not maintain a system-wide General Fixed Assets Account Group withm the formal accounting records as required by generally accepted accounting pnnc1pals ThIS cond1t1on results in the general-purpose financial statements of the School District being mcomplete and not in accordance with generally accepted accounting pnnc1ples Appropnate act10n should be taken by the School District to establish accounting controls and procedures to provide for maintenance ofa General Fixed Assets Account Group. These subsidiary records should include an inventory of land, bmldmgs and equipment owned by the School District and should include, but may not be limited to, date acquired, acqms1t10n cost. esnmatcd replacement cost, location and descnpt10n Detailed records should be maintamed of all add1t1ons and deletions to the General Fixed Assets Account Group Management's Response The School D1stnct has contracted with American Appl'!llsal to cap1tali.le assets in excess of $10,000 00 and to mamtam an mventory of computer eqmpment and assets valued at $1,000 00 to $9,999 00 The School D1stnct is currently working to meet this audit requirement at the end of the fiscal year 2003 audll, as well as, GASB 34 reqmrements lil FEDERAL AWARD FINDINGS AND QUESTIONED COSTS No matters were reported -2 -