GA Agoo .RI Vb (V/S /qqb-17 MANAGEMENT REPORT MIDDLE GEORGIA TECHNICAL INSTITUTE WARNER ROBINS, GEORGIA AN ORGANIZATIONAL UNIT OF THE STATE OF GEORGIA YEAR ENDED JUNE 30, 1997 STATE OF GEORGIA DEPARTMENT OF AUDITS AND ACCOUNTS 254 WASHINGTON STREET ATLANTA, GEORGIA 30334-8400 MIDDLE GEORGIA TECHNICAL INSTITUTE MANAGEMENT REPORT - TABLE OF CONTENTS - LETTER OF TRANSMITTAL SECTION I SELECTED FINANCIAL INFORMATION EXillBITS A ANALYSIS OF CHANGES IN FUND BALANCE BUDGET FUND 2 SCHEDULES OF FUNDS AVAILABLE AND EXPENDITURES COMPARED TO BUDGET BUDGET FUND B "A" DEPARTMENT OF TECHNICAL AND ADULT EDUCATION 3 C "B" LOTTERY FOR EDUCATION 4 SECTION II AUDITEE'S RESPONSE TO PRIOR YEAR FINDINGS AND QUESTIONED COSTS SUMMARY SCHEDULE OF PRIOR YEAR FINDINGS AND QUESTIONED COSTS SECTION III CURRENT YEAR FINDINGS AND QUESTIONED COSTS SCHEDULE OF FINDINGS AND QUESTIONED COSTS CLAUDE L. VICKERS STATE AUDITOR (404) 656-2174 DEPARTMENT OF AUDITS AND ACCOUNTS 254 Washington Street, S.w., Suite 214 Atlanta, Georgia 30334-8400 October 3, 1997 Honorable Zell Miller, Governor Members of the General Assembly of Georgia Members of the State Board of Technical and Adult Education Members of the Local Board of Directors and Honorable Billy Edenfield, President Middle Georgia Technical Institute Ladies and Gentlemen: As part of our audit of the statutory basis financial statements of the State of Georgia presented in the Report ofthe State Auditor, the general purpose financial statements of the State of Georgia presented in the State ofGeorgia Comprehensive Annual Financial Report, and the issuance of a Statewide Single Audit Report pursuant to the Single Audit Act Amendments, as ofand for the year ended June 30, 1997, we have performed certain audit procedures at Middle Georgia Technical Institute. Accordingly, the financial statements and compliance activities ofMiddle Georgia Technical Institute were examined to the extent considered necessary in order to express opinion as to the fair presentation of the financial statements contained in the foregoing documents and to issue reports on compliance and internal control as required by the Single Audit Act Amendments of 1996. This Management Report contains information pertinent to the financial and compliance activities of Middle Georgia Technical Institute as of and for the year ended June 30, 1997. The particular information provided is enumerated in the Table of Contents. This report is intended solely for the use of management of Middle Georgia Technical Institute. However, this report is a matter of public record and its distribution is not limited. Rea;~ CLV:jy Claude L. Vickers State Auditor SECTION I SELECTED FINANCIAL INFORMATION FUND BALANCE - JUNE 30,1997 SUMMARY OF FUND BALANCE Reserved Federal Financial Assistance For Other Inventories Live Work Projects Prior Year Local Funds Local Match Surplus $ 216,494.68 $ 0.00 $ ======2=16=,4=9=4=.6=8 $ 15,598.90 50,452,50 22,137,53 125,696.59 2,602,99 6.17 $ $ -2- 216,494.68 $ $ 0.00 15,598.90 50,452,50 22,137,53 125,696,59 2,602.99 6.17 0,00 $ ======2=16=,4=9=4=.6:=8 MIDDLE GEORGIA TECHNICAL INSTITUTE SCHEDULE OF FUNDS AVAILABLE AND EXPENDITURES COMPARED TO BUDGET BUDGET FUND "A" DEPARTMENT OF TECHNICAL AND ADULT EDUCATION YEAR ENDED JUNE 30, 1997 EXHIBIT"B" FUNDS AVAILABLE REVENUES State Appropriations Federal Revenues Other Revenues Retained CARRY-OVER FROM PRIOR YEAR Transfer from Reserved Fund Balance BUDGET ACTUAL VARIANCE FAVORABLE (UNFAVORABLE) $ 4,106,552.00 $ 4,106,552.00 $ 1,115,268.00 1,027,028.07 2,200,707.00 1,600,327.99 $ 7,422,527.00 $ 6,733,908.06 $ 0.00 -88,239.93 -600,379.01 -688,618.94 3,686.00 145,738.98 142,052.98 $ 7,426,213.00 $ 6,879,647.04 $ _ _......:.-5_46-'-,......:.56......:.5_.9~6 EXPENDITURES Personal Services-I nstitutions Operating Expenses-Institutions Adult Literacy Grants $ 4,129,044.00 $ 3,980,952.61 $ 2,457,120.00 1,903,762.21 840,049.00 831,138.26 148,091.39 553,357.79 8,910.74 $ 7,426,213.00 $ 6,715,853.08 $ _ _...:.7_10-'-,...:.35...:.9...:.9.=..2 Excess of Funds Available over Expenditures $ 163,793.96 $ ===1=6=3=,7=9==:3.=96= -3- MIDDLE GEORGIA TECHNICAL INSTITUTE SCHEDULE OF FUNDS AVAILABLE AND EXPENDITURES COMPARED TO BUDGET BUDGET FUND "B" LOTTERY FOR EDUCATION YEAR ENDED JUNE 30,1997 EXHIBIT"C" FUNDS AVAILABLE REVENUES State Appropriations BUDGET ACTUAL VARIANCE FAVORABLE (UNFAVORABLE) $ 6,195,513.00 $ 6,195,448.00 $ -6...;..5-'-.0_0 EXPENDITURES Equipment-Technical Institutes Excess of Funds Available over Expenditures - - - - - - $ 6,195,513.00 $ 6,195,448.00 $ 65.00 $ 0.00 $ ======0==:.0=0 -4- SECTION II AUDITEE'S RESPONSE TO PRIOR YEAR FINDINGS AND QUESTIONED COSTS MIDDLE GEORGIA TECHNICAL INSTITUTE AUDITEE'S RESPONSE SUMMARY SCHEDULE OF PRIOR YEAR FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 1997 PRIOR YEAR FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS FINDING CONTROL NUMBER AND STATUS 836-94-04 836-96-01 Previously Reported Corrective Action Implemented Previously Reported Corrective Action Implemented PRIOR YEAR FEDERAL AWARDS FINDINGS AND QUESTIONED COSTS FINDING CONTROL NUMBER AND STATUS 836-95-04 836-96-01 Unresolved -See Corrective Action/Responses Previously Reported Corrective Action Implemented CORRECTIVE ACTIONIRESPONSES ALLOWABLE COSTS/COST PRINCIPLES Time and Attendance Records Not Utilized Job Training Partnership Act (CFDA No. 17.250) Vocational Education - Basic Grants to States (CFDA No. 84.048) Questioned Cost: $13,951.40 Finding Control Number 836-95-04 During the fiscal year, the Institute contacted the grantor agency regarding resolution of the fmding, however, an official resolution has not been received. SECTION III CURRENT YEAR FINDINGS AND QUESTIONED COSTS MIDDLE GEORGIA TECHNICAL INSTITUTE SCHEDULE OF FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 1997 FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS EMPLOYEE COMPENSATION Salary Overpayment Questioned Cost: $1,224.00 Finding Control Number: FA-836-97-01 For the year under review, a sample of twenty payroll transactions disclosed that Middle Georgia Technical Institute overpaid an employee in the amount of $1,224.00. The overpayment was the result of duplicate payment for work performed. The Institute should implement internal control procedures to ensure duplicate payments are not made for work performed. Reimbursement of $1,224.00 should be secured from the employee and deposited to the Institute's Budget Fund.