(;;,A .AR~,OO V BUPGETFUNp YEAR ENDED JUNE 30, 1995 EXHIBIT H" FUND BALANCE JULY 1 Reaerved Unreeerved Designated Surplus ADDITIONS Adjustments to Prior Year's Accounts Payable Excess of Funds Available rNer Expenditures Exhibit r DEDUCTIONS Unreeerved Fini Balance (Surplus) Returned to Georgia Department of Technical and Adult Education - Administrative Central Office Year Ended June 30. 1994 Adjustments to Prior Year's Accounts Receivable Refunds to Grantors Georgia Department of Technical and Adult Education - Adminllltrative Central Office Federal Financial Aaaistance Reaerved Fini Balance C8nied Over from Prior Year Funds Available FUND BALANCE - JUNE 30 (To Exhibit G") A DEPARTMENT OF TECHNICAL AND ADULT EDUCATION e LOTTERY FOR EDUCATION TOTAL $ 805,849.57 121100.14 $ $ 8171949.71 $ $ 0.00 0.00 $ 805,849.57 121100.14 8171949.71 $ ~7.72 715,158.76 $ $ 715,546.48 $ $ 0.00 0.00 $ ~7.72 715,158.76 715,546.48 $ 12,100.14 $ 269.28 1,813.07 611,266.37 $ 625,448.86 $ $ 9081047.33 $ 0.00 $ 12,100.14 269.28 0.00 $ 1,813.07 611,266.37 625,448.86 0.00 $ 9081047.33 See accompanying not and lndepel ldent Accountant's Combined Report on Review of Financial Statements and Supplementary Information. - 29 - AUGUSTA TECHNICAL INSTITUTE COMBINING STATEMENT OF FUNDS AVAILABLE AND EXPENDITURES BUDGET FUND VEAR ENDED JUNE 30, 1995 EXHIBIT"r "A" DEPARTMENT OF TECHNICAL AND ADULT EDUCATION "B" LOTTERY FOR EDUCATION FUNDS AVAILABLE REVENUES STATE FUNDS Allotment from Georgia Deparbnent of Technical and Adult Education - Administrative Central Office $ FEDERAL REVENUES $ OTHER REVENUES RETAINED Contracts Georgia Deparbnent of Administrative Services Distance Leaming Project $ Georgia Deparbnent of Human Resources PEACH Project Georgia Institute of Technology Satellite Technology Project Fees Application Graduation Registration/Continuing Education Other Interest Earned Rents Sales and Services (Net) Tuition Other Sources 8?591101.14 $ 11691 1403.67 59,717.91 86,853.65 10,840.26 38,660.00 17,533.00 575,218.62 517.50 2,338.19 7,819.49 261,992.86 1,385,268.65 6n4.37 6531350.32 $ $ $ Total Other Revenues Retained $ 214531534.50 $ Total Revenues $ 1219041039.31 $ 6531350.32 $ CARRY-OVER FROM PRIOR YEAR Transfer from Reserved Fund Balance Live Work Projects $ 108,416.38 $ Prior Year Local Funds 136,364.99 State Grants and Contracts 11.87 Student Services 3661473.13 Total Carry-Over from Prior Year $ 6111266.37 $ TOTAL 914121451.46 11691 1403.67 59,717.91 86,853.65 10,840.26 38,660.00 17,533.00 575,218.62 517.50 2,338.19 7,819.49 261,992.86 1,385,268.65 6n4.37 214531534.50 1315571389.63 108,416.38 136,364.99 11.87 3661473.13 611.266.37 Total Funds Available $ 13,515,305.68 $ 653,350.32 $ 14,168,656.00 See accompanying notes and Independent Accountant's Combined Report on Review of Financial Statements and Supplementary Information. - 30 - AUGUSTA TECHNICAL INSTITUTE COMBINING STATEMENT OF FUNDS AVAILABLE AND EXPENDITURES BUDGET FUND YEAR ENDED JUNE 30, 1995 EXHIBIT"r' EXPENDITURES PERSONAL SERVICES-INSTITUTIONS Salaries and Wages Employer's Contributions for: F.1.C.A Retirement Health Insurance Unemployment Compensation Insurance Workers' Compensation Insurance OPERATING EXPENSES-INSTITUTIONS OtherCos1B Motor Vehicle Expenses Supplies and Materials Repairs and Maintenance Utilities Rents (Other than Real Estate) Insurance and Bonding Other Operating Expenses Publications and Printing Travel Motor Vehicle Purchases Equipment Equipment Purchases Rental of Equipment Computer Charges Software Real Estate Rentals Telecommunications Per Diem, Fees and Contracts Per Diem and Fees Contracts QUICK START PROGRAM Personal Services Salaries and Wages Employer's Contributions for: F.1.C.A Retirement Health Insurance DEPARTMENT OF TECHNICAL AND ADULT EDUCATION "B" LOTTERY FOR EDUCATION TOTAL $ 7,249,204.n 181,223.84 766,519.36 m,376.03 4,849.00 181901.00 $ 819981074.00 $ 4,146.28 462,367.68 149,025.30 445,255.13 10,882.48 48,431.25 829,n5.06 38,423.53 90,696.11 12,884.60 204,028.31 5,032.54 11,257.10 36,085.20 51.10 214,925.45 171562.00 $ 215801829.12 $ 33,402.98 1,474.54 2,580.60 2,013.45 $ 7,249,204.n 181,223.84 766,519.36 m,376.03 4,849.00 181901.00 $ 819981074.00 $ 4,146.28 462,367.68 149,025.30 445,255.13 10,882.48 48,431.25 829,n5.06 38,423.53 90,696.11 12,884.60 204,028.31 5,032.54 11,257.10 36,085.20 51.10 214,925.45 171562.00 $ 215801829.12 $ 33,402.98 1,474.54 2,580.60 2,013.45 See accompanying notes and Independent Accountant's Combined Report on Review of Financial Statements and Supplementary Information. - 31 - AUGUSTA TECHNICAL INSTITUTE COMBINING STATEMENT OF FUNDS AVAILABLE AND EXPENDITURES BUDGET FUND YEAR ENDED JUNE 30, 1995 EXHIBtrr A" DEPARTMENT OF TECHNICAL AND ADULT EDUCATION EXPENDITURES QUICK START PROGRAM Other Costs Supplies and Materials Repairs and Maintenance Utilities Other Operating Expenses Travel Equipment Equipment Purchases Computer Charges Software Per Diem, Fees and Contracts Per Diem and Fees $ 20,030.26 2,531.64 20,092.98 11,340.44 1,809.72 20,513.92 7,289.89 4621350.88 $ 5851431.30 ADULT LITERACY GRANTS Personal Services Salaries and Wages Employer's Contributions for: F.I.C.A Retirement Health Insurance Other Costs Supplies and Materials Repairs and Maintenance Utilities Other Operating Expenses Publications and Printing Travel Equipment Equipment Purchases Per Diem, Fees and Contracts Per Diem and Fees $ 418,763.02 16,097.94 35,336.00 31,123.37 22,992.58 1,392.71 3,631.28 45,086.n 519.38 2,545.92 8,736.40 21878.70 $ 589.104.07 JOB TRAINING PARTNERSHIP ACT Personal Services Salaries and Wages Employer's Contributions for: F.I.C.A Retirement Health Insurance $ 35,071.06 579.13 4,118.47 4,254.04 See accompanying notes and Independent Accountant's Combined Report on Review of Financial Statements and Supplementary Information. - 32 - "B" LOTTERY FOR EDUCATION $ $ $ $ $ TOTAL 20,030.26 2,531.64 20,092.98 11,340.44 1,809.72 20,513.92 7,289.89 462.350.88 585.431.30 418,763.02 16,097.94 35,336.00 31,123.37 22,992.58 1,392.71 3,631.28 45,086.n 519.38 2,545.92 8,736.40 21878.70 589.104.07 35,071.06 579.13 4,118.47 4,254.04 AUGUSTA TECHNICAL ltl!STITUTE COMBINING STATEMENT OF FUNDS AVAILABLE AND EXPENDITURES BUDGET FUND YEAR ENDED JUNE 30, 1995 EXHIBITr NA" DEPARTMENT OF TECHNICAL AND ADULT EDUCATION "B" LOTTERY FOR EDUCATION EXPENDITURES JOB TRAINING PARTNERSHIP ACT Other Costs Supplies and Materials Repairs and Maintenance Travel Equipment Rental of Equipment $ 232.24 $ 440.00 759.14 1,254.35 $ 46,708.43 $ ~OMPUTER LABQRATORIES AND ATELLITE DISHES ADULT LITERACY Equipment Equipment Purchases $ 5,318.90 $ EQUIPMENT-TECHNICAL INSTITUTES Other Costs Other Operating Expenses Computer Charges Equipment Equipment Purchases Equipment Equipment Purchases $ 265.98 $ 185,763.69 307,306.27 $ 493,335.94 $ REPAIRS AND RENOVATIONS Other Costs Repairs and Maintenance Other Operating Expenses $ 154,429.50 $ 265.98 $ 154,695.48 $ Total Expenditures $ 12,800,146.92 $ 653,350.32 $ Excess of Funds Available over Expenditures 715,158.76 0.00 TOTAL 232.24 440.00 759.14 1,254.35 46.708.43 5,318.90 265.98 185,763.69 307,306.27 493,335.94 154,429.50 265.98 154,695.48 13,453,497.24 715,158.76 $ 13,515,305.68 $ 653,350.32 $ 14,168,656.00 See accompanying notes and Independent Accountant's Combined Report on Review of Financial Statements and Supplementary Information. - 33 - AUGUSTA TECHNICAL INSTITUTE COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES FIDUCIARY FUND TYPE - AGENCY FUNDS YEAR ENDED JUNE 30 1995 EXHIBrrr f.UW2 General Scholarship F&nl HOPE Scholarship Program l.lcenlecl Practical Nurae Examination F._ l.lcenlecl Practical Nurse Insurance Pell Grant Program student Activities F&nl Student Government Fund studentlnaurance student Transpo,tation FNS Supplemental Educational Opportunity Grants ASSETS/ LIABILITIES JULY1 1 1994 s 6,092.98 $ 47,rXJ7.08 1,621.n 781.39 850.42 1"9,268.91 257.05 15,334.59 0.00 ADDITIONS 43,1"9.29 $ DEDUCTIONS 37,375.40 $ ASSETS/ LIABILITIES JUNE 301 1995 11,866.87 588,473.02 635,553.10 17.00 3,307.20 2,636.63 2,298.29 10,291.25 8,465.00 2,607.64 887,327.87 888,755.12 -576.83 124,5"9.n 143,467.72 130,350.96 0.00 0.00 257.05 19,088.20 15,004.00 19,418.79 23,038.50 13,871.50 9,167.00 3,322.50 43,2"9.24 46,1"9.32 422.42 s 224,632.64 $ 1,742,474.34 $ 1,791,2n.79 $ =====1=7=5'=829==.1=9 See accompanying notes and Independent Accountanfs Combined Report on Review of Financial statements and Supplementary Information. -34- AUGUSTA TECHNICAL INSTITUTE CASH AND CASH EQUIVALENTS JUNE 30, 1995 NONINTEREST BEARING ACCOUNTS Truat Company Bank of Augusta, Augua,Georgia INTEREST BEARING ACCOUNTS Truat Company Baik of Augusta, Augusta.Georgia Checking With Interest Account OTHER Cashon Hand Petty Cash $ 644,518.92 102,623.90 1,010.01 $ ====7=48=l'6=15=2=.83= See accompanying notes and Independent Accountant's Combined Report on Review of Financial Statements and Supplementary Information. -35- BUQGETFUNP Trust Company Bmik of Augusta, Auguata,Georgia c.tlflcates ot Depoelt No. 530015486 No. 530034750 AUGUSTA TECHNICAL INSTITUTE INVESTMENTS JUNE 30. 1995 PURCHASE DATE INTEREST RATE MATURITY DATE SCHEDULE"'Z' AMOUNT March 24, 1995 May2.1995 4.23Cl6 4.47% September 22. 1995 $ October 31. 1995 $ 10,000.00 10,000.00 20.000.00 See accompanying notes and Independent Accountant's Combined Report on Review of Financial Statements and Supplementary Information. -36- AUGUSTA TECHNICAL INSTITUTE SCHEDULE OF FEDERAL RE\IENUES YEAR ENDED JUNE 30.1995 BUDGET FUND Education, U. S. Department of Adult Education - StatB Administered Basic Grant Program Through Georgia Department of Technical and Adult Education - Administrative Central Office Federal Work-Study Program Dir8ct Vocational Education - Basic Grants to States Through Georgia Department of Technical and Adult Education - Administrative Central Office Vocational Education - Community Based Organizations Through Georgia Department of Technical and Adult Education - Administrative Central Office Health and Human Services, U. S. Department of Job Opportunities and Basic Skills Training Through Georgia Department of Human Resources Various Offices of Division of Family and Children Services Labor, u. s. Department of Job Training Partnership kt Through East Central Georgia Consortium Through Georgia Department of Labor Through Georgia Department of Technical and Adult Education - Administrative Central Office Through Richmond/Burke Job Training Authority CFDA NUMBER 84.002 84.033 84.048 84.174 93.561 17.250 17.250 17.250 17.250 SCHEDULE "3" AMOUNT $ 301,103.69 21,896.09 612,390.47 9,498.35 142,986.79 41,801.33 327,799.89 46,708.11 187,218.95 $ ==1=,69====1,==403====.67= See accompanying notes and Independent Accountant's Combined Report on Review of Financial Statements and Supplementary lnfoonation. - 37 - AUGUSTA TECHNICAL INSTITUTE RECONCILIATION OF SALARIES AND WAGES, AND TRAVEL YEAR ENDED JUNE 30, 1995 SCHEDULE4 Totals per Annual Supplerrw,t Accruals .knt 30, 1995 Adjustments Coleman, WIiiiam Totals per Report SUMMARY BY OBJECT CLASS BUDGET FUND Personal Services-Institutions Operating Cxpa iaes Institutions Quick Start Program Adu!: Litllracy Grants Job Training Partnership Act SALARIES ANDWAGES $ 7,717,320.86 $ TRAVEL 95,810.89 18,627.97 "93.00 $ 7,736,441.83 $ =====95='=81=0=.89= $ 1,249,204.n $ 33,402.98 418,763.02 35,071.06 90,696.11 1,809.72 2,545.92 759.14 $ 7,736,441.83 $ =======95='==81==0=.89= See accompanying notes and Independent Accountant's Combined Report on Review of Financial Statements and Supplementary Information. -38- AUGUSTA TECHNICAL INSTITUTE RECONCILIATION OF PER DIEM AND FEES YEAR ENDED JUNE 30, 1995 SCHEDULE s- Totals per Annual SupplemelIt Adjuatments Augusta Appralaal Company TYPE PAYMENT FEE AMOUNT EXPENSE AMOUNT $ 673,680.02 $ 6,075.01 $ TOTAL 679,755.03 Consultanl& - Quick Start 400.00 400.00 Totals per Report $ 674,080.02 $ 6,075.01 $ ===-=680=--155_.03= SUMMARY BY OBJECT CLASS BUDGET FUND Operating Expeiw Institutions Quick Start Program Adult Literacy Grants $ 214,925.45 462,350.88 2,878.70 $ ===-=680=='=155==.03= See accompanying notes and Independent Accountant's Combined Report on Review of Financial Statements and Supplementary Information. -39- SECTION II FINDINGS AND IMPROPER OR QUESTIONED COSTS AUGUSTA TECHNICAL INSTITUTE SCHEDULE OF FINDINGS AND IMPROPER OR QUESTIONED COSTS YEAR ENDED JUNE 30, 1995 STATUS OF PRIOR YEAR FINDINGS AND IMPROPER OR QUESTIONED COSTS The status of the findings disclosed in the review report for the year ended June 30, 1994, is summarized below: Audit Control Number Status of Finding 824-94-01 824-94-02 824-94-03 See Audit Control Number 824-95-02 See Audit Control Number 824-95-01 Corrective Action Implemented PRIOR YEAR GENERAL FIXED ASSETS/PROPERTY MANAGEMENT Inadequate Equipment Inventory Records Financial Statements Audit Control Number 824-95-01 The review report for the year ended June 30, 1994, disclosed instances where two items of equipment were physically located, but were not recorded on the equipment inventory records. For the year under review, these two items were still not included on the Institute's equipment inventory records. The Institute should follow established procedures to ensure that all equipment is recorded on the equipment inventory records. PRIOR YEAR/CURRENT YEAR REVENUE/RECEIVABLES/RECEIPTS Inadequate Accounting Control Procedures Financial Statements Audit Control Number 824-95-02 The review reports for the years ended June 30, 1991, 1992, 1993 and 1994, disclosed numerous accounting control deficiencies with the "Other" accounts receivable category shown on the Combined Balance Sheet (Statutory Basis). For the year under review, the accounts receivable procedures were again deficient as indicated below: (I) As of June 30, 1995, the "Other" accounts receivable category shown on the Combined Balance Sheet (Statutory Basis) included $295.00 in student receivables outstanding from fiscal year 1994, $277.91 in student receivables outstanding from fiscal year 1993, $1,783.65 in student receivables outstanding from fiscal year 1992, $2,551.46 in student receivables outstanding from fiscal year 1991, and $23,665.30 in student receivables outstanding from fiscal year 1990. AUGUSTA TECHNICAL INSTITUTE SCHEDULE OF FINDINGS AND IMPROPER OR QUESTIONED COSTS YEAR ENDED JUNE 30, 1995 PRIOR YEAR/CURRENT YEAR REVENUE/RECEIVABLES/RECEIPTS Inadequate Accounting Control Procedures Financial Statements Audit Control Number 824-95-02 Tests ofthe underlying documentation supporting these receivables disclosed numerous instances where supporting documentation was not adequate to determine if the amounts recorded were actually earned by the Institute. (2) As of June 30, 1995, the "Other" accounts receivable category shown on the Combined Balance Sheet (Statutory Basis) included $8,869.61 in checks returned for insufficient funds. Included in this amount were $8,277.98 from fiscal year 1994 or earlier. (3) As of June 30, 1995 the "Other" accounts receivable category shown on the Combined Balance Sheet (Statutory Basis) included $751.39 in accounts receivable for tuition and fees from fiscal year 1993 for which payment was deferred by the Institute under a "Tuition Work Assistance Agreement" to enroll and attend classes at the Institute. Under this agreement, students were allowed to enroll and attend classes in exchange for work for the Institute. The "Tuition Work Assistance" policy was discontinued as ofJune 30, 1993. (4) As of June 30, 1995 the "Other" accounts receivable category shown on the Combined Balance Sheet (Statutory Basis) included $2,330.59 in accounts receivable for tuition and fees for which payment was deferred by the Institute. These deferments were a result of the Institute's approving a number of students for Pell Grants only later to find out the students were ineligible. Deferring payment oftuition and fees without approved financial aid is beyond the authority granted to the Institute by the Administrative Central Office ofthe Georgia Department of Technical and Adult Education. This practice by the Institute should be discontinued. The Institute should initiate collection procedures in an effort to collect all amounts due to the Institute. Furthermore, the Institute should review all delinquent student accounts receivable to determine ifthe amounts accurately reflect amounts owed to the Institute.