Management report, Chattahoochee Technical College, Marietta, Georgia, an organizational unit of the state of Georgia, year ended June 30, 2005

STATE OF GEORGIA DEPARTMENT OF AUDITS AND ACCOUNTS
MANAGEMENT REPORT CHATTAHOOCHEE TECHNICAL COLLEGE
MARIETTA, GEORGIA
AN ORGANIZATIONAL UNIT OF THE STATE OF GEORGIA YEAR ENDED JUNE 30, 2005 Russell W. Hinton State Auditor

CHATTAHOOCHEE TECHNICAL COLLEGE - TABLE OF CONTENTS -

SECTION I

FINANCIAL

LETTER OF TRANSMITTAL

SELECTED FINANCIAL INFORMATION

EXHIBITS

A BALANCE SHEET - (STATUTORY BASIS) - BUDGET FUND

"A" DEPARTMENT OF TECHNICAL AND ADULT EDUCATION

3

B ANALYSIS OF CHANGES IN FUND BALANCE-(STATUTORY BASIS)

BUDGET FUND

"A" DEPARTMENT OF TECHNICAL AND ADULT EDUCATION

4

C STATEMENT OF FUNDS AVAILABLE AND EXPENDITURES

COMPARED TO BUDGET - (STATUTORY BASIS)

BUDGET FUND

"A" DEPARTMENT OF TECHNICAL AND ADULT EDUCATION

5

D RECONCILIATION OF SALARIES AND TRAVEL

7

SECTION II FINDINGS AND QUESTIONED COSTS SCHEDULE OF FINDINGS AND QUESTIONED COSTS

SECTION I FINANCIAL

Russell W. Hinton
STATE AUDITOR
(404) 656-2174

DEPARTMENT OF AUDITS AND ACCOUNTS
270 Washington Street, S.W., Suite 1-156 Atlanta, Georgia 30334-8400
September 22, 2005

Honorable Sonny Perdue, 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 Harlon Crimm, President Chattahoochee Technical College

Ladies and Gentlemen:

As part ofour audit ofthe statutory basis financial statements ofthe State ofGeorgia presented in the State ofGeorgia Report ofthe State Auditor, the basic financial statements of the State of Georgia presented in the State ofGeorgia Comprehensive Annual Financial Report, and the issuance of a State ofGeorgia Single Audit Report pursuant to the Single Audit Act Amendments, as ofand for the year ended June 30, 2005, we have performed certain audit procedures at Chattahoochee Technical College. Accordingly, the financial statements and compliance activities of Chattahoochee Technical College were examined to the extent considered necessary in order to express an 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 Chattahoochee Technical College as ofand for the year ended June 30, 2005. Information contained in this report is a by-product of our engagement that is the representation of management, and accordingly, we do not express an opinion or any other form of assurance on it. 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 of Directors of Chattahoochee Technical College and is not intended to be and should not be used by anyone other than these specified parties.

RWH:as

Respectfully submitted,
~utc!lh Russell W. Hinton State Auditor

SELECTED FINANCIAL INFORMATION - 1-

CHATTAHOOCHEE TECHNICAL COLLEGE BALANCE SHEET- (STATUTORY BASIS)
BUDGET FUND "A" DEPARTMENT OF TECHNICAL AND ADULT EDUCATION
JUNE 30. 2005

EXHIBIT"A"

ASSETS
Cash and Cash Equivalents Accounts Receivable
Federal Financial Assistance Other
Total Assets
LIABILITIES AND FUND EQUITY
Liabilities Accrued Payroll Accounts Payable Deferred Revenue Other Liabilities
Total Liabilities
Fund Balances Reserved Local Grants and Contracts Live Work Projects Uncollectible Accounts Unreserved Undesignated Surplus Regular
Total Fund Equity
Total Liabilities and Fund Equity

$ 2.148.189.52 230,635.67 79,440.37
$ 2.458.265.56

$

28.813.95

1.512.681.78

558.535.12

123.295.90

$ 2,223,326.75

$

82.882.45

106.661.28

23.364.01

22,031.07 $ 234,938.81

$ 2,458,265.56

Statutory Basis financial information was prepared on a prescribed basis of accounting that demonstrates compliance with budgetary statutes and regulations of the State of Georgia, which is a comprehensive basis of accounting other than generally accepted accounting principles.
-3 -

CHATTAHOOCHEE TECHNICAL COLLEGE ANALYSIS OF CHANGES IN FUND BALANCE - (STATUTORY BASIS)
BUDGET FUND "A" DEPARTMENT OF TECHNICAL AND ADULT EDUCATION
YEAR ENDED JUNE 30, 2005

EXHIBIT"B"

FUND BALANCE - JULY 1, 2004
Reserved Surplus
ADDITIONS
Excess of Funds Available over Expenditures Exhibit "C"
DEDUCTIONS
Unreserved Fund Balance (Surplus) Returned to Georgia Department of Technical and Adult Education - Administrative Central Office Year Ended June 30, 2004
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 Carried Over from Prior Year as Funds Available
FUND BALANCE - JUNE 30, 2005

$

239,791.08

94,190.20

$

333,981.28

$

252,791.71

$

94,190.20

137,699.12

8,060.97 1.68

111,882.21

$

351,834.18

$ ====2=3=4,=9=38==81=

Statutory Basis financial information was prepared on a prescribed basis of accounting that demonstrates compliance with budgetary statutes and regulations of the State of Georgia, which is a comprehensive basis of accounting other than generally accepted accounting principles.
-4-

CHATTAHOOCHEE TECHNICAL COLLEGE STATEMENT OF FUNDS AVAILABLE AND EXPENDITURES
COMPARED TO BUDGET- (STATUTORY BASIS} BUDGET FUND
"A" DEPARTMENT OF TECHNICAL AND ADULT EDUCATION YEAR ENDED JUNE 30. 2005

EXHIBIT"C"

FUNDS AVAILABLE REVENUES
State Appropriation Federal Revenues Other Revenues Retained
CARRY-OVER FROM PRIOR YEAR Transfer from Reserved Fund Balance
EXPENDITURES Personal Services - Institutions Operating Expenses - Institutions
Excess of Funds Available over Expenditures

BUDGET

ACTUAL

VARIANCEFAVORABLE (UNFAVORABLE)

$ 10.792.759.00 $ 10,792,759.00 $

1,008,156.58

850,788.97

7,459,374.04

7,169,903.25

$ 19,260,289.62 $ 18,813,451.22 $

0.00 -157,367.61 -289 470.79
-446,838.40

0.00

111,882.21

111,882.21

$ 19,260,289.62 $ 18,925,333.43 $ _ _ _--=--33=---4'-'-',9:..:5--=-6'-'.1--=---9

$ 14,475,368.88 $ 14,177,659.88 $

4,784,920.74

4,494,881.84

297,709.00 290,038.90

$ 19,260,289.62 $ 18,672,541.72 $ _ _ _5.:._8;_7..:..,7_4_7._90_

$

252,791.71 $==~25~2,la:7~9~1~.7,,;,.1

Statutory Basis financial information was prepared on a prescribed basis of accounting that demonstrates compliance with budgetary statutes and regulations of the State of Georgia, which is a comprehensive basis of accounting other than generally accepted accounting principles.
-5-

CHATTAHOOCHEE TECHNICAL COLLEGE RECONCILIATION OF SALARIES AND TRAVEL
YEAR ENDED JUNE 30, 2005

EXHIBIT"D"

Totals per Annual Supplement
Accruals June 30, 2004 June 30, 2005
Compensated Absences June 30, 2004 June 30, 2005
Agency Funds
Adjustments Shared Services on Jointly Staffed Personnel Kennesaw State University Cheshier, Stephen
Totals per GMP Basis as Reported in the Consolidated Annual Financial Report

SALARIES

TRAVEL

$ 11,808,367.56 $ 157,070.16

-33,499.99 28,813.95

-723, 113.48 834,822.03
-53,886.00

-28,500.00

$ 11,833,004.07 $ 157,070.16

-7-

SECTION II FINDINGS AND QUESTIONED COSTS

CHATTAHOOCHEE TECHNICAL COLLEGE SCHEDULE OF FINDINGS AND QUESTIONED COSTS
YEAR ENDED JUNE 30, 2005
FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS No matters were reported. FEDERAL AWARD FINDINGS AND QUESTIONED COSTS No matters were reported.