r ', STATE OF ,GE'<:)RGI-A ... ' ' - V .,,,. ~ DEPART-MENT OF AUDITS AND ACCOUNTS, . - ' . \ ...! -g ~ ~- ~ - . .,~ MANAGEMENT REPORT ~ COLUMBUS TECHNICALCQLLEGE . . ' .... - . :II w COLUMBUS, GEORGIA.,-.-. _, ':fa AN ORGANIZATIONAL UNIT Of THE STATE ;OF GEORGIA-:~' r .,_. YEAR ENDED JUNE 30, 2002 ~ -I - - Russell W. Hinton ... -) I . State Auditor tit a~ . - - . ' COLUMBUS TECHNICAL COLLEGE MANAGEMENT REPORT -TABLE OF CONTENTS- LETTER OF TRANSMITTAL SELECTED FINANCIAL INFORMATION EXHIBITS A ANALYSIS OF CHANGES IN FUND BALANCE BUDGETFUND 1 B SCHEDULEOFFUNDSAVAILABLEANDEXPENDITURES COMPARED TO BUDGET BUDGET FUND "A" DEPARTMENT OF TECHNICAL AND ADULT EDUCATION 2 C RECONCILIATION OF SALARIES AND TRAVEL 3 RussE1.L \V. Hl'liTO~ STATE AUDITOR (404) 656-2174 DEPARTMENT OF AUDITS AND ACCOUNTS 254 Washington Street. S W. Su11c 214 Atlanta, Georgia 30334-8400 November 4, 2002 Honorable Roy E. Barnes, 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 J. Robert Jones, President Columbus Technical College Ladies and Gentlemen: As part ofour audit ofthe statutory basis financial statements ofthe State ofGeorgia presented in the State of Georgia Report of the State Auditor, the financial statements of the State of Georgia presented in the State ofGeorgia Comprehensive Annual Financial Report, and the issuance of a Statewide Single Audzt Report pursuant to the Single Audit Act Amendments, as of and for the year ended June 30, 2002, we have performed certain audit procedures at Columbus Technical College. Accordingly, the financial statements and compliance activities ofColumbus Technical College were examined to the extent considered necessary in order to express an opinion as to the fair presentation ofthe 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 College as of and for the year ended June 30, 2002. The particular information provided is enumerated in the Table of Contents. This report is intended solely for the information and use ofmanagement and members ofthe Local Board ofDirectors of Columbus Technical College and is not intended to be and should not be used by anyone other than these specified parties. Respectfully submitted, ~~ RWH:as SELECTED FINANCIAL INFORMATION COLUMBUS TECHNICAL COLLEGE ANALYSIS OF CHANGES IN FUND BALANCE BUDGET FUND YEAR ENDED JUNE 30, 2002 EXHIBIT"A" FUND BALANCE - JULY 1, 2001 Reserved Surplus ADDITIONS AdJustments to Prior Year's Contracts and Accounts Payable Excess of Funds Available over Expenditures Exh1b1t "B" DEDUCTIONS Unreserved Fund Balance (Surplus) Returned to Georgia Department of Technical and Adult Education - Admin1strat1ve Central Office Year Ended June 30, 2001 Adjustments to Prior Year's Accounts Receivable Refunds to Grantors Federal Financial Assistance Georgia Department of Technical and Adult Education - Administrative Central Office Other Reserved Fund Balance Camed Over from Pnor Year as Funds Available FUND BALANCE - JUNE 30, 2002 SUMMARY OF FUND BALANCE Reserved Live Work Proiects PnorYearLocalFunds Pnvate Grant Surplus - 1- "All DEPARTMENT OF TECHNICAL AND ADULT EDUCATION "B" LOTTERY FOR EDUCATION $ 139,755.16 42972 $ 2 888 14 $ 140 184 88 $ 2 888 14 $ 1,334.64 128,650.48 $ 129,985 12 $ 42972 $ 2,888 14 192 73 652 97 1,892.37 137.209 82 $ 140 377 61 s 2.888 14 $ 129.792 39 $======0..0.~0 $ 37,639.76 17.335 94 74 816 69 $ 129,792 39 ooo s _ _ _ _ _---=-o~o.:::..o $ 129,792 39 $=====-==o,;;;o~o COLUMBUS TECHNICAL COLLEGE SCHEDULE OF FUNDS AVAILABLE AND EXPENDITURES COMPARED TO BUDGET BUDGET FUND "A" DEPARTMENT OF TECHNICAL AND ADULT EDUCATION YEAR ENDED JUNE 30. 2002 EXHIBIT"B" FUNDS AVAILABLE REVENUES State Appropriation Federal Revenues Other Revenues Retained CARRY-OVER FROM PRIOR YEAR Transfer from Reserved Fund Balance BUDGET ACTUAL VARIANCEFAVORABLE (UNFAVORABLE) $ 7,634,936.00 $ 7,634,936.00 $ 1,774,119.00 1,151,741.23 4,302,663.00 4,109,895 47 $ 13,711,718.00 $ 12,896,572 70 $ 000 -622,377.77 -192,767 53 -815,145 30 0 00 137.209 82 137,209.82 S 13,711,718 00 $ 13,033,782.52 $ _ _ _-6.;._7_7.;...,9_3_5_48c.... EXPENDITURES Personal Services - Institutions Operating Expenses - Institutions Capital Outlay $ 10,004,446 00 S 3,524,957.00 182,315 00 9,884,11643 $ 2,838,700.61 182,315 00 120,329.57 686,256.39 000 $ 13,711,718 00 $ 12,905,132.04 $ _ _ _80_6""'-,5_8_5.;_9..;_6 Excess of Funds Available over Expenditures s 128,650.48 S====12=8=.6=5=0~4;::;,8 -2- COLUMBUS TECHNICAL COLLEGE RECONCILIATION OF SALARIES AND TRAVEL YEAR ENDED JUNE 30, 2002 EXHIBIT"C" Totals per Annual Supplement Accruals June 30, 2001 June 30, 2002 Compensated Absences June 30, 2001 June 30, 2002 SALARIES TRAVEL $ 8,124,910.62 $ 76,745.11 -48,920.84 62,515.10 -565,784.52 558,742.70 $ 8,131,46306 $ 76,745.11 -3-