ry at June 30, 1999, as follows: Risk Category Bank Balance 1 $ 200,000.00 2 970,394.00 3 173,541.32 Total Note 3: NON-MONETARY TRANSACTIONS $ 1.343.935.32 The Board receives food commodities from the United States Department ofAgriculture (USDA) for school breakfast and lunch programs. These commodities are recorded at their Federally assigned value. See Note 1 - Inventories Note 4: RISK MANAGEMENT The Board is exposed to various risks of loss related to torts; theft of, damage to, and destruction of assets; errors or omissions; job related illness or injuries to employees; natural disaster and unemployment compensation. The Board has obtained commercial insurance for risk ofloss associated with torts, assets, andjob related illness or injuries to employees. The Board has neither significantly reduced coverage for these risks nor incurred losses (settlements) which exceeded the Board's insurance coverage in any ofthe past three years. The Board has elected to self-insure for all losses related to natural disaster except for flooding for which the Board has purchased commercial insurance. The Board has not experienced any losses related to this risk in the past three years. The Board has elected to self-insure for errors or omissions, which includes, among other risks, risks for sexual harassment and discrimination. The Board has not experienced any losses related to these risks in the past three years. - 12- LANIER COUNTY BOARD OF EDUCATION EXHIBIT "D" NOTES TO THE GENERAL PURPOSE FINANCIAL STATEMENTS JUNE 30. 1999 Note 4: RISK MANAGEMENT The Board is self-insured with regard to unemployment compensation claims. The Board accounts for claims within the same fund that the employee's salary and benefits were paid. Claims are accounted for with expenditure and liability being reported when it is probable that a loss has occurred, and the amount of that loss can be reasonably estimated. Changes in the unemployment compensation claims liability during the last two fiscal years are as follows: 1998 1999 Beginning ofYear Liability Claims and Changes in Estimates $ 0.00 $ 64~ 1Q0 $ $ Q,Q0 $ Q,QQ $ Claims Paid EndofYear Liability 64~.oo $ 0.00 Q.QQ $ Q.Q0 The Board has purchased surety bonds to provide additional insurance coverage as follows: Position Covered Amount Superintendent Each Principal Each Bookkeeper Each Nutrition Manager Each Nutrition Cashier $ 25,000.00 $ 5,000.00 $ 4,000.00 $ 3,000.00 $ 2,000.00 Note 5: GENERAL LONG-TERM DEBT CAPITAL LEASES The Lanier County Board ofEducation has entered into various lease agreements as lessee for digital phone systems, copy machines and an energy management system. These lease agreements qualify as capital leases for accounting purposes and, therefore, have been recorded at the present value ofthe future minimum lease payments as ofthe date oftheir inception. The changes in General Long-Term Debt during the fiscal year ended June 30, 1999, were as follows: Balance July 1, 1998 Deductions Payments Balance June 30, 1999 Capital Leases $ 366,882.66 81,594.89 $ 2851287.ZZ - 13 - LANIER COUNTY BOARD OF EDUCATION EXHIBIT "D" NOTES TO THE GENERAL PURPOSE FINANCIAL STATEMENTS JUNE 30, 1999 Note 5: GENERAL LONG-TERM DEBT At June 30, 1999, payments due by fiscal year which includes principal and interest for these items are as follows: Fiscal Year Ended June 30 Capital Leases 2000 2001 2002 2003 2004 $ 102,533.27 82,407.10 57,008.88 57,008.88 23,753.70 Total Principal and Interest $ 322,711.83 Deduct: Imputed Interest 37,424.06 Net Present Value ofFuture Minimum Lease Payments $ 285.287.77 Note 6: LOANS PAYABLE At June 30, 1999, short-term debt (temporary loans) amounted to $520,150.00 with interest accruing at 4.25 percent. The aggregate amount of temporary loans is limited to 75 percent of the total gross income from taxes collected in the preceding year and all temporary loans must be repaid no later than December 31 ofthe calender year in which the loan was made. Note 7: ON-BEHALF PAYMENTS The Board has recognized revenues and expenditures in the amount of$117,944.52 for health insurance and retirement contributions paid on the Board's behalfby the following State Agencies. Georgia Department ofEducation Paid to the State Merit System of Personnel Administration For Health Insurance ofNon-Certified Personnel In the amount of$91,371.98 Paid to the Teachers Retirement System of Georgia For Teachers Retirement System (TRS) Employer's Cost In the amount of$9,022.54 - 14- LANIER COUNTY BOARD OF EDUCATION EXHIBIT "D" NOTES TO THE GENERAL PURPOSE FINANCIAL STATEMENTS JUNE 30. 1999 Note 7: ON-BEHALF PAYMENTS Office of Treasury and Fiscal Services Paid to the Public School Employees Retirement System For Public School Employees Retirement (PSERS) Employer's Cost In the amount of $17,550.00 Note 8: CONTINGENT LIABILITIES Amounts received or receivable principally from the Federal government are subject to audit and review by grantor agencies. This could result in requests for reimbursement to the grantor agency for any expenditures which are disallowed under grant terms. The Board believes that such disallowances, if any, will be immaterial to its overall financial position. Note 9: RETIREMENT PLANS TEACHERS RETIREMENT SYSTEM OF GEORGIA (TRS) TRS PLAN DESCRIPTION Substantially all teachers, administrative and clerical personnel employed by local school systems are covered by the Teachers Retirement System of Georgia (TRS), which is a cost-sharing multiple employer defined benefit pension plan. TRS provides service retirement, disability retirement and survivors benefits for its members in accordance with State statute. The Teachers Retirement System of Georgia issues a separate stand alone financial audit report and a copy can be obtained from the Georgia Department of Audits and Accounts. TRS CONTRIBUTIONS REQUIRED AND MADE Employees ofthe Board who are covered by TRS are required by State statute to contribute 5% oftheir gross earnings to TRS. The Board makes monthly employer contributions to TRS at rates adopted by the TRS Board of Trustees in accordance with State statute and as advised by their independent actuary. The required employer contribution rate is 11.95% and employer contributions for the current fiscal year and the preceding two fiscal years are as follows: Fiscal Year Percentage Contributed Required Contribution 1999 1998 1997 100% 100% 100% $ 580,836.06 $ 538,794.78 $ 487,931.47 - 15 - LANIER COUNTY BOARD OF EDUCATION COMBINING BALANCE SHEET SPECIAL REVENUE FUND JUNE 30, 1999 ASSETS Cash and Cash Equivalents Accounts Receivable Inventories Food Donated Commodities Purchased Food SCHOOL FOOD SERVICES FUND LOTTERY PROGRAMS $ 141,444.21 $ 61,485.85 39,124.46 4,282.43 1,065.86 Total Assets LIABILITIES AND FUND EQUITY LIABILITIES Cash Overdraft Accounts Payable Salaries Payable Expired Grant Balances Payable Total Liabilities FUND EQUITY Fund Balances Reserved For Continuation of Federal Programs For Continuation of State Programs For Inventories Food Donated Commodities Purchased Food Unreserved Deficit Undesignated Total Fund Equity Total Liabilities and Fund Equity See notes to the general purpose financial statements. -16- $ 185,916.96 $ ====6=1=,4=8=5=.8=5= $ 2,483.09 $ 17,178.39 34,048.84 44,307.46 $ 36,531.93 $ 61,485.85 $ 4,282.43 1,065.86 144,036.74 $ 0.00 $ 149,385.03 $ 0.00 __ _____....,. $ 185,916.96 $ 61,485.85 . EXHIBIT"E" FEDERAL PROGRAMS OTHER PROGRAMS TOTALS JUNE 30, 1999 JUNE 30, 1998 $ 20,508.93 $ 223,438.99 $ 323,179.55 $ 138,497.77 177,622.23 132,974.47 4,282.43 1,065.86 7,037.59 1,058.12 $ 138,497.77 $ 20,508.93 $ 406,409.51 $ 464,249.73 $ 60,501.88 19,885.65 $ 44,794.11 1,637.83 $ 126,819.47 $ $ 270.86 468.75 390.49 1,130.10 $ 60,501.88 $ 39,817.99 123,619.16 2,028.32 225,967.35 $ 47,903.50 77,851.69 117,807.56 6,437.14 249,999.89 $ 11,678.30 $ 11,678.30 $ 4,946.72 25,000.00 4,282.43 1,065.86 1,058.12 7,037.59 0.00 $ 19,378.83 163,415.57 -10,621.17 186,828.58 $ 11,678.30 $ 19,378.83 $ 180,442.16 $ 214,249.84 $ 138,497.77 $ 20,508.93 $ 406,409.51 $ 464,249.73 -17 - LANIER COUNTY BOARD OF EDUCATION COMBINING STATEMENT OF REVENUES. EXPENDITURES AND CHANGES IN FUND BALANCES SPECIAL REVENUE FUND YEAR ENDED JUNE 30, 1999 REVENUES State Funds Federal Funds Other Funds Total Revenues EXPENDITURES Current Instruction Support Services Pupil Services Improvement of Instructional Services Educational Media Services General Administration Maintenance and Operation of Plant Student Transportation Services Other Support Services Food Services Operation Capital Outlay Total Expenditures Excess of Revenues over (under) Expenditures OTHER FINANCING SOURCES Operating Transfers In Excess of Revenues and Other Financing Sources over (under) Expenditures FUND BALANCE JULY 1 Food Inventory - Net Change in Period Donated Commodities Purchased Food FUND BALANCE JUNE 30 See notes to the general purpose financial statements. -18 - SCHOOL FOOD SERVICES FUND LOTTERY PROGRAMS $ 42,178.00 $ 378,582.07 388,677.64 170,314.71 $ 601,170.35 $ 378,582.07 $ 340,478.73 49,773.61 3,187.84 $ 643,962.19 12,271.08 1,906.58 3,680.87 $ 643,962.19 $ 411,298.71 $ -42,791.84 $ -32,716.64 32,716.64 $ -42,791.84 $ 194,924.29 0.00 0.00 -2,755.16 7.74 $ 149,385.03 $ ============0=.=0=0== EXHIBIT"F" FEDERAL PROGRAMS OTHER PROGRAMS TOTALS YEAR ENDED JUNE 30, 1999 JUNE 30, 1998 $ $ 560,001.30 _ _ _ _ _ $ _ _3_o_,o__oo_.o_o_ 420,760.07 $ 948,678.94 200,314.71 531,981.83 899,807.26 222,305.18 $ 560,001.30 $ 30,000.00 $ 1,569,753.72 $ 1,654,094.27 $ 316,670.23 31,293.45 $ 74,252.94 10,943.05 68,509.12 6,313.09 74,774.99 $ 582,756.87 $ $ -22,755.57 $ $ 657,148.96 $ 695,788.43 25,000.00 106,067.06 77,440.78 10,943.05 68,509.12 12,271.08 8,219.67 74,774.99 647,643.06 173,424.00 33,100.13 5,233.90 67,106.25 15,240.57 4,227.30 70,253.53 612,412.62 3,379.10 25,000.00 $ 1,663,017.77 $ 1,680,165.83 5,000.00 $ -93,264.05 $ -26,071.56 29,487.15 62,203.79 28,041.78 $ 6,731.58 $ 5,000.00 $ -31,060.26 $ 1,970.22 4,946.72 14,378.83 214,249.84 219,465.97 -2,755.16 7.74 -6,476.89 -709.46 $ 11,678.30 $ 19,378.83 $ 180,442.16 $ 214,249.84 -19- LANIER COUNTY BOARD OF EDUCATION COMBINING BALANCE SHEET CAPITAL PROJECTS FUND JUNE 30, 1999 ASSETS Cash and Cash Equivalents Accounts Receivable REGULAR GEORGIA STATE FINANCING AND INVESTMENT COMMISSION $ 25,582.85 $ 19,973.00 Total Assets FUND EQUITY Fund Balances Reserved For State Capital Outlay Projects For SPLOST Projects Unreserved Undesignated $ 25,582.85 $ ====1=9=,97=3.=00= $ $ _ _...:2:.=5.z.::,5;.::;82==.;:,;85:::.... 19,973.00 Total Fund Equity $ 25,582.85 $ ===1=9=,9=7=3=00= See notes to the general purpose financial statements. -20- EXHIBIT "G" SPECIAL PURPOSE LOCAL OPTION SALES TAX $ 21,095.60 $ 46,047.02 LOTTERY PROJECT TOTALS JUNE 30, 1999 JUNE 30, 1998 17,964.00 $ 84,615.45 $ 582.85 46,047.02 25,000.00 $ 67,142.62 $ 17,964.00 $ 130,662.47 $ ===2=5=,5=82==85= $ 17,964.00 $ 37,937.00 $ 67,142.62 67,142.62 25,582.85 $ _ _ _2_5_,5__82_._85_ $ 67,142.62 $ 17,964.00 $ 130,662.47 $ ===2=5=,5=82==85= - 21 - LANIER COUNTY BOARD OF EDUCATION COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES CAPITAL PROJECTS FUND YEAR ENDED JUNE 30, 1999 REVENUES State Funds Taxes Other Funds Total Revenues EXPENDITURES Capital Outlay Building and Building Improvements Excess of Revenues over (under) Expenditures OTHER FINANCING SOURCES Operating Transfers In Excess of Revenues and Other Financing Sources over (under) Expenditures FUND BALANCE JULY 1 REGULAR GEORGIA STATE FINANCING AND INVESTMENT COMMISSION $ 0.00 $ 0.00 $ 0.00 $ 0.00 0.00 0.00 $ 0.00 $ 0.00 $ 0.00 $ 25,582.85 19,973.00 19,973.00 0.00 FUND BALANCE JUNE 30 $ 25,582.85 $ =====19=,9=7=3.=00= See notes to the general purpose financial statements. -22- EXHIBIT "H" SPECIAL PURPOSE LOCAL OPTION SALES TAX LOTTERY PROJECT TOTALS YEAR ENDED JUNE 30, 1999 JUNE 30, 1998 $ 67,142.62 $ _ _ _ _ _ _ $ _ _ _ _.;..o._oo_ $ 67,142.62 $ 0.00 $ $ 67,142.62 67,142.62 $ 25,000.00 10,000.00 35,000.00 0.00 $ 67,142.62 $ 0.00 0.00 $ 0.00 67,142.62 $ 18,500.00 16,500.00 17,964.00 37,937.00 $ 67,142.62 $ 17,964.00 $ 105,079.62 $ 16,500.00 0.00 0.00 25,582.85 9,082.85 $ 67,142.62 $ 17,964.00 $ 130,662.47 $ ======2=5=,5=82==85= -23- LANIER COUNTY BOARD OF EDUCATION SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS YEAR ENDED JUNE 30. 1999 SCHEDULE "1" FUNDING AGENCY PROGRAM/GRANT Agriculture, U. S. Department of Child Nutrition Cluster Pass-Through From Georgia Department of Education Food and Nutrition Program Food Services School Breakfast Program 1999 Grant National School Lunch Program 1999 Grant Total Child Nutrition Cluster Other Programs Pass-Through From Georgia Department of Education Food and Nutrition Program Food Distribution Program (1) Total U.S. Department of Agriculture Education,U.S.Departmentof Special Education Cluster Pass-Through From Georgia Department of Education Individuals with Disabilities Education Act Part B - Special Education Flow Through 1999 Grant Preschool 1999 Grant Total Special Education Cluster Other Programs Direct Impact Aid 1999 Grant Pass-Through From Berrien County Board of Education d/bla Southern Pine Migrant Education Agency Elementary and Secondary Education Act Title I Migrant Education 1998 Regular 1999 Regular Pass-Through From Georgia Department of Education Safe and Drug-Free Schools 1999 Grant Elementary and Secondary Education Act Title I Grants to Local Educational Agencies 1999 Grant Title II Eisenhower Professional Development 1998 Grant 1999 Grant Title VI Innovative Education Program Strategies 1999 Grant CFDA NUMBER . 10.553 . 10.555 10.550 84.027 84.173 84.041 84.011 84.011 84.186 84.010 84.281 84.281 84.298 PASS- THROUGH ENTITY ID NUMBER NIA $ NIA $ NIA $ N/A $ N/A $ NIA NIA NIA NIA NIA NIA NIA FEDERAL REVENUE IN PERIOD EXPENDITURES IN PERIOD 97,654.81 257,270.23 $ 354,925.04 $ (2) 610,209.59 (3) 610,209.59 33,752.60 388,677.64 $ 33,752.60 643,962.19 53,288.14 $ 35,469.49 88,757.63 $ 53,288.14 35,469.49 88,757.63 2,287.27 (4) 12,010.41 8,102.17 339,636.73 18,500.00 11,009.00 1,092.52 10,858.73 8,102.17 339,636.73 3,854.20 7,973.38 11,009.00 -24- LANIER COUNTY BOARD OF EDUCATION SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS YEAR ENDED JUNE 30, 1999 SCHEDULE "1" FUNDING AGENCY PROGRAM/GRANT Education, U. S. Department of Other Programs Pass-Through From Georgia Department of Education Vocational Education - Basic Grants to States High School Program Basic Grant 1999 Grant Tech-Prep Education 1999 Grant Total U. S. Department of Education Labor, U. S. Department of Pass-Through From South Georgia Regional Development Center Job Training Partnership Act PY97-II-B-2 Health and Human Services, U. S. Department of Pass-Through from Georgia Department of Human Resources Substance Abuse Program 1999 Grant OTHER FEDERAL ASSISTANCE Defense, U. S. Department of Pass-Through From Defense Activity for Non-Traditional Education Support (DANTES) Troops To Teachers Grant 1999 Grant CFDA NUMBER PASSTHROUGH ENTITY ID NUMBER FEDERAL REVENUE IN PERIOD EXPENDITURES IN PERIOD 84.048 84243 NIA $ NIA $ 21,285.00 $ 40,000.00 541,588.21 $ 21,285.00 40,000.00 532,569.36 17.250 NIA $ 6,574.32 $ 6,574.32 93.959 NIA $ 51205.00 $ 5,205.00 N/A $ 8,921.04 $ 38 408.19 (3) Total Federal Financial Assistance NIA = Not Available $ 950,966.21 $ ====1=,2=2=6,=7=19=.=06= Notes to the Schedule of Expendib.Jres of Federal Awards (1) The amounts shown for the Food Distribution Program represents the Federally assigned value of nonrnonetary assistance for donated commodities received and/or consumed by the system during the current fiscal year. (2) Expenditures for the School Breakfast Program were not maintained separately and are included in the 1999 National School Lunch Program. (3) Expenditures for this program include State, and/or Other Funds. Expenditures are not maintained by fund source. (4) Expenditures on this program were not maintained by fund source. Major Programs are identified by an asterisk (*) in front of the CFDA number. The Board did not provide Federal Assistance to any Subrecipienl The accompanying schedule of expendib.Jres of Federal awards includes the Federal grant activity of the Lanier County Board of Education and is presented on the modified accrual basis of accounting which is the basis of accounting used in the presentation of the general purpose financial statements. See notes to the general purpose financial statements. -25- LANIER COUNTY BOARD OF EDUCATION SCHEDULE OF STATE REVENUE YEAR ENDED JUNE 30, 1999 SCHEDULE "2" AGENCY/FUNDING GRANTS Education, Georgia Department of Quality Basic Education General and Career Education Programs Special Education Programs Remedial Education Program Media Center Programs Staff Development Programs Indirect Cost Pupil Transportation Regular Bus Replacement Sparsity Grant Middle School Incentive Program Special Instructional Assistance In-School Suspension Migrant Education Counselors Grades 4 and 5 Technology Specialist Local Fair Share Educational Equalization Funding Grant Food Services Vocational Education Other State Programs Alternative Program At-Risk Summer School Program Environmental Science Program Health Insurance Student Records Preschool Handicapped Program Remedial Summer School Program Year 2000 Project Teachers' Retirement Tuition for the Multi-Handicapped Lottery Programs Assistive Technology Computers in the Classroom Georgia Department of Community Affairs Governor's Emergency Funds (1) Office of School Readiness Pre-Kindergarten Program Office of Treasury and Fiscal Services Public School Employees Retirement OTHER Education, Georgia Department of Reimbursement for Registration GOVERNMENTAL FUND TYPES SPECIAL GENERAL REVENUE FUND FUND TOTAL $ 2,912,869.00 307,887.00 98,822.00 121,793.00 33,927.00 813,013.00 146,276.00 32,474.00 102,496.00 112,187.00 180,914.00 83,552.00 1,023.00 12,725.00 28,842.00 -290,524.00 510,509.00 $ 27,723.00 31,000.00 7,634.59 500.00 91,371.98 1,017.75 16,825.00 3,418.39 4,476.50 9,022.54 94,876.92 10,000.00 17,550.00 $ 42,178.00 4,591.85 26,813.00 2,912,869.00 307,887.00 98,822.00 121,793.00 33,927.00 813,013.00 146,276.00 32,474.00 102,496.00 112,187.00 180,914.00 83,552.00 1,023.00 12,725.00 28,842.00 -290,524.00 510,509.00 42,178.00 27,723.00 31,000.00 7,634.59 500.00 91,371.98 1,017.75 16,825.00 3,418.39 4,476.50 9,022.54 94,876.92 4,591.85 26,813.00 10,000.00 347,1TT.22 347,1TT.22 17,550.00 399.00 399.00 $ 5,524,600.67 $ (1) To assist the high school with expenses in connection with their band program. See notes to the general purpose financial statements. -26- 420,760.07 $ 5,945,360.74 LANIER COUNTY BOARD OF EDUCATION SCHEDULE OF EXPENDITURES LOTTERY PROGRAMS YEAR ENDED JUNE 30, 1999 SCHEDULE 3 EXPENDITURES ASSISTIVE TECHNOLOGY COMPUTERS INTHE CLASSROOMS PRE-KINDERGARTEN PROGRAM Current Instruction $ Support Services Pupil Services Improvement of Instructional Services Maintenance and Operation of Plant Student Transportation Services Food Services Operation 4,591.85 $ 26,813.00 $ 309,073.88 $ 49,773.61 3,187.84 12,271.08 1,906.58 3,680.87 TOTAL 340,478.73 49,773.61 3,187.84 12,271.08 1,906.58 3,680.87 Total Expenditures $ 4,591.85 $ 26,813.00 $ 379,893.86 $ 411,298.71 RECAP: Salaries and Benefits Pre-Kindergarten Program Other Expenditures Assistive Technology Computers in the Classrooms Pre-Kindergarten Program $ 351,311.31 4,591.85 26,813.00 28,582.55 $ 411,298.71 See notes to the general purpose financial statements. -27- LANIER COUNTY BOARD OF EDUCATION ANALYSIS OF MINIMUM EXPENDITURE REQUIREMENTS - OVERALL GENERAL FUND - QUALITY BASIC EDUCATION PROGRAMS YEAR ENDED JUNE 30, 1999 SCHEDULE "4" Minimum Expenditure Requirements (Total Allotment) Expenditures on Combined Program Basis Salaries Operations Less: Expenditures for Media Center Programs in Excess of Total Media Allotment Expenditures per Audit Amount of Underexpenditure for Total Allotment FOURTEEN WEIGHTED AND MEDIA CENTER PROGRAMS 100% TEST FOR OPERATIONS PORTION OF FOURTEEN WEIGHTED PROGRAMS $ 3,441,371.00 $ 124,573.00 $ 3,544,230.49 161,886.33 $ _ _.......:,.13~4;;,.:.;,6;;.;:8:..:,1.:.::.8~1 $ 3,706,116.82 -34,392.20 $ _ _.=,3i.:,6.:..71:.z.;7,;..=2~4:..;;:62=- $ 0.00 $=======0=00= See notes to the general purpose financial statements. - 29 - LANIER COUNTY BOARD OF EDUCATION ANALYSIS OF MINIMUM EXPENDITURE REQUIREMENTS - BY PROGRAM GENERAL FUND - QUALITY BASIC EDUCATION PROGRAMS YEAR ENDED JUNE 30, 1999 GENERAL AND CAREER EDUCATION PROGRAMS Kindergarten (*) Grades 1 - 3 (*) Sub-Total - K-3 Grades 4 - 5 (*) Grades 6 - 8 (*) Grades 9-12 (*) High School Laboratories (*) Vocational Education Laboratories (*) Total General and Career Education Programs SPECIAL EDUCATION PROGRAMS Regular Programs Category II (*) Category Ill (*) Category IV (*) Sub-Total - Regular Category VI (Gifted) (*) Total Special Education Programs .REMEDIAL EDUCATION PROGRAM (*} Total Fourteen Weighted Programs MEDIA CENTER PROGRAMS Salaries Operations Total Media Center Programs ORIGINAL ALLOTMENTS FROM GEORGIA DEPARTMENT OF REQUIRED % ORIGINAL MIO-TERM $ 315,738.00 $ 284,164.20 $ 0.00 756,779.00 681,101.10 $ 1,072,517.00 90 $ 965,265.30 $ 0.00 380,092.00 90 342,082.80 664,257.00 90 597,831.30 240,818.00 90 216,736.20 240,312.00 90 216,280.80 314,873.00 90 283,385.70 $ 2,912,869.00 $ 2,621,582.10 $ 0.00 $ 286,500.00 $ 257,850.00 $ 0.00 $ 286,500.00 21,387.00 $ 307,887.00 $ 98,822.00 $ 3,319,578.00 90 $ 257,850.00 $ 90 19,248.30 $ 277,098.30 $ 90 $ 88,939.80 $ $ 2,987,620.20 $ $ 95,763.00 90 $ 86,186.70 $ 26,030.00 100 26,030.00 $ 121,793.00 $ 112,216.70 $ 0.00 0.00 0.00 0.00 0.00 0.00 Total Fourteen Weighted and Media Center Programs $ 3,441,371.00 $ 3,099,836.90 $ 0.00 STAFF DEVELOPMENT PROGRAMS Cost of Instruction Professional Development Total Staff Development Programs r) Identifies Fourteen Weighted Programs. See notes to the general purpose financial statements. $ 10,712.00 23,215.00 $ 10,712.00 $ 23,215.00 0.00 0.00 s_ _ 33.,,9_2_,1o..o.. 11111 100 $ 33,927.00 $ -==-......0.-.-0=0 - 30 - SCHEDULE 5 EDUCATION TOTAL REQUIRED ACTUAL EXPENDITURES SALARIES OPERATIONS TOTAL AMOUNT OF UNDEREXPENDITURE FOR REQUIRED ALLOTMENT $ 284,164.20 $ 289,370.35 $ 3,443.45 $ 292,813.80 681,101.10 707,373.20 17,933.34 725,306.54 $ 965,265.30 $ 996,743.55 $ 21,376.79 $ 1,018,120.34 $ 0.00 342,082.80 388,371.73 10,956.30 399,328.03 0.00 597,831.30 615,561.56 20,798.99 636,360.55 0.00 216,736.20 248,178.14 29,304.02 277,482.16 0.00 216,280.80 332,404.05 9,884.35 342,288.40 0.00 283,385.70 274,507.93 34,167.80 308,675.73 0.00 $ 2,621,582.10 $ 2,855,766.96 $ 126,488.25 $ 2,982,255.21 $ 257,850.00 $ 140,221.87 $ 261,755.99 347.06 1,218.00 $ 4,800.00 141,439.87 266,555.99 347.06 $ 257,850.00 $ 402,324.92 $ 6,018.00 $ 408,342.92 0.00 19,248.30 50,591.81 305.24 50,897.05 0.00 $ 277,098.30 $ 452,916.73 $ 6,323.24 $ 459,239.97 $ 88,939.80 $ 106,566.12 $ 1,870.32 $ 108,436.44 0.00 $ 2,987,620.20 $ 3,415,249.81 $ 134,681.81 $ 3,549,931.62 $ 86,186.70 $ 128,980.68 $ 128,980.68 0.00 26,030.00 - - - - - - $ _ _ _27__,2_04_._52_ 27,204.52 0.00 $ 112,216.70 $ 128,980.68 $ 27,204.52 $ _ _1_56__,1_8_5._20_ $ 3,099,836.90 $ 3,544,230.49 $ 161,886.33 $ 3,706,116.82 $ _ _ _ _ _ _ _0..,.0_0 $ 10,712.00 23,215.00 $-=-==.3..3..,.9==2=7=.o=o $ 17,529.45 $ 17,529.45 16,497.86 16,497.86 $ 34,027.31 $ 34,027.31 $ _ _ _ _ _ _ _o_.o_o - 31 - SECTION IT 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 March 1, 2000 Honorable Roy E. Barnes, Governor Members of the General Assembly Members of the State Board of Education and Superintendent and Members of the Lanier 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 of Lanier County Board of Education as of and for the year ended June 30, 1999, and have issued our report thereon dated March 1, 2000. 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 of the United States. Compliance As part of obtaining reasonable assurance about whether Lanier County Board of Education's financial statements are free of material misstatement, we performed tests of its 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 Lanier County Board ofEducation'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. 99YB-40 However, we noted a certain matter involving the internal control over financial reporting and its 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 of the internal control over financial reporting that, in our judgement, could adversely affect Lanier County Board of Education's ability to record, process, summarize and report financial data consistent with assertions of management in the financial statements. The reportable condition is described in the accompanying Schedule of Findings and Questioned Costs as item FS-6861-99-02. 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 of performing their assigned functions. Our consideration 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 conditions that are also considered to be material weaknesses. However, the reportable condition described above is also considered to be a material weakness. This report is intended solely for the information and use of management, members of the Lanier County Board ofEducation, Federal awarding agencies and pass-through entities and is not intended to be and should not be used by anyone other than these specified parties. Respectfully submitted, ~ UJ.~.:::L: Russell W. Hinton State Auditor RWH:jb 99YB-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 March 1, 2000 Honorable Roy E. Barnes, Governor Members of the General Assembly Members of the State Board ofEducation and Superintendent and Members of the Lanier County Board of Education REPORT ON COMPLIANCE WITH REQUIREMENTS APPLICABLE TO EACH MAJOR PROGRAM AND INTERNAL CONTROL OVER COMPLIANCE IN ACCORDANCE WITH 0MB CIRCULARA-133 Ladies and Gentlemen: Compliance We have audited the compliance of Lanier County Board of Education with the types of compliance requirements described in the U.S. Office ofManagement and Budget (0MB) Circular A-133 Compliance Supplement that are applicable to each ofits major Federal programs for the year ended June 30, 1999. Lanier County Board ofEducation's major Federal programs are identified in the accompanying Schedule ofFindings and Questioned Costs. Compliance with the requirements of laws, regulations, contracts and grants applicable to each ofits major Federal programs is the responsibility of Lanier County Board of Education's management. Our responsibility is to express an opinion on Lanier County Board ofEducation'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 ofthe United States; and 0MB Circular A-133,Audits ofStates, Local Governments, and Non-Profit Organizations. Those standards and 0MB 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 Lanier 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 Lanier County Board of Education's compliance with those requirements. 99SA-10 In our opinion, the Lanier 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, 1999. Internal Control Over Compliance The management of Lanier 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 Lanier County Board ofEducation's internal 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 0MB Circular A-133. Our consideration of the 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 of one 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 solely for the information and use of management, members of the Lanier County Board ofEducation, Federal awarding agencies and pass-through entities and is not intended to be and should not be used by anyone other than these specified parties. Respectfully submitted, ~tn.J Russell W. Hinton State Auditor RWH:jb 99SA-10 SECTION ill AUDITEE'S RESPONSE TO PRIOR YEAR FINDINGS AND QUESTIONED COSTS LANIER COUNTY BOARD OF EDUCATION AUDITEE'S RESPONSE SUMMARY SCHEDULE OF PRIOR YEAR FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 1999 PRIOR YEAR FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS FINDING CONTROL NUMBER AND STATUS FS-6861-97-01 FS-6861-97-02 FS-6861-98-01 FS-6861-98-02 Further Action Not Warranted Further Action Not Warranted Previously Reported Corrective Action Implemented Unresolved - See Corrective Action/Responses CORRECTIVE ACTION/RESPONSES GENERAL FIXED ASSETS Failure to Maintain General Fixed Assets Account Group Reportable Condition - Material Weakness Finding Control Number: FS-6861-98-02 A General Fixed Assets Account Group is not possible at this time due to the expense of establishing a cost for the existing assets of the system. SECTION IV FINDINGS AND QUESTIONED COSTS LANIER COUNTY BOARD OF EDUCATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 1999 I SUMMARY OF AUDITOR'S RESULTS 1. Type of Report Issued on the Financial Statements The auditor's opinion on the Lanier County Board of Education's financial statements was qualified for various departures from generally accepted accounting principles. 2. Reportable Conditions in Internal Control Disclosed by the Audit of the Financial Statements The audit report for the Lanier County Board of Education 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 Lanier County Board ofEducation disclosed no instances ofnoncompliance that were deemed material to the financial statements. 4. Reportable Conditions in Internal Control Over Major Programs The audit report for the Lanier 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 Lanier County Board of Education's report on compliance with requirements applicable to major programs was unqualified. 6. Audit Findings Required to be Re.ported by Section .SlO(a) ofOMB Circular A-133 The Lanier County Board ofEducation's audit did not disclose audit findings required to be reported by section .510(a) ofOMB Circular A-133. 7. Major Programs Federal awards audited as major programs are as follows: 10.553 Food and Nutrition Program - Food Services - School Breakfast Program 10.555 Food and Nutrition Program - Food Services - National School Lunch Program 84.O1O Elementary and Secondary Education Act - Title I - Grants to Local Educational Agencies 8. Type "A" Program Dollar Threshold The dollar threshold for type "A" programs was $300,000.00. 9. Low Risk Auditee The Lanier County Board ofEducation did not qualify as a low risk auditee as defined by Section .530 of 0MB Circular A-133. - 1- LANIER COUNTY BOARD OF EDUCATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 1999 II FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS GENERAL LEDGER Failure to Transfer Required Local Matching Funds Nonmaterial Noncompliance Finding Control Number: FS-6861-99-01 The Lanier County Board of Education failed to transfer required local matching funds for the Low-Wealth and Exceptional Growth (Lottery) Capital Outlay Projects from local funds to the GSFIC and Lottery Capital Projects Funds as required for the approved State Capital Outlay Projects for the 1999 fiscal year. Both the instructions in Chapter 41 of the Financial Management for Georgia Local Units of Administration and the agreements signed by the Board to receive funding through Georgia Department ofEducation require that the Board transfer local matching funds by year end and designate those funds by project name and number. Correcting audit adjustments were necessary to transfer local matching funds in the amounts of $19,973.00 to GSFIC Project Number LW00/99S-686-006 and $17,964.00 to Lottery Project Number 00G/99S-686-048. The Board should implement procedures to ensure that all required local transfers are made by the time required. GENERAL FIXED ASSETS Failure to Maintain General Fixed Assets Account Group Reportable Condition - Material Weakness Repeated from Prior Year Finding Control Number: FS-6861-99-02 The Lanier County Board ofEducation 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 ofthe 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 of a General Fixed Assets Account Group. These subsidiary records should include an inventory of land, 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 ofall additions and deletions to the General Fixed Assets Account Group. ill FEDERAL AWARD FINDINGS AND QUESTIONED COSTS No matters were reported. -2-