Management report, West Georgia Technical Institute, LaGrange, Georgia, an organizational unit of the state of Georgia, year ended June 30, 1997

,011
A~tJO
.~J Vb
1JV1
/QQ(,-Q7
MANAGEMENT REPORT WEST GEORGIA TECHNICAL INSTITUTE
LAGRANGE, 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

WEST GEORGIA 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 AUDITEE'S RESPONSE TO PRIOR YEAR FINDINGS AND QUESTIONED COSTS SUMMARY SCHEDULE OF PRIOR YEAR FINDINGS AND QUESTIONED COSTS

SECTION ill 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 20, 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 William Sellers, President West Georgia Technical Institute
Ladies and Gentlemen:
As part of our audit of the statutory basis fmancial 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 of and for the year ended June 30, 1997, we have performed certain audit procedures at West Georgia Technical Institute. Accordingly, the financial statements and compliance activities of West 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 West 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 West Georgia Technical Institute. However, this report is a matter of public record and its distribution is not limited.
Respectfully submitted,
~~
Claude L. Vickers State Auditor
CLV:cm

SECTION I SELECTED FINANCIAL INFORMATION

WEST GEORGIA 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 ExhibitlB" Exhibit"C"
DEDUCTIONS
Unreserved Fund Balance (Surplus) Retumed to Georgia Department of Technical and Adult Education Administrative Central Office Year Ended June 30, 1996
Adjustments to Prior Year's Accounts Receivable Refunds to Grantors
Georgia Department of Technical and Adult Education - Administrative Central Office Federal Financial Assistance Questioned Costs
U. S. Department of Health and Human Services Federal Financial Assistance
U.S.DepartmentofLabor Federal Financial Assistance
Reserved Fund Balance Carried Over from Prior Year as Funds Available

"A" DEPARTMENT OF
TECHNICAL AND ADULT EDUCATION

"B" LOTTERY FOR
EDUCATION

TOTAL

$

79,180,11

$

79,180.11

$

2,783.35

2,783.35

$

79,180.11 $

2,783.35 $

81,963.46

$

10,113.44 $

1,067.99 $

11,181.43

26,136.49

0.00

26,136.49 0.00

$

36,249.93 $

1,067.99 $

37,317.92

$

2,783.35 $

2,783.35

$

1,111.47

1,111.47

11.76 13,672.00

11.76 13,672.00

84.04

84.04

2.58

2.58

8,918.50

8,918.50

$

23,800.35 $

2,783.35 $

26,583.70

FUND BALANCE - JUNE 30, 1997

$

91,629.69 $

1,067.99 $ ===92=,=69=7=.6=8

SUMMARY OF FUND BALANCE
Reserved Federal Financial Assistance For Refund to Georgia Department of Technical and Adult Education - Administrative Central Office For Other Live Work Projects Prior Year Local Funds
Surplus

$

163.83

$

163.83

757.49

757.49

4,339.06

4,339.06

4,043.57

4,043,57

82,325.74 $

1,067.99

83;393.73

$ -2-

91,629.69 $

1,067.99 $ ===92=,6=9=7=.6=8

WEST 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

VARIANCEFAVORABLE (UNFAVORABLE)

$ 3,890,872.00 $ 3,890,624.96 $

651,871.00

588,791.52

1,264,478.00

1,279,453.86

$ 5,807,221.00 $ 5,758,870.34 $

-247.04 -63,079.48 14,975.86
-48,350.66

4,044.00

8,918.50

4,874.50

$ 5,811,265.00 $ 5,767,788.84 $

-4_3-'-,4_7_6._16_

EXPENDITURES
Personal Services-Institutions Operating Expenses-Institutions Quick Start Program Adult Literacy Grants Job Training Partnership Act

$ 4,072,667.00 $ 4,049,686.05 $

1,240,671.00

1,194,789.71

1,831.00

1,830.96

472,254.00

475,782.81

23,842.00

19,562.82

22,980.95 45,881.29
0.04 -3,528.81 4,279.18

$ 5,811,265.00 $ 5,741,652.35 $

69-,-,6_1_2_.6_5

Excess of Funds Available over Expenditures

$

26,136.49 $ =======2=6:6,1::;;3=6.=4=9

-3-

WEST 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)

$

39,210.00 $

39,210.00 $

....;..O....;..O~O

EXPENDITURES Equipment-Technical Institutes

$

39,210.00 $

39,210.00 $

0._0_0

Excess of Funds Available over Expenditures

$

0.00 $ =====0...0...:::0

-4 -

WEST GEORGIA TECHNICAL INSTITUTE RECONCILIATION OF SALARIES AND TRAVEL
YEAR ENDED JUNE 30,1997

EXHIBIT"D"

Totals per Annual Supplement
Accruals June 30,1997 June 30, 1996

SALARIES $ 3,525,397.86 $

TRAVEL 44,735.24

57,131.35 -26,126.95

0.00 -1,959.97

$ 3,556,402.26 $ ======4=:2,=77==5=:.2=7

- 5-

SECTIONll AUDlTEE'S RESPONSE TO PRIOR YEAR FINDINGS AND QUESTIONED COSTS

WEST 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

819-96-01 819-96-03 819-96-04

Unresolved - See Corrective ActionlResponses Unresolved - See Corrective ActionlResponses Previously Reported Corrective Action Implemented

CORRECTIVE ACTIONIRESPONSES

ACCOUNTING CONTROLS (OVERALL) Inadequate Separation of Duties Finding Control Number 819-96-01

The Institute is implementing appropriate procedures to satisfy the separation of duties requirement. In the areas of expenditures, liabilities and cash disbursements and bank reconciliations, the Institute has evaluated job functions and reassigned staff persons in these areas. By the end of the current fiscal year, complete resolution of this finding will be obtained.

CASH AND CASH EQUIVALENTS Inadequate Accounting Procedures Finding Control Number 819-96-03

The Institute implemented a corrective action plan, but did not correct the deficiency and the stated condition remains. The monthly payroll bank statements were reconciled for each month by June 30. Numerous adjustments were necessary to reconcile the operating bank account and the federal bank account.

The Institute is implementing appropriate procedures and controls to ensure that all reconciling items are identified and corrected each month. All unresolved reconciling items from prior year audit will be addressed in the current year.

PRIOR YEAR FEDERAL AWARDS FINDINGS AND QUESTIONED COSTS

FINDING CONTROL NUMBER AND STATUS

819-96-02 819-96-05 819-96-06

. Unresolved - See Corrective ActionlResponses Unresolved - See Corrective ActionlResponses Previously Reported Corrective Action Implemented

- 1-

WEST GEORGIA TECHNICAL INSTITUTE AUDITEE'S RESPONSE
SUMMARY SCHEDULE OF PRIOR YEAR FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 1997
PRIOR YEAR FEDERAL AWARDS FINDINGS AND QUESTIONED COSTS CORRECTIVE ACTIONIRESPONSES CASH MANAGEMENT Excessive Cash Balances Finding Control Number 819-96-02 The Institute implemented a corrective action plan, but did not correct the deficiency and the stated condition remains. Reorganization and the reassigning ofjob responsibilities in some areas will enable the Institute to resolve this finding and adequately forecast the cash needs ofthe program. FEDERAL FINANCIAL REPORTS Federal Cash Transactions Report Not Reconciled Finding Control Number 819-96-05 The Institute implemented a corrective action plan, but did not correct the deficiency and the stated condition remains. The Institute notes that the resolution of the cash and cash equivalents administrative requirement finding will aide in providing adequate detail for the reconciliation of this report.
-2-

SECTION ill CURRENT YEAR FINDINGS AND QUESTIONED COSTS

WEST GEORGIA TECHNICAL INSTITUTE SCHEDULE OF FINDINGS AND QUESTIONED COSTS
YEAR ENDED JUNE 30, 1997
FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS
CASH AND CASH EQUIVALENTS Inadequate Accounting Procedures Finding Control Number: FS-819-97-01
For the year under review, it was noted that the Institute's accounting procedures did not provide adequate internal control over the bank reconciliation process. The accounting procedures related to cash were found to be deficient as follows:
(1) The monthly bank statements for the operating and federal accounts were not reconciled properly for any month of the fiscal year. Adjustments were necessary to correct the accounting records as of June 30, 1997.
(2) Book errors disclosed through the bank reconciliation process were carried as reconciling items for extended periods of time.
These conditions occurred because management did not implement appropriate procedures and controls to ensure that all bank statements were reconciled to the general ledger on a timely basis and that reconciling items were identified and corrected promptly.
The Institute should implement appropriate procedures and controls to ensure that all bank statements are reconciled to thegeneral ledger on a timely basis and that reconciling items are identified and corrected promptly. The Institute should establish procedures which ensure that cash and cash equivalents are adequately safeguarded.