GA:~' - ABoo- : R' l;~v ,5.5,: J'oo-1 _;;zix,;i. ' -- ,/ r,. .., '. '. 'i .. ' \ '. -..- -' ., ::, ...' ,, - ' -, ,. - -, ; . ' ,. ' .- '. , . t, ' I ' ', . ' ' ' REPORT ,, ON AUDrr . ' , OF THE FINANCIAL STATEMENTS 1 - - r' ' ' FOR .THE 'FIS. CA(YEA, R ENDED-JUNE 30,'. 2002 - ~ ' ~. ,t ~ .. ' ., .,. - , _, ,. ,- ' -' .- '' 1., .- ' ., . ' ' Russell W. Hinton _State Au~ltor . - ' ; J , , . '. \ ., SEMINOLE COUNTY BOARD or EDUCATION -TABLE or CONTENTS- Page SECTION I FINANCIAL INDEPENDENT AUDITOR'S COMBINED RF PORT ON GENERAL-PURPOSE FINANCIAL STATEMENTS AND SUPPLEMENTARY INFORMATION SCHEDULE OF EXPEND! I URES OF FEDERAL AWARDS EXHIBITS GENERAL-PURPOSE FINANCIALS I A I EMENTS COMBINED STATEMENTS - OVERVIEW A COMBINED BALANCE SHEl:T ALL FUND TYPES 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 6 D NOTES TO l HE GENERAL-PURPOSE FINANCIAL STATEMENTS 7 ADDITIONAL FINANCIAL INFORMATION COMBINING STATEMENTS SPECIAL REVENUE FUND E COMBINING BALANCE SHEET 16 r COMBINING STATEMEN I OF REVENUES, tXPENDITURES AND CHANGES IN FUND BALANCES 18 CAPITAL PROJECTS FUND G COMBINING BALANCE SHEET 20 H COMBINING STATEMENT Or REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES 21 SCHEDULES SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS 22 2 SCHEDULE OF Sl ATE REVENUE 24 3 SCHEDULE OF APPROVED LOCAL OPTION SALES TAX PROJECTS 25 ALLOTMENTS AND EXPENDll URES GENERAL rUND - QUALITY BASIC EDUCATION PROGRAMS (QBE) 4 DY PROGRAM 26 5 DY SITE 27 SEMINOLE COUNTY BOARD OF FDUCATION - TABLE OF CONTENTS - SECTION II COMPLIANCE AND IN rFRNAL 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 ON INTERNAL CONTROL OVER COMPLIANCE IN ACCORDANCE WITH 0MB CIRCULAR A-133 SECTION Ill AUDITEE'S RESPONSE TO PRIOR YEAR FINDINGS AND QUESTIONED COSTS SUMMARY SCHEDULE OF PRIOR YEAR FINDINGS AND QUESTIONED COSTS SECrlON IV FINDINGS AND QUESTIONED COSTS SCHEDULE or FINDINGS AND QUESTIONED cos rs SECTION I FINANCIAL w. RtlS',H I HIN w, STATF Al.JDITr.fl ,4,.,.1; E~6 :>11 DEPARTMENT OF AUDITS AND ACCOUNTS 25,l \\'J,htng.ton ~ln.:ct. !'I W ~u11c :214 All,inlJ Getrg1J 10114-8400 June 17, 2003 Honorable Sonny Perdue, Governor '.'vlembers of the General Assembly Members of the State Board of Education and Superintendent and Members of the Seminole County Board of Education fNDEPENDENT AUDITOR'S COMBfNED REPORT ON GENERAL-PURPOSE FrNANCIAL S l"ATEMENTS AND SUPPLEMCNTARY INFORMATION SCHEDULE OF EXPEND I I URES OF FEDERAL AWARDS Ladies and Gentlemen We have audited the accompanying general-purpose financial statements of the Seminole County Board of Education. as of and for the year ended June 30. 2002. as listed in the table of contents The,e general-purpose financial statements are the respons1b1lity of the Seminole County Board of Education's management Our respons1b1lity 1s to express an op1mon on these general-purpose financial statement, based on our audit We conducted our audit in accordance with auditing standards generally accepted in the Umted State, of t\menca and the standards applicable to financial audits contained in Government Auditing Standard,. 1s,ucd by the Comptroller General of the Umted States Those standards require that we plan and p,:rfonn the audit to obtain reasonable assurance about whether the financial ,tatements are free of matenal m1,,tatement An audit includes e'l.arnining. on a test ba,1s. evidence ,upportmg the amount, and disclosures m the financial statements An audit also includes as,essing the accounting pnnc1ple, used and s1gmficant estimates made by management. as well as evaluating the overall financial ,tatement pre,entatlon We believe that our audit provides a reasonable basis for our opm1on As de,cnbed in the note, to the general-purpose financial statement,, the Board of Educatwn', financial ,tatements have been prepared usmg certain accounting practices and policies which, in our op1mon. vary in some respect, from generally accepted accounting principles fhese vanances are descnbed a, 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 Educat10n which should be included to conform to generally accepted accounting pnnc1ples School activity accounts maintained at the ind1v1dual schools are not included in the general-purpose financial ~tatements To conform to generally accepted accounting pnnc1ples, these accounts should be included in the general-purpose financial statements The Board of Education did not recognize as expenditures, in the year ended June 30, 2002, a portion of salanes and the corresponding employer's cost of related benefit, earned for contractual ,erv1ces completed pnor to June 30, 2002 Also fund, received, subsequent to June 30, 2002, from the Georgia Department of Education for the State's ,hare of these unrecorded salaries and related benefits were not recorded as revenue in the year under review Conversely, the s1m1lar expenditures and related revenues for contractual service, completed pnor to June 30, 200 I, were improperly recorded in the year ended June 30, 2002 To conform to generally accepted accounting pnnc1ples, 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 vanances or om1ss10ns have not been determined, but are believed to be matenal In our op1mon, 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 matenal respects, the financial pos1Uon of the Seminole County Board of Education as ofJune 30, 2002, and the results of 1ts operat10ns for the year then ended, in conforrmty with accounting pnnc1ples generally accepted in the Umted States of America In accordance with Government Auditing Standards, we have also issued our report dated June 17, 2003, on our cons1deratton of the Seminole County Board of Education', internal control over financial reporting and our tests of its compliance with certain prov1s10ns of laws, regulat10ns. contracts and brrants That report 1s an integral part of an audit performed in accordance with Government Auditing Standards and should be read m conJunctlon With this report in cons1denng the re,ult, of our audit. Our audit was performed for the purpose of forming an opinion on the general-purpose financial statements of the Seminole County Board of Education taken as a whole The accompanying combining statements (Exh1b11s E through H) and the financial schedules (Schedules I 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 oj States. Local Governments. and Non-Projit Orgamzallons, arc presented for purposes of add1t1onal analysis and are not a required part of the general-purpose financial statements Such information ha~ been subjected to the auditing 2002ARL-13 procedure~ applied m the audit of the general-purpose financial statements and m our op1mon, except for the effects of the matters referred tom the third paragraph, such mformat1on is fairly stated, in all matenal respects. m relation to the general-purpose financial statements taken as a whole A copy ofth1s report has been filed as a permanent record m the office ofthe State Auditor and made ava1lable to the press of the State, a~ provided for by Official Code of Georgia Annotated Section 506-24 Respectfully submltled. RWHgp 2002ARL-13 Hmton Sta e Auditor SEMINOLE COUNTY BOARD OF EDUCATION SEMINOLE COUNTY BOARD OF EDUCATION COMBINED BALANCE SHEET ALL FUND TYPES JUNE 30. 2002 ASSETS Cash and Cash Equ1Valents Investments Accounts Receivable Prepaid Items lnventones Food Donated Commodrties Purchased Food GOVERNMENTAL FUND SPECIAL GENERAL REVENUE FUND FUND $ 2,076,353 33 $ 417,648 02 127,507 08 373,435 91 1,500 00 8 927 35 11,04553 Total Assets $ 21203.860 41 s ___8_12_1..5.56='=8""1"" LIABILITIES AND FUND EQUITY LIABILITIES Accounts Payable Salanes Payable Expired Grant Balances Payable Contracts Payable Deferred Revenue Total Llab1ht1es FUND EQUITY Fund Balances Reserved For lnventones Food Donated Commodrties Purchased Food For SPLOST ProJects Unreserved Designated for Self-Insurance UndesIgnated Total Fund Equity $ 310,608 99 $ 196,407 27 4,203 60 130,716 72 97928 $ 314,812 59 $ 328,103 27 $ 8,927 35 11,045 53 $ 1,889,047 82 $ 1,889,047 82 $ 464480 66 464453 54 Total L1ab1lrt1es and Fund Equity $ 2.203 860 41 s ___8_12_.5__56_8_1_ 1 The notes to the genera~purpose financial statements are an integral part of this statement -2 - EXHIBIT"A" TYPES CAPITAL PROJECTS FUND TOTALS (Memorandum Only) JUNE 30, 2002 JUNE 30, 2001 $ 754,877 94 $ 3,248,879 29 $ 2,491,086 87 600,000 00 210,124 30 711,067 29 430,745 18 1,500 00 8,927 35 1104553 4,997 60 12 300 07 $ 965 002 24 $ 3 98141946 $ 3,539,129 72 $ 1182033 $ 518,836 59 $ 428,811 86 134,920 32 132,333 04 97928 4,216 12 15,075 48 15,07548 72,710 07 120605 $ 26 895 81 $ 669 811 67 $ 639 27714 $ 8,927 35 $ 4,997 60 11,045 53 12,300 07 $ 938,106 43 938,106 43 881,684 54 000 2,353,528 48 5,402 79 1,995,467 58 $ 938 106 43 $ 331160779 $ 2,899,852 58 s 398141946 $ 3,539,12972 -3- SEMINOLE COUNTY BOARD OF EDUCATION COMBINED STATEMENT OF REVENUES. EXPENDITURES AND CHANGES IN FUND BALANCES ALL GOVERNMENTAL FUND TYPES YEAR ENDED JUNE 30. 2002 REVENUES State Funds Federal Funds Taxes Other Funds Total Revenues EXPENDITURES Current Instruction Support Services Pupil Services Improvement of Instructional Services Educabonal Media Services General Adm1mstrat1on School AdminIstratIon Business Admin1strat1on Maintenance and Operation of Plant Student Transportation SeMces Other Support SeMces Food Services Operation Capital Outlay Total Expenditures Excess of Revenues over (under) Expendrtures OTHER FINANCING SOURCES /USES} Opera11ng 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 Inventory - Net Change in Penod Donated Commodrues Purchased Food GENERAL FUND SPECIAL REVENUE FUND $ 8,432 918 20 $ 2,711,842 63 80,385 38 $ 11,225,14621 $ 352,351 11 1,820,579 39 13891786 2 31184836 $ 7,312,804 00 $ 1,162,533 56 312,127 78 356,605 76 416.402 90 249,655 84 768,832 30 155,293 70 774,403 25 512,727 63 8,750 00 4,516 92 34,060 23 116,162 24 50,96063 70000 4,416 06 11,342 95 53,342 68 878,698 03 $ 10,872,120 08 $ $ 353,026 13 $ 2,312,216 38 -368 02 $ $ -12 204 46 $ -12 204 46 $ 12,204 46 12 204 46 $ 340,821 67 $ 1,548,226 15 11,836 44 469,941 89 3,929 75 -125454 FUND BALANCE JUNE 30 $ 118891047 82 $ =~""484"'='4""53==-54--- The notes to the general-purpose financial statements are an integral part of this statement -4- EXHIBIT "B" CAPITAL PROJECTS FUND TOTALS (Memorandum Only) YEAR ENDED JUNE 30, 2002 JUNE 30, 2001 $ 31,250 00 $ 8,816,519 31 $ 8,875,450 32 1,820,579 39 1454,86403 858,199 89 3,570,042 52 3,577,132 56 28 915 37 248 218 61 291,588 27 $ 918,365 26 $ 14,455,359 83 $ 14,199,035 18 $ 8,475,337 56 $ 8,091,733 69 $ 861 943 37 346,188 01 472,768 00 416,402 90 300,616 47 768,832 30 155,993 70 778,819 31 524,070 58 62,092 68 883,214 95 86194337 366,597 51 419,756 35 415,528 76 211,989 78 862,049 90 156,487 83 761,837 57 497,744 08 58,419 22 809,212 42 1293769 74 $ 86194337 $ 14,046,279 83 $ 13,945,126 85 $ 56 421 89 $ 409 080 00 $ 253,908 33 $ 12,204 46 $ 24,176 46 -12 204 46 -24176 46 $ 000 $ 000 $ 56,421 89 $ 409,080 00 $ 253,908 33 881,684 54 2,899,852 58 2,635,612 13 3,929 75 -1 254 54 1,923 03 8 409 09 $ 938 106 43 $ 331160779 $ 2,899,852 58 -5 - SEMINOLE COUNTY BOARD OE EDUCATION COMBINED STATEMENT OF REVENUES EXPENRtTUBES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL - (NON-GAAP BASIS) GENERAL AND SPECIAL REVENUE FUNDS VEAR ENDED JUNE 30 2002 EXHIBIT "C" REVENUES State Funds Federal Funds Taxes Other Funds Total Revenues GENERAL FUND BUDGET ACTUAL s 827115400 s 8 432 918 20 2 716,551 00 56 000 00 2711,84263 80 385 38 s 11 043 705 00 s 1122514621 EXPENPIIURES Current lnstructJon Support Services PupdSeMces Improvement of lnatruc:tlO!lal SeMces Educabonal Mec:ha Services General AdllllruttratJon School Adm1niat:ratJon Bu&iness A1Jm1nistnlti0n Mamtenance and Operabon of Plant Student Transportaoon Services Other Support SeCcunuc, pledged to secure a pool ofpubhc funds shall be not less than 110 percent ofthe daily pool balance OCGA Section 45-8-11 (b) provides an officer holding publtc funds may, in his discretion, waive the reqmrement for secunty in the case of operating funds placed in demand deposit checking accounts Acceptable security for depo,1ts consists of any one of or any combination of the following (I) Surety bond signed by a surety company duly qualified and authorized to transact business wllhin the State of Georgia, (2) Insurance on accounts pro\1ded by the Federal Deposit Insurance Corporation, (3) Bonds, b1lb, notes, certificates of indebtedness or other direct obligations of the United States or of the State of Georgia, (4) Bonds, bills, notes, certificates of indebtedness or other obligaUon~ of the counties or mumc1paht1cs of the State of Georgia, (5) Bonds of any public authonty created by the laws of the State of Georgia, providing that the statute that created the authority authonzed the use of the bonds for this purpose, - II - - - --- -- - - - - - - - - - - - - - - - - - - - - - - - - - - SEMINOLE COUNTY BOARD OF EDUCATION EXHIBIT "D" NOTES TO THE GENERAL-PURPOSE FINANCIAL STA fEMENTS JUNE 30. 2002 Note 2 DEPOSITS (6) lndustnal revenue bonds and bonds of development authont1es created by the laws of the State of Georgia. and (7) Bonds. bills, notes, certificates of indebtedness. or other obligations of a subs1d1ary corporation of the United States government, which are fully guaranteed by the United States government both as to pnncipal and interest or debt obhgat10ns issued by the Federal Land Bank. the Federal Home Loan Bank. the Federal Intermediate Credit Bank. the Central Bank for Cooperauves. the Fann Credit Banks. the Federal Home Loan Mortgage Assoc1at1on. and the Federal National Mortgage Association CATEGORIZATION OF DEPOSITS At June 30, 2002. the bank balances were $3,619.180 99 The amounts ofthe total bank balances are classified into three categones of credit nsk Category I - Cash that 1s insured (e g, Federal depository insurance) or collateralized with secunlles held by the School District or by the School D1stnct's agent in the School D1stnct's name Category 2 - Cash collaterahzed with secunues held by the pledging financial institution's trust department or agent in the School District's name Category 3 - Uncollaterahzed deposits (This includes any bank balance that 1s collateralized with secunt1es held by the pledging financial inst1tut10n. or by its trust department or agent but not in the School D1stnct's name) The School D1stnct's deposits are classified by nsk category at June 30. 2002, as follow~ Risk Categorv Bank Balance I 2 3 Total $ 210,879 78 2,060.237 33 1,348.063 88 $ 3.6)9.180 99 Note 3 NON-MONETARY TRANSACTIONS The School D1stnct receives food commod111es from the United States Department of Agnculture (USDA) for ~chool breakfast and lunch programs lbcse commodities are recorded at their Federally assigned value See Note 1 - Inventories - 12 - SEMINOLE COUNTY BOARD OF EDUCAl ION EXHIBI r "D" NOTES TO THE GENERAL-PURPOSE FINANCIAL STATEMENTS JUNE 30, 2002 Note 4 RISK MANAGEMENT The School D1stnct 1s exposed to vanous nsks of loss related to torts; theft of, damage to, and destruct10n of assets. errors or om1ss10ns, job related illness or inJunes to employees, acts of God and unemployment compensat10n The School District has obtained commercial insurance for n~k ofloss associated with tons, assets, errors or om1ss10ns and Job related illness or inJunes to employees However. the errors or om1ss10ns pohcy excludes coverage for sexual harassment and d1scnminauon The School D1stnct has neither s1gmficantly reduced coverage for these risks nor incurred losses (settlements) which exceeded the School D1stnct's insurance coverage in any of the past three years The School D1stnct ha~ elected to self-insure for all losses related to acts of God The School D1stnct has not ell.penenced any losses related to this nsk in the past three years The School D1stnct 1s self-insured \'.11th regard to unemployment compensat10n claims The School D1stnct accounts for claims within the General Fund with expenditure and hab1hty being reported when 1t 1s probable that a loss ha~ occurred. and the amount of that loss can be reasonably estimated Changes in the unemployment compensat10n claims hab1hty dunng the last two fiscal years are as follows 2001 2002 Begmnmg of Year L1ab1hty Claims and Changes m l:st1mates Claims Paid End of Year L1ab1htv $ 0 00 $ 4 058 00 $ 4 058 00 $ 0 00 $ 0 00 $ 4 893 23 $ 4 893 23 $ 0 00 The School D1stnct has purchased surety bonds to provide additional in~urance coverage as follows Po~1tion Covered Amount Supenntendent Each Principal financial Director Each Lunchroom Supervisor $ l 00,000 00 $ 5,000 00 $ 5.000 00 $ 5.000 00 Note 5 OPERATING LEASES Seminole County Board of Education has entered mto various leases as lessee for copy machme~ These leases arc considered for accountmg purposes to be operatmg le~cs Lease expenditures for the year ended June 30. 2002. amounted to $13.145 14 Future mm1mum lease payments for these leases are as follows - 13 - SEMINOLE COUNTI' BOARD OF EDUCATION EX! IIBIT "D" NOTES TO THE GENERAL-PURPOSE FINANCIAL STA fEMENTS JUNE 30, 2002 Note 5 OPERATING LEASES Year Endmg Amount 2003 2004 2005 2006 2007 $ 52.580 52 52.580 52 43.350 08 15,658 80 11 744 I 0 Total Note 6 ON-BEHALF PAYMENTS $ 175,914,02 The School D1stnct has recognized revenues and expenditures m the amount of$ 133,699 81 for health msurance and retirement contnbut10ns paid on the School D1stnct's behalf by the follov.10g State Agencies Georgia Department of Education Paid to the Georgia Department of Community Health For Health Insurance of Non-Certified Personnel In the amount of$ 117.687 81 Office of Treasury and Fiscal Services Paid to the Public School Employees Retuement System For Public School Employees Retirement (PSERS) Employer's Cost In the amount of$16.012.00 Note 7. CONTINGENT LIABILITIES Amounts received or receivable pnnc1pally from the Federal government are subJect to audit and review by grantor agencies This could result m requests for reimbursement to the grantor agency for any expenditures which arc disallowed under grant terms. The School D1stnct believes that such d1sallowances, 1f any. will be 1mmatenal to its overall financial pos1t10n The School D1stnct is a defendant m various legal proceedings pertairung to matters mc1dental to the performance ofroutme School D1stnct operation~. The ultimate disposition of these proceedings 1s not presently determinable, but 1s not believed to be material to the general-purpose financial ,tatements - 14 - SEMINOLE COUN rY BOARD OF EDUCATION EXHIBIT "D" NOT[S TO THE G[NERAL-PURPOSE rINANCIAL STATEMENTS JUNE 30, 2002 Note 8 RETIREMENT PLANS TEACHERS RETIREMENT SYSTEM OF GEORGIA (TRS) TRS PLAN DESCRIPTION Substanllally all teachers. adm1mstra11ve and clencal per.,onnel employed by local school d1stncts are covered by the Teachers Reurement System of Georgia (TRS), which 1s a cost-shanng muluple employer defined benefit pension plan TRS provides service rellrement. d1sabihty rellrement and survivors benefits for its members in accordance with State statute The Teachers Retirement System of Georgia issue, a .cparate stand alone financial audit report and a copy can be obtained from the Georgia Department of Audits and Accounts TRS CON fRIBUTIONS REQUIRED AND MADE l:.mployees of the School D1stnct who arc covered by TRS are required by State ,tatute to contribute 5% of their gross earnings to TRS The School D1stnct makes monthly employer contnbullons to TRS at rates adopted by the TRS Board of Trustees in accordance with State statute and as adv1.ed by their independent actuary The required employer contribut10n rate 1s 9 24% and employer contnbullons for the current fi'>Cal year and the preceding two fiscal years are as follows Fiscal Year Percentage Contnbuted Required Contnbut10n 2002 2001 :woo I00% 100% JOO% $ 687.148 78 $ 820.652 83 $ 757,945 96 - 15 - SEMINOLE COUNTY BOARD OF EDUCATION COMBINING BALANCE SHEET SPECIAL REVENUE FUND JUNE 30 2002 ASSETS Cash and Cash Equivalents Accounts Receivable Prepaid Items lnventones Food Donated Commodmes Purchased Food SCHOOL FOOD SERVICES FUND LOTTER' PRQGRA,.]_ $ 471,993 61 $ 41,578 51 4,29062 5,377 00 8,927 35 1104553 Total Assets $ 496 257 11 $ ~--46..,..9.,.55..,5=1= LIABILITIES AND FUND EQUITY LIABILITIES Cash Overdraft Accounts Payable Salanes Payable Expired Grant Balances Payable Deferred Revenue Total Liab1lrt1es FUND EQUITY Fund Balances Reserved For lnventones Food Donated Commod1t1es Purchased Food Unreserved Undes,gnated Total Fund Equity $ 11,80357 $ 19,226 43 27,729 08 $ 11 803 57 $ 46 955 51 $ 8,927 35 11,045 53 464 480 66 $ 000 $ 484453 54 $ 000 Total Liab1lrt1es and Fund Equity See notes to the general-purpose financial statements - 16 - $ 496 257 11 $ ---46=9.;5,_5.;5.1.. EXHIBIT "E" FEDERAL PROGRAMS TOTALS JUNE 30, 2002 JUNE 30, 2001 $ 513,572 12 $ 570,898 03 $ 363,768 29 373,435 91 114,847 91 1,500 00 1,500 00 8,927 35 1104553 4,997 60 12 300 07 $ 908 480 91 $ _ __,7.0.3.e04=3=6;.,;1_ $ 95,924 10 $ 95,924 10 165,377 27 196.407 27 $ 95,346 51 102,987 64 130,716 72 132,333 04 97928 97928 4,216 12 1 206 05 $ 365,268 29 $ 424 027 37 $ 233 101 72 $ $ _ _ _ _..:0'-'00=- $ 000 $ 8,927 35 $ 11,045 53 4,997 60 12,300 07 464 480 66 452,644 22 484 453 54 $ _ _46~9~94~1~8=9~ $ 365,268 29 $ 908 480 91 $ -==7=0=3._0.4.3..6_1_ - 17 - SEMINOLE COUNTY BOARD OF EDUCATION COMBINING STATEMENT OF REVENUES. EXPENDITURES AND CHANGES IN FUND BALANCES SPECIAL REVENUE FUND YEAR ENDED JUNE 30, 2002 REVENUES State Funds Federal Funds Other Funds Total Revenues EXPENDITURES Current lnstrucbon Support Services Pupil Services Improvement of Instructional Services General Admin1strat1on Business Admin1strat1on Maintenance and Operation of Plant Student Transportat,on Services Other Support Services Food Services Operabon Total Expendrtures Excess of Revenues over (under) Expenditures OTHER FINANCING SOURCES Operating Transfers In Excess of Revenues and Other Financing Sources over (under) Expendrtures FUND BALANCE JULY 1 Food lnven1ory - Net Change In Penod Donated Commod1t1es Purchased Food FUND BALANCE JUNE 30 SCHOOL FOOD SERVICES FUND LOTTERY PROGRAMS $ 55,636 00 $ 296,71511 727,144 04 106 977 99 $ 889,758 03 $ 29671511 $ 262,651 59 34.060 23 22594 6.851 98 582 66 $ 877,921 59 $ 877 921 59 $ 304 372 40 $ 11,836 44 $ -7,657 29 $ 11,836 44 $ 469.941 89 3,929 75 -1 254 54 7 657 29 000 o oo $ 484 453 54 s~=~-o_o_o_ See notes to the general-purpose financial statements - 18 - EXHIBIT"F" FEDERAL PROGRAMS TOTALS YEAR ENDED JUNE 30, 2002 JUNE 30, 2001 $ 352,351 11 $ 369,793 94 $ 1,093,435 35 1,820,579 39 1,454,864 03 31 939 87 138 917 86 102 593 79 $ 1, 125,375 22 $ 2,311,848 36 $ 1 927 251 76 $ 899,881 97 $ 1,162,533 56 $ 1,021,076 31 115,936 30 44,108 65 70000 3,833 40 11,34295 53,342 68 77644 34,060 23 116,162 24 50,96063 70000 4,416 06 11,34295 53,342 68 878,698 03 53,838 75 24,010 98 16,681 96 1,639 90 5,099 49 49,669 22 805 154 42 $ 112992239 $ 2,312,216 38 $ 1 977 171 03 $ -4,547 17 $ -368 02 $ -49,919 27 4 547 17 12 204 46 24 022 46 $ 000 $ 11,83644 $ -25,896 81 000 469,941 89 485,506 58 3,929 75 -1 254 54 1,923 03 8 409 09 $ 000 $ 484 453 54 $ _ _ _46;,;9;,;94a.;,;1.;;8;,;:9~ - 19 - SEMINOLE COUNTY BOARD OF EDUCATION COMBINING BALANCE SHEET CAPITAL PROJECTS FUND JUNE 30 2002 EXHIBIT "G" ASSlli Gash and Cash Equrvalents Accounts Re~vab'e Total Assets GEORGIA STATE FINANCING AND INVESTMENT COMMISSION SPECIAL PURPOSE LOCAL OPTION SALES TAX TOTALS JUNE 30 2002 JUNE 30, 2001 s s s s 0 00 754,877 94 754 877 94 784 959 25 210,124 30 210 124 30 194 335 57 s 000 S 965 002 24 $ 979.294 82 LIABILITIES AND FUND EQUITY LIABILITIES Accounts Payable Contracts Payable Total Llab11rtles FUND EQUITY Fund Balances Reserved For SPLOST PrOJedS Unreserved Undesignated s T01al Fund Equity s Total L1ablhtles end Fund Equity s s 11,82033 s 11,820 33 $ 24 900 21 15 075 48 15 075 48 72 710 07 s s 26 895 81 s 26 895 81 97 610 28 s 000 000 s 938 106 43 $ 000 938 106 43 s 938,106 43 $ 0 00 938 106 43 $ 881,684 54 000 881 684 54 000 S 965,002 24 $ 979 294 82 See notes to the genera~ finanC&al statements -20 - SEMINOLE COUNTY BOARD OF EDUCATION COMBINING STATEMENT OF REVENUES EXPENDITURES AND CHANGES IN FUND BALANCES CAP[TAL PROJECTS FUND YEAR ENPEP JUNE 30 2002 EXHIBIT i; REVENUES State Funds Taxes Other Funds Total Revenues EXPENDITURES Capn Cluster Other Programs Pass-Through From Chattahoochee - Fltnt Regional Educational Sefw::e Agency d/b/a Two Rrvers Migrant Education Agency Elementary end Secondary Education Ad THle I Migrant Education Pass-Through From Georgia Department of Educabon Elementary aoo secondary Educat,on Act Trtlel Accountab11rty Grants Grants to Local Educational Agencies Title II Eisenhower Profess10nal Development Tltle VI lnnovatrve Educat10n Progrem Strategies Class Size Reduction VocabonalEducalion Basrc Grants to States High School Program Basic Grant Total u s Department of Education CFDA NUMBER PASSTHROUGH ENTITY ID NUMBER FEDERAL REVENUE IN PERIOD EXPENDITURES IN PERIOD 10 553 10 555 N/A s 22.7 962 75 N/A <463 906 44 s s s 691 869 19 (2) 842 6<46 74 (3) 842 6<46 74 10 550 NIA 35 274 85 s $ 727 144 04 35 274 85 877 921 59 84 027 84 173 84 027 NIA s $ 201,900 65 NIA 16 586 00 N/A 3 094 00 s s 221 560 65 201 900 65 18,782 65 (3) 3 094 00 223,777 30 84 011 NIA 52 874 32 52 874 32 84 348 84 010 64 281 84 298 84 340 84048 NIA 9814100 98 532 75 (3) NIA 570 181 97 570 181 97 NIA 11,00554 1101607 (3) NIA 1559487 15 594 87 NIA 87,064 00 87,210 50 (3) NIA 37 013 00 38 794 74 (3) s s 1,093,435 35 1 097 982 52 Total Federal Fmanaal AsSJ&tance NIA a Not Available s s ___ 1 520 519 39 1_9_7_5._9_0_4 _1~1 11 - 22 - SEMINOLE COUNTY BOARD OF EDUCATION SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS YEAR ENDED JUNE 30 2002 SCHEDULE "1" Notes to the Schedule of Exoendttures of Federal Awards (1) The amounts shown for the Food O1:stnbu0on Program represents the Federally assigned value of nonmonetary asslstence for donated commodlbes rece!Ved and/or consumed by the system dunng the ament fiscal year (2) Expenchtures for the Sdlool Breakfast Program were not maintained separately and ere 1ncJuded In the 2002 Natlonal SChool Lunch Program (3) Expenditures for this program lndode State, and/or Other Funds Expenditures are not mamtatned by fund source Major Programs are u:ientlfiecl by an asterisk(*) a, front of the CFDA number The School Distnd did not provide Federal Assistance to any Subreciplent The eccompanymg achedule of expenditures of Federal awards mciudes the Federal grant activrty of the Semanole County Board of EducallOn and ts presented on the modified accrual basis of account.mg wtuch ts the basis of accounting used 1n the preSentabon of the general-purpose financlel statement! See notes to the general-purpose financial statements -23 - SEMINOLE COUNTY BOARD OF EDUCATION SCHEDULE OF STATE REVENUE YEAR ENPEP JUNE 30 2002 SCHEDULE "2'' AGENCY/FUNDING GRANTS Community Affe,ra Goorgia Department of Governor's Emergency Foods local Asslstanc:e Grants Educauon Georg,a Department of Oualrty Ba5IC Educabon Direct lnstructJonal Coat Klnoo,varten Program Kindergarten Program - Ear1y Intervention Program Pnmary Grades (1-3) Program Pnmary Grades - Early lntervenoon (1-3) Program Upper Elementary Grades (4-5) Program Upper Elementary Gradel (4-5) Early lntervenbon Program Moddle Grades (6~) Program High School GenereI EducatlOO (9- 12) Program Vocabonal Lelxlretory (9-12) Program Students With Dlsablllt185 Category II Category Ill Ca1agory IV CalegoryV Gifted Student - Category VI Remechel EducabOn Program Altematrve Educebon Program Media Center Program TVl'eflty Days Add1bonal lnstrucborl Staff end Professional Development lnchrect Cost Categoncal Grants Pupd Transportabon Regular Bus Replacement Sparsrty Nu~ng Services Pnncipal Supplements VocatKmel SupeMSOrs Mid-term AdJUStment Hold-Harmlesa EducahOn Equaliza!IOO Funding Grant Food Services VocahorlelEducebon Other State Programs Health Insurance K-3 Stat9Wlde Reading Program -4-8 StateWlde After School Reading Program Preschool Handicapped Program Speaal Educabon Low lnadence Grant lottery Programs Assasltve Technology Computers 1n the Classroom Office o1 School Readiness Pre-Kindergarten Program Office of Treasury encl Fiscal Services Public School Employees Retirement CONTRACT Ba,nbndge College Student Tutor Program GOVERNMENTAL FUND TYPES SPECIAL CAPITAL GENERAL REVENUE PROJECTS FUND FUND FUND TOTAL S 2000000 S 1125000 20 000 00 1125000 s 352 183 00 151 347 00 1 058,571 00 182 037 00 586,223 00 79 689 00 987,029 00 813 175 00 334 098 00 176,607 00 254 814 00 80 009 00 13,118 00 43,447 00 65 122 00 83 142 00 170 927 00 55 199 00 27 899 00 1 099 353 00 33211900 92 9-47 00 20 000 00 50 753 00 6,667 00 12 017 00 412 540 00 593 300 00 s 109 043 53 55 636 00 11768781 23 672 25 13 457 44 17 899 00 18 265 00 5 342 00 45 600 00 2-45 773 11 16 012 00 2 568 17 352 183 00 151 347 00 1 058 571 00 182 037 00 566 223 00 79 669 00 987 029 00 813 175 00 334 099 00 176,607 00 254 81,400 80 009 00 1311800 43 447 00 65 122 00 83 142 00 170 927 00 55 199 00 27 899 00 1 099 353 00 33211900 92 947 00 20 000 00 SO 753 00 6 667 00 1201700 412 540 00 593 300 00 55 636 00 109 043 53 11768781 23 672 25 13 457 44 17 899 00 18 265 00 5 342 00 45 600 00 2-45 77311 16 012 00 2 568 17 S 843291820 S 35235111 S 3125000 S 881651931 See notes to the general-purpose finenael statements SEMINOLE COUNTY BOARD OF EDUCATION SCHEDULE OF APPROVED LOCAL QPTION SALES TAX PROJECTS YEAR ENDED JUNE 30, 2002 SCHEDULE "3" PROJECT Reroofing remodehng and renovatmg eXJstmg classrooms ITTSlructmnal and support space at the elementary school and aud1tor1um the Malcolm gymnasium and the existing football stadium renovation pavang, fencing and other development of parking areas bus loading zones anci grounds at the elementary and mldd.lelhigh school, demolrtlon of old pnmary school buildings purdlase school buses copy machines computer equipment, hght.1119 surve~lance eqU1pment, desks tables lockers and other necessary furniture eQUlpment and personal property and to construct new dassrooms mstrudronal and support space ORIGINAL ESTIMATED COST (1) CURRENT ESTIMATED COSTS (2) AMOUNT EXPENDED IN CURRENT YEAR (3) AMOUNT EXPENDED IN PRIOR YEARS(3) PROJECT STATUS s s s 312001000 00 3 200,000 00 861 943 37 S 119521966 42 Ongoing ( 1} The SChool Drstnct's ongtnal cost estmate es speariect 111 the resotutmn calhng for the lmpos1bon of the Local Optmn Sales Tax (2) The School District's current estimate of total cost for the proJE!d Includes all cost from pro,ect rncept10n to complebon (3) The voters of Sem1note County approved the Imposruon of a 1% sales tax to fund the above pro!ed Amounts expended for this protect may include saleS tax proceeds, state local property taxes and/or other funds over the life of the proJect see notes to the general-purpose financial statements 25 - SEMINOLE COUNTY BOARD OF EDUCATION GENERAL FUND QUALITY BASIC EDUCATION PROGRAM W Su11c 211 Atl.rntJ, Gcorg:1.1 J01J4-8400 June 17. 2003 Honorable Sonny Perdue. Governor Members of the General Assembly Members of the State Board of }'_,ducatwn and Superintendent and Members of the Seminole County Board of Education REPORT ON COMPLIANCE AND ON INTERNAL CONTROL OVER f!NANCIAL REPORIT\G BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDll ING STANDARDS Ladies and Gentlemen We have audited the financial statements of Seminole County Board ofEducatwn ru, of and for the )ear ended June 30. 2002. and have issued our report thereon dated June 17. 2003 This report wa~ qualified for var1otL~ departures from generally accepted accounting principles. as identified in the audllor's report on the geneml-purpose financial statements We conducted our audit in accordance wnh aud!ling standards genemlly accepted in the Umted State~ of America and the standards applicable to financial audits contained m Government Aud1tmg Standards. issued by the Comptroller General of the Umted States Compliance As part of obtammg reasonable a~surance about whether Seminole County Board of Educatwn~ financial statements are free of material misstatement. we performed tests of its compliance with certain prov1~1ons oflaw~. regulations. contracts and gmnts. noncompliance wuh whlch could have a direct and material effect on the determinatwn of financial statement amounts However. providing an op1mon on compliance "with those prov1s10ns was not an obJecuve of our audit. and accordingly. we do not expres~ such an opinwn The results ofour tests disclosed no instances ofnoncompliance that are required to be reported under Government Auditing Standards Internal Control Over financial Reportin11, In planning and perforimng our audll. we considered Seminole County Board ofEducauon'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 2002YB-41 control over financial reportmg However, we noted a ccrtam matter involving the internal control over financial reporting and 11> operat10n that we consider to be a reportable cond1tJon Reportable conditions involve matters commg to our anent1on relating to significant delic1enc1es in the design or operat10n of the internal control over financial reportmg that, in ourJudgment, could adversely affect Seminole County Board of Education's ab1hty to record, process, summanze and report financial data consistent with assertions of management in the financial statement, The reportable condit10n 1s described in the accompanying Schedule of Findings and Qucst10ned Costs as item FS-7251-02-01 A material weakness 1s 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 aud11ed may occur and not be detected wtthm a timely penod by employees m the normal course of performing their assigned functions Our cons1dera11on of the 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 cond1t10ns that are also considered to be material weaknesses However, we consider item FS-7251-02-0 I to be a material weakness This report 1s intended solely for the informat10n and use of the management. members of the Seminole County Board of Education, Federal awarding agencies and pass-through entJties and 1s not intended to be and should not be used by anyone other than these specified parties ~~espectfully ~ubmllted, ~--~~ -2~ Hmton Sta e Auditor RWHgp 2002YB-41 {1 ,,,H.L W. IIIN ION c; JATI:: AUOITQA (404) 656 21N DEPARTMENT OF AUDITS AND ACCOUNTS 254 \VJ...,hmgton \trcc-t, SW SuitL' 214 Atl,.mtJ, C,Lorg1J 30314-84()(1 June 17, 2003 Honorable Sonn) Perdue. Governor Members ol the General As~embly Members ol the State Board of Educatwn and Supenntendcnt and Members of the Seminole County Board of Educatwn REPORT ON COMPLIANCE WITH REQUIREMENTS APPLICABLE TO l,.ACH MAJOR PROGRAM AND ON INTf-.RNAL CONTROL OVER COMPLIANCE IN ACCORDANCE WIT! I 0MB CIRCULAR A-133 Lad1e~ and Gentlemen Compliance We have audited the compliance of Seminole County Board of Educatwn with the types of compliance rcquiremenL, described in the VS Office