MANAGEMENT REPORT COLUMBUS TECHNICAL INSTITUTE
COLUMBUS, 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
COLUMBUS TECHNICAL INSTITUTE MANAGEMENT REPORT - TABLE OF CONTENTS -
LETTER OF TRANSMITTAL
SECTION I
SELECTED FINANCIAL INFORMATION
EXHIBITS
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
D RECONCILIATION OF SALARIES AND TRAVEL
5
SECTIONll 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
November 14, 1997
Honorable Zell Miller, Governor Members ofthe General Assembly of Georgia Members ofthe State Board of Technical and Adult Education Members ofthe Local Board of Directors
and Honorable Eugene Demonet, President Columbus Technical Institute
Ladies and Gentlemen:
As part of our audit ofthe statutory basis financial statements of the State of Georgia presented in the Report ofthe State Auditor, the general purpose fmancial 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 Columbus Technical Institute. Accordingly, the financial statements and compliance activities of Columbus 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 Columbus Technical Institute as ofand 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 Columbus Technical Institute. However, this report is a matter of public record and its distribution is not limited.
Respectfully submitted,
CLV:cm
Claude L. Vickers State Auditor
SECTION I SELECTED FINANCIAL INFORMATION
COLUMBUS TECHNICAL INSTITUTE ANALYSIS OF CHANGES IN FUND BALANCE
BUDGET FUND YEAR ENDED JUNE 3D. 1997
EXHIBIT "A"
FUND BALANCE - JULY 1, 1996
Reserved Surplus
ADDITIONS
Adjustments to Prior Year's Accounts Payable Excess of Funds Available over Expenditures
Exhibit"B" Exhibit"C" Reimbursement of Prior Year's Expenditures
DEDUCTIONS
Unreserved Fund Balance (SurplUS) Returned to Georgia Department of Technical and Adult Education - Administrative Central Office Year Ended June 30,1996
Adjustments to Prior Year's Accounts Receivable Refund to Grantor
Muscogee County School District Tech-Prep Education
Reserved Fund Balance Carried Over from Prior Year as Funds Available
"A" DEPARTMENT OF
TECHNICAL AND ADULT EDUCATION
"B" LOTTERY FOR
EDUCATION
TOTAL
$
36,778,02
$
36,778,02
49,31 $
61,63
110,94
$
36,827,33 $
61,63 $
36,888,96
$
7,643,14
23,662,58 $
2,289,97
$
33,595,69 $
$ 0,00 0.00 $
7,643,14
23,662,58 0.00
2,289,97
33,595,69
$
49,31 $
3,115.70
28,77
36,778.02
$
39,971.80 $
61.63 $ 61,63 $
110.94 3,115.70
28.77 36,778.02 40,033.43
FUND BALANCE - JUNE 30,1997
$
30,451.22 $
0.00 $ ===30:=.,4=5:=1=.2=::2
SUMMARY OF FUND BALANCE
Reserved Federal Financial Assistance For Expired Grant Balances Live Work Projects Prior Year Local Funds Private Grants
Surplus
$
42.02
10,526.05
19,324.49
558,66
0.00 $
$ 0.00
42.02 10,526.05 19,324.49
558.66 0.00
$ -2-
30,451,22 $
0.00 $ ===30:=,4:::5=1::::,2=:2
COLUMBUS 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"
EXPENDITURES Personal Services-Institutions Operating Expenses-Institutions Quick Start Program Job Training Partnership Act
Excess of Funds Available over Expenditures
$ 8,790,069,00 $ 8,687,605.08 $ _ _..;-1..;,02;;.:,4..;.,.6;.;3.;.,;.9_2
$ 7,119,006.00 $ 7,090,727.76 $
1,586,384.00
1,491,833.41
55,631.00
53,588.70
29,048.00
27,792.63
28,278.24 94,550.59 2,042.30
1,255.37
$ 8,790,069.00 $ 8,663,942.50 $
1. ; ,.26; .:,.,1.;,. 2. .; .,6....;;.,50_
$
23,662.58 $ =======2=3=,6=6=2..5...=8
-3-
COLUMBUS 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
VARIANCEFAVORABLE (UNFAVORABLE)
$ 125,273.00 $ 125,273,00 $
..:.~,O~O
EXPENDITURES Equipment-Technical Institutes
$ 125,273.00 $ 125,273,00 $
..:.O..:..O~O
Excess of Funds Available over Expenditures
$
0.00 $ =======0=,0=0
-4 -
COLUMBUS TECHNICAL INSTITUTE RECONCILIATION OF SALARIES AND TRAVEL
YEAR ENDED JUNE 3D. 1997
EXHIBIT"D"
Totals per Annual Supplement
Accruals
June 3D, 1997 June 3D, 1996
SALARIES
$ 5,674,702.21 $
TRAVEL
35,160.11
16,911.04 -6,367.50
944.14 -69.00
$ 5,685,245.75 $ ===3~6,=03=5=.2=5
- 5-
SECTIONll CURRENT YEAR FINDINGS AND QUESTIONED COSTS
COLUMBUS TECHNICAL INSTITUTE SCHEDULE OF FINDINGS AND QUESTIONED COSTS
YEAR ENDED JUNE 30, 1997
FINANCIAL STATEMENT FINDINGS AND QUESTIQNED COSTS
GENERAL FIXED ASSETSIPROPERTY MANAGEMENT Inadequate Property Management Procedures Finding Control Number: FS-828-97-01
For the year under review, our examination included a review ofthe controls utilized by Columbus Technical Institute in maintaining their State Property System. This review also included testing the system for compliance with State laws and regulations. A number of conditions relating to inappropriate accounting practices were found to exist and have been identified in detail within the Federal Awards Findings and Questioned Costs, fmding number FA-828-97-01.
The Institute is required to maintain equipment inventories in accordance with the State Property Management System Manual. The discrepancies identified were caused by the Institute's failure to follow these guidelines for maintaining equipment inventories.
The Institute should establish the necessary internal controls to ensure that equipment inventories are maintained in accordance with the State Property Management System Manual.
FEDERAL AWARDS FINDINGS AND QUESTIONED COSTS
EQUIPMENT AND REAL PROPERTY MANAGEMENT Inadequacies in Operation of Property Management System Finding Control Number: FA-828-97-01
For the year under review, our examination included a review of the controls utilized by Columbus Technical Institute in maintaining their property management system. This review also included testing the system for compliance with Federal laws and regulations. The following conditions relating to inappropriate accounting practices were found to exist:
(1) Equipment pmchases were not updated to the PROPS (property Records System). (2) Equipment activity reflected in the FACS (Fiscal Accounting Control System) was not reconciled
to the PROPS. (3) A physical inventory has not been conducted within the last two years.
The Institute is required to maintain equipment inventories in accordance with provisions of paragraph 32 of QMB's Uniform Administrative Requirements for Grants and Cooperative Agreements to State and Local Governments (Common Rule). The discrepancies identified above were caused by the Institute's failure to follow guidelines for maintaining equipment inventories.
- 1-
COLUMBUS TECHNICAL INSTITUTE SCHEDULE OF FINDINGS AND OUESTIONED COSTS
YEAR ENDED JUNE 30, 1997 FEDERAL AWARDS FINDINGS AND QUESTIONED COSTS EQUIPMENT AND REAL PROPERTY MANAGEMENT Inadequacies in Operation ofPruperty Management System Finding Control Number: FA-828-97-01 The Institute should establish the necessary controls to ensure that equipment inventories are maintained in accordance with provisions of QMB's Common Rule and the State Property Management System Manual. Federal Programs/Awards Affected: Education, U. S. Department of
Vocational Educational - Basic Grants to States - CFDA No. 84.048
-2-