Management report, Atlanta Technical College, Atlanta, Georgia, an organizational unit of the state of Georgia, year ended June 30, 2008

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

ATLANTA TECHNICAL COLLEGE - TABLE OF CONTENTS -

SECTION I

FINANCIAL

LETTER OF TRANSMITTAL

SELECTED FINANCIAL INFORMATION

EXHIBITS

A STATEMENT OF NET ASSETS- (GAAP BASIS)

2

B STATEMENT OF REVENUES, EXPENSES AND CHANGES IN NET ASSETS-

(GAAP BASIS)

3

C STATEMENT OF CASH FLOWS- (GAAP BASIS)

5

D SELECTED FINANCIAL NOTES

6

SUPPLEMENTARY INFORMATION

SCHEDULES

1 BALANCE SHEET- (STATUTORY BASIS)- BUDGET FUND

16

2 SUMMARY BUDGET COMPARISON AND SURPLUS ANALYSIS REPORT

(STATUTORY BASIS) BUDGET FUND

17

3 STATEMENT OF PROGRAM REVENUES AND EXPENDITURES BY FUNDING

SOURCE COMPARED TO BUDGET

(STATUTORY BASIS) BUDGET FUND

18

4 RECONCILIATION OF SALARIES AND TRAVEL

21

SECTION II FINDINGS, QUESTIONED COSTS AND OTHER ITEMS SCHEDULE OF FINDINGS, QUESTIONED COSTS AND OTHER ITEMS

SECTION I FINANCIAL

Russell W. Hinton
STATE AUDITOR
(404) 6562174

DEPARTMENT OF AUDITS AND ACCOUNTS
270 Washington Street, S.W., Suite 1-156 Atlanta, Georgia 30334-8400
November 25, 2008

Honorable Sonny Perdue, Governor Members of the General Assembly of Georgia Members of the State Board of Technical and Adult Education Members ofthe Local Board of Directors
and Honorable Alvetta Thomas, President Atlanta Technical College
Ladies and Gentlemen:
As part ofour audit ofthe basic financial statements ofthe State ofGeorgia presented in the State of Georgia Comprehensive Annual Financial Report and the issuance of a State of Georgia Single Audit Report pursuant to the Single Audit Act Amendments, as of and for the year ended June 30, 2008, we have performed certain audit procedures at Atlanta Technical College. Accordingly, the financial statements and compliance activities of Atlanta 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 Atlanta Technical College as of and for the year ended June 30, 2008. Information contained in this report is a by-product of our audit ofthe basic financial statements ofthe State of Georgia and is the representation of management. Accordingly, we do not express an opinion or any other form of assurance on it. The particular information provided which includes a section on findings and other items reported in accordance with Commission on Colleges regulation 2.11.1, is enumerated in the Table of Contents.

This report is intended solely for the information and use of management of Atlanta Technical College, members of the Local Board of Directors, and the Southern Association of Colleges and Schools - Commission on Colleges and is not intended to be and should not be used by anyone other than these specified parties.

Respectfully submitted,

.

~~~-~

~ulsell W. Hinton, CPA, CGFM

State Auditor

RWH:gp

SELECTED FINANCIAL INFORMATION - 1-

ATLANTA TECHNICAL COLLEGE STATEMENT OF NET ASSETS- (GAAP BASIS)
JUNE 30, 2008
ASSETS
Current Assets Cash and Cash Equivalents Accounts Receivable, Net Federal Financial Assistance Other Prepaid Items Inventories
Total Current Assets
Noncurrent Assets Capital Assets, Net
Total Assets
LIABILITIES
Current Liabilities Salaries Payable Accounts Payable Deferred Revenue Funds Held for Others Compensated Absences
Total Current Liabilities
Noncurrent Liabilities Compensated Absences
Total Liabilities
NET ASSETS
Invested in Capital Assets, Net of Related Debt Restricted for:
Expendable Unrestricted
Total Net Assets

EXHIBIT"A"

$

2,776,699.45

317,965.61 526,918.29
12,838.50 503,003.27

$

4,137,425.12

13,498,101.64
$ 17,635,526.76

$

93,008.99

1,714,923.97

69,095.65

266,557.04

520,118.76

$

2,663, 704.41

535,223.63

$

3,198,928.04

$ 13,498,101.64
4,125.59 934!371.49

$ 14,436,598.72

-2-

ATLANTA TECHNICAL COLLEGE STATEMENT OF REVENUES, EXPENSES AND CHANGES IN NET ASSETS- (GAAP BASIS)
YEAR ENDED JUNE 30, 2008

EXHIBIT"B"

OPERATING REVENUES
Student Tuition and Fees Less: Scholarship Allowances
Grants and Contracts Federal
Rents and Royalties Sales and Services of Educational Departments Other Operating Revenues
Total Operating Revenues
OPERATING EXPENSES
Salaries Benefits Travel Scholarships and Fellowships Utilities Supplies and Other Services Depreciation
Total Operating Expenses
Operating Income (Loss)
NONOPERATING REVENUES (EXPENSES)
State Appropriations Grants and Contracts
Federal State Expenses Gifts Interest and Other Investment Income Other Nonoperating Revenues/Expenses
Net Nonoperating Revenues
Income (Loss) Before Other Revenues, Expenses, Gains, or Losses
Capital Grants and Gifts Gain/Loss on Disposal of Capital Asset
Increase (Decrease) in Net Assets
Net Assets - Beginning of Year
Net Assets - End of Year

$

5,194,061.13

-594,089.75

3,180,587.98 115,924.00
1,472,669.94 30 346.00

$

9,399,499.30

$

12,549,654.93

3,906,038.84

105,458.09

2,461,384.19

706,969.09

6,210,137.25

838 675.16

$

26,778,317.55

$

-17,378,818.25

$

15,586,610.40

1,703,657.69 840,864.72 -700,000.00 74,804.41 45,399.09 -392,482.82

$

17,158,853.49

$

-219,964.76

-14 521.65

$

-234,486.41

14,671,085.13

$ ==1=4,6;,4=360,5=9=8.=72~

- 3-

(This page left intentionally blank)

ATLANTA TECHNICAL COLLEGE STATEMENT OF CASH FLOWS- (GAAP BASIS)
YEAR ENDED JUNE 30, 2008
CASH FLOWS FROM OPERATING ACTIVITIES Tuition and Fees Grants and Contracts Sales and Services of Educational Departments Payments to Suppliers Payments to Employees Payments for Scholarships and Fellowships Other Receipts (Payments)
Net Cash Provided (Used) by Operating Activities
CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES State Appropriations Agency Funds Transactions Gifts and Grants Received for Other than Capital Purposes Other Nonoperating Receipts
Net Cash Flows Provided (Used) by Noncapital Financing Activities
CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES Purchases of Capital Assets
CASH FLOWS FROM INVESTING ACTIVITIES Interest on Investments
Net Increase (Decrease) in Cash
Cash and Cash Equivalents- Beginning of Year
Cash and Cash Equivalents- End of Year
RECONCILIATION OF OPERATING LOSS TO NET CASH PROVIDED (USED) BY OPERATING ACTIVITIES:
Operating Income (Loss) Adjustments to Reconcile Net Income (Loss) to Net Cash
Provided (Used) by Operating Activities Depreciation Change in Assets and Liabilities: Accounts Receivable Inventories Prepaid Items Accounts Payable Salaries Payable Deferred Revenue Compensated Absences
Net Cash Provided (Used) by Operating Activities

EXHIBIT"C"

$

4,293,466.81

2,995,490.14

1,536,428.16

-10,024,703.04

-12,519,177.56

-2,461 ,384.19

166,300.64

$ -16,013,579.04

$ 15,586,610.40 99,772.20
1,767,978.70 -2,607.50
$ 17,451,753.80

$ -1,474,822.58

$ _ _ _4.:.:5:..:,3:.:9:.:.9:.::.0.::..9

$

8,751.27

2,767,948.18

$ ==2,-=7=76:,:,;,6=9=9=.4=5

$ -17,378,818.25
838,675.16
-429,366.36 -117,562.76
-8,374.45 1,029,837.44
-20,547.77 21,552.81 51 025.14
$ -16,013,579.04

- 5-

ATLANTA TECHNICAL COLLEGE SELECTED FINANCIAL NOTES JUNE 30, 2008

EXHIBIT "D"

NOTE 1: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
REPORTING ENTITY Atlanta Technical College is one of thirty-three (33) State supported member colleges of postsecondary education in Georgia which comprise the Georgia Department ofTechnical and Adult Education, an organizational unit ofthe State of Georgia. The accompanying financial statements reflect the operations of Atlanta Technical College as a separate reporting entity.
The Technical College's Local Board of Directors is composed of ten (1 0) members serving staggered three-year terms who are appointed by the State Board ofTechnical and Adult Education. Appropriation of State funds is made to the Georgia Department of Technical and Adult Education by the General Assembly of Georgia. The Department's Administrative Central Office determines the amount of State appropriations to be received by Atlanta Technical College. The Technical College does not have authority to retain unexpended State appropriations (surplus) for any given fiscal year. Accordingly, Atlanta Technical College is considered an organizational unit of the Georgia Department of Technical and Adult Education for financial reporting purposes because of the significance of its legal, operational, and financial relationships as defined in Section 2100 ofthe Governmental Accounting Standards Board (GASB) Codification ofGovernmental Accounting and Financial Reporting Standards.
NET ASSETS The Technical College's net assets are classified as follows:
Invested in capital assets, net ofrelated debt: This amount represents the Technical College's total investment in capital assets, net of outstanding debt obligations related to those capital assets. To the extent debt has been incurred but not yet expended for capital assets, such amounts are not included as a component of invested in capital assets, net of related debt.
Restricted net assets - expendable: Restricted expendable net assets include resources in which the Technical College is legally or contractually obligated to spend resources in accordance with restrictions imposed by external third parties, except for unexpended grant funds of$4, 125.59 due to grantor agencies.
Unrestricted net assets: Unrestricted net assets represent available resources derived from student tuition and fees, state appropriations, and sales and services of educational departments. These resources will be used for transactions relating to the educational and general operations of the Technical College, and may be used at the discretion of the governing board to meet subsequent fiscal year expenses for those purposes, except for unexpended state appropriations (surplus) of $11,666.39. Unexpended state appropriations must be refunded to the Department ofTechnical and Adult Education for remittance to the Office of Treasury and Fiscal Services.
When an expense is incurred that can be paid using either restricted or unrestricted resources, the Technical College's policy is to first apply the expense towards unrestricted resources, and then towards restricted resources.
- 6-

ATLANTA TECHNICAL COLLEGE SELECTED FINANCIAL NOTES JUNE 30, 2008

EXHIBIT "D"

NOTE 2: DEPOSITS
DEPOSITS The custodial credit risk for deposits is the risk that in the event of a bank failure, the Technical College's deposits may not be recovered. Funds belonging to the State of Georgia (and thus the Technical College) cannot be placed in a depository paying interest longer than ten days without the depository providing a surety bond to the State. In lieu ofa surety bond, the depository may pledge as collateral any one or more of the following securities as enumerated in the Official Code of Georgia Annotated Section 50-17-59:
1. Bonds, bills, certificates of indebtedness, notes, or other direct obligations of the United States or of the State of Georgia.
2. Bonds, bills, certificates of indebtedness, notes, or other obligations of the counties or municipalities of the State of Georgia.
3. Bonds ofany public authority created by the laws ofthe State ofGeorgia, providing that the statute that created the authority authorized the use of the bonds for this purpose.
4. Industrial revenue bonds and bonds of development authorities created by the laws of the State of Georgia.
5. Bonds, bills, certificates of indebtedness, notes, or other obligations of a subsidiary corporation ofthe United States government, which are fully guaranteed by the United States government both as to principal and interest, or debt obligations issued by the Federal Land Bank, the Federal Home Loan Bank, the Federal Intermediate Credit Bank, the Central Bank for Cooperatives, the Farm Credit Banks, the Federal Home Loan Mortgage Association, and the Federal National Mortgage Association.
6. Guarantee or insurance ofaccounts provided by the Federal Deposit Insurance Corporation.
As authorized in the Official Code of Georgia Annotated Section 50-17-53, the State Depository Board has adopted policies, which allows agencies of the State of Georgia (and thus Atlanta Technical College), the option of exempting demand deposits from the collateral requirements.
At June 30, 2008, the carrying value of deposits was $2,775,281.45 and the bank balance was $2,564,642.35. Of the Technical College's deposits, $2,464,642.35 were uninsured. Of these uninsured deposits, $2,464,642.35 were uncollateralized.
NOTE 3: ACCOUNTS RECEIVABLE
Accounts receivable at June 30, 2008, consists of the following:

- 7-

ATLANTA TECHNICAL COLLEGE SELECTED FINANCIAL NOTES JUNE 30, 2008

EXHIBIT "D"

NOTE 3: ACCOUNTS RECEIVABLE

Student Tuition and Fees Federal, State and Private Funds Georgia State Financing and Investment Commission Other
Less: Allowance for Doubtful Accounts Net Accounts Receivable

$ 444,260.42 323,565.61 72,429.78 36,326.10
$ 876,581.91
31.698.01
$ 8442883.90

NOTE 4: CAPITAL ASSETS

Following are the changes in capital assets for the year ended June 30, 2008:

Balance July 1, 2007

Additions

Reductions

Balance June 30, 2008

Capital Assets, Not Being Depreciated:

Land and Land Improvements

$ 1,405,553.00 $

Construction in Progress

840,652.57

0.00

$ 1,405,553.00

$ 840,652.57

0.00

$ 2,246,205.57 $

0.00 $ 840,652.57 $ 1,405,553.00

Capital Assets, Being Depreciated: Building and Building Improvements Improvements Other Than Buildings Equipment Library Collections

$ 12,314,361.66 $ 1,828,713.00 3,109,442.45 390,806.62

1,352,431.72
553,017.35 $ 20,150.76

$ 13,666,793.38

1,828,713.00

15,400.00 3,647,059.80

27,516.84

383,440.54

$ 17,643,323.73 $ 1,925,599.83 $ 42,916.84 $ 19,526,006.72

Less: Accumulated Depreciation:

Building and Building Improvements $ 2,411,016.37 $

Improvements Other Than Buildings

1,786,489.73

Equipment

2,177,120.25

Library Collections

248,551.76

351,097.01 16,344.50
436,955.71 $ 34,277.94

$ 2,762,113.38

1,802,834.23

878.35 2,613,197.61

27,516.84

255,312.86

$ 6,623,178.11 $ 838,675.16 $ 28,395.19 $ 7,433,458.08

Total Capital Assets, Being Depreciated,

Net

$ 11,020,145.62 $ 1,086,924.67 $

14,521.65 $ 12,092,548.64

Capital Assets, Net

$ 13.266 351.19 $ 1 086.924.67 $ 855.174.22 $ 13.498.101.64

NOTE 5: DEFERRED REVENUE

Deferred revenue at June 30, 2008, consists of the following:

Prepaid Tuition and Fees Federal Grants and Contracts
Totals

$ 47,759.00 21,336.65
$ 69.095.65

- 8-

ATLANTA TECHNICAL COLLEGE SELECTED FINANCIAL NOTES JUNE 30, 2008

EXHIBIT "D"

NOTE 6: LONG-TERM LIABILITIES

Long-Term liability activity for the year ended June 30, 2008 was as follows:

Other Liabilities Compensated Absences

Balance July 1, 2007

Additions

Reductions

Balance June 30, 2008

Current Portion

$ 1 004.317.25 $ 821,379.65 $ 770.354.51 $ 1.055.342.39 $ 520.118.76

NOTE 7: NET ASSETS

Changes in Net Asset activity for the year ended June 30, 2008 was as follows:

Invested in Capital Assets Net of Related Debt
Restricted Net Assets
Unrestricted Net Assets
Total Net Assets

Balance July 1, 2007

Additions

Reductions

Balance June 30, 2008

$ 13,266,351.19 $ 1,086,924.67 $ 855,174.22 $ 13,498,101.64

21,706.89

1,703,657.69

1,721,238.99

4,125.59

1,383,027.05 25,244,570.42 25,693,225.98

934 371.49

$ 14 6:Z1 Q85 13 $ 28 035 152.78 $ 28,262,632.12 $ 14,436,598.72

NOTE 8: RETIREMENT PLANS

TEACHERS RETIREMENT SYSTEM OF GEORGIA

Plan Description Atlanta Technical College participates in the Teachers Retirement System ofGeorgia (TRS), a costsharing multiple-employer defined benefit pension plan established by the General Assembly of Georgia for the purpose of providing retirement allowances and other benefits for teachers of the State of Georgia. TRS provides service retirement, disability retirement, and survivor's benefits for its members in accordance with State statute. The Teachers Retirement System of Georgia issues a separate stand alone financial audit report and a copy can be obtained from the Georgia Department of Audits and Accounts.

Funding Policy Employees of Atlanta Technical College who are covered by TRS are required by State statute to contribute 5% of their gross earnings to TRS. Atlanta Technical College makes monthly employer contributions to TRS at rates adopted by the TRS Board ofTrustees in accordance with State statute and as advised by their independent actuary. For fiscal year 2008, the employer contribution rate was 9.28% for covered employees. Employer contributions for the current fiscal year and the preceding two fiscal years are as follows:

-9-

ATLANTA TECHNICAL COLLEGE SELECTED FINANCIAL NOTES JUNE 30, 2008

EXHIBIT"D"

NOTE 8: RETIREMENT PLANS

TEACHERS RETIREMENT SYSTEM OF GEORGIA

Funding Policy Fiscal Year

Percentage Contributed

Required Contribution

2008 2007 2006

100% 100% 100%

$ 617,508.77 $ 595,573.62 $ 597,403.82

EMPLOYEES' RETIREMENT SYSTEM OF GEORGIA

Plan Description Atlanta Technical College participates in the Employees' Retirement System of Georgia (ERS), a single-employer defined benefit pension plan established by the General Assembly of Georgia for the purpose ofproviding retirement allowances for employees of the State of Georgia.

Retirement benefits paid to members are based upon a formula which considers the monthly average ofthe member's highest twenty-four consecutive calendar months ofsalary, the number ofyears of creditable service, and the member's age at retirement. Postretirement cost-of-living adjustments are also made to member's benefits. The normal retirement pension is payable monthly for life; however, options are available for distribution ofthe member's monthly pension at reduced rates to a designated beneficiary upon the member's death. Death and disability benefits are also available through ERS.

In addition, the ERS Board of Trustees created the Supplemental Retirement Benefit Plan (SRBP) effective January 1, 1998. The SRBP was established as a qualified governmental excess benefit plan in accordance with Section 415 of the Internal Revenue Code (IRC) as a portion ofERS. The purpose ofSRBP is to provide retirement benefits to employees covered byERS whose benefits are otherwise limited by IRC 415.

Funding Policy As established by State statute, all full-time employees of the State of Georgia and its political subdivisions, who are not members ofother state retirement systems, are eligible to participate in the ERS. Both employer and employee contributions are established by State statute. The Technical College's payroll for the year ended June 30, 2008, for employees covered by ERS was $3,678,738,65. The Technical College's total payroll for all employees was $12,549,654.93.

Under the old plan, member contributions consist of 6.5% of annual compensation. Of these member contributions, the employee pays the first 1.5% and the Technical College pays the remainder on behalf ofthe employee. Under the new plan, member contributions consist solely of 1.5% of annual compensation paid by employee. The Technical College also is required to

- 10-

ATLANTA TECHNICAL COLLEGE SELECTED FINANCIAL NOTES JUNE 30, 2008

EXHIBIT "D"

NOTE 8: RETIREMENT PLANS
EMPLOYEES' RETIREMENT SYSTEM OF GEORGIA
Funding Policy contribute at a specified percentage of active member payroll determined annually by actuarial valuation. For the year ended June 30, 2008, the ERS employer contribution rate for the Technical College amounted to 10.4% of covered payroll. Atlanta Technical College did not have any employees covered by the old plan referred to above. Employer contributions are also made on amounts paid for accumulated leave to retiring employees.
Total contributions to the plan made during fiscal year 2008 amounted to $441,682.91, of which $382,423.23 was made by the Technical College and $59,259.68 was made by employees. These contributions met the requirements of the plan.
GEORGIA DEFINED CONTRIBUTION PLAN
Plan Description Atlanta Technical College participates in the Georgia Defined Contribution Plan (GDCP) which is a single-employer defined contribution plan established by the General Assembly ofGeorgia for the purpose of providing retirement coverage for State employees who are temporary, seasonal, and part-time and are not members of a public retirement or pension system. GDCP is administered by the Board of Trustees of the Employees' Retirement System of Georgia.
Benefits A member may retire and elect to receive periodic payments after attainment of age 65. The payment will be based upon mortality tables and interest assumptions to be adopted by the Board of Trustees. Ifa member has less than $3,500.00 credited to his/her account, the Board ofTrustees has the option ofrequiring a lump sum distribution to the member in lieu ofmaking periodic payments. Upon the death of a member, a lump sum distribution equaling the amount credited to his/her account will be paid to the member's designated beneficiary. Benefit provisions are established by State statute.
The Employees' Retirement System ofGeorgia issues a financial report each fiscal year which may be obtained through ERS.
Contributions and Vesting Member contributions are seven and one-halfpercent (7.5%) ofgross salary. There are no employer contributions. Contribution rates are established by State statute. Earnings are credited to each member's account in a manner established by the Board of Trustees. Upon termination of employment, the amount of the member's account is refundable upon request by the member. The Technical College's payroll for the year ended June 30, 2008, for employees covered by GDCP was $1,682,156.78. The Technical College's total payroll for all employees was $12,549,654.93.

- 11 -

ATLANTA TECHNICAL COLLEGE SELECTED FINANCIAL NOTES JUNE 30, 2008

EXHIBIT "D"

NOTE 8: RETIREMENT PLANS
GEORGIA DEFINED CONTRIBUTION PLAN
Contributions and Vesting Total contributions made by employees during fiscal year 2008 amounted to $126,167.80 which represents 7.5% of covered payroll. These contributions met the requirements of the plan.
NOTE 9: POSTEMPLOYMENT BENEFITS
The Technical College participates in the Georgia Retiree Health Benefit Fund ("GRHBF") which is a cost-sharing multiple-employer defined benefit postemployment healthcare plan that covers retired employees ofthe State of Georgia. GRHBF provides health insurance benefits to eligible retirees and their qualified beneficiaries.
Pursuant to Title 45, Chapter 18 of O.C.G.A., the authority to establish and amend the benefit provisions of the plan is assigned to the Board of Community Health ("Board"). Financial statements and required supplementary information for GRHBF are included in the publicly available financial report of the Department of Community Health.
The Technical College contributes to the fund based upon amounts recommended by the Board and set forth in the Appropriations Act. This contribution rate is established to fund both the active and retired employee components of the health insurance plan based on projected pay-as-you-go financing requirements. The combined rate for the active and retiree components ofthe plan (payas-you-go basis) for the fiscal year ended June 30, 2008, was 18.534% of covered payroll. An additional contribution of4.309% ofcovered payroll was required by the Board for fiscal year 2008; eleven months ofthis additional contribution will be deposited into the OPEB fund to prefund retiree benefits (such additional contribution amounts are determined annually). The Technical College's contribution to the health insurance plan for the fiscal year ended June 30, 2008, was $2,382,730.96, which equaled the required contribution.
The Technical College also participates in a program of group term life insurance for retired and vested inactive eligible members ofvarious retirement systems. The State Employees' Assurance Department ("SEAD-OPEB") is a single-employer defined benefit postemployment plan.
Pursuant to Title 47 ofthe Official Code ofGeorgia Annotated, the authority to establish and amend the benefit provisions of the plan is assigned to the Boards of Trustees of the Employees' and Judicial Retirement Systems. Financial statements and required supplementary information for SEAD-OPEB are included in the publicly available financial report of the Employees' Retirement System.
The Technical College is required to contribute the annual required contribution of the employer (ARC), an amount actuarially determined in accordance with the parameters ofGASB Statement 45. The ARC for the year ended June 30, 2008, was zero (0).
- 12-

ATLANTA TECHNICAL COLLEGE SELECTED FINANCIAL NOTES JUNE 30, 2008

EXHIBIT "D"

NOTE 10: RISK MANAGEMENT
Public Entity Risk Pool The Department of Community Health (DCH) administers for the State of Georgia a program of health benefits for the employees of units of government of the State of Georgia, units of county governments, and local education agencies located with the State ofGeorgia. This plan is funded by participants covered in the plan, by employers' contributions paid by the various units ofgovernment participating in the plan, and appropriations made by the General Assembly of Georgia. DCH contracted with United Healthcare to process medical claims. For prescription drug claims, DCH contracted with Express Scripts, Incorporated through December 31, 2007 and contracted with Medco, Incorporated beginning January 1, 2008. All claims are to be processed in accordance with the State Employees' Health Benefit Plan as established by the Department of Community Health.
Other Risk Management The Department ofAdministrative Services (DOAS) has the responsibility for the State ofGeorgia ofmaking and carrying out decisions that will minimize the adverse effects ofaccidental losses that involve State government assets. The State believes it is more economical to manage its risks internally and set aside assets for claim settlement. Accordingly, DOAS processes claims for risk of loss to which the State is exposed, including general liability, property and casualty, workers' compensation, unemployment compensation, and law enforcement officers' indemnification. Limited amounts of commercial insurance are purchased applicable to property, employee and automobile liability, fidelity and certain other risks. The Technical College, as an organizational unit ofthe Georgia Department of Technical and Adult Education, is part of the State of Georgia reporting entity, and as such, is covered by the State of Georgia risk management program administered by DOAS. Premiums for the risk management program are charged to the various state organizations by DOAS to provide claims servicing and claims payment.
NOTE 11: AFFILIATED ORGANIZATIONS
The Atlanta Technical College Foundation, Inc., is a legally separate, tax exempt organization whose activities primarily support Atlanta Technical College. This affiliated organization is considered a potential component unit of the State of Georgia in accordance with GASB Statement No. 39, Determining Whether Certain Organizations are Component Units. Therefore, the financial statements ofthis affiliated organization are not included in these financial statements. Copies ofthe financial statements for the affiliated organization may be obtained from Atlanta Technical College.

- 13-

(This page left intentionally blank)

SUPPLEMENTARY INFORMATION - 15 -

ATLANTA TECHNICAL COLLEGE BALANCE SHEET (STATUTORY BASIS)
BUDGET FUND JUNE 30, 2008
ASSETS
Cash and Cash Equivalents Accounts Receivable
Federal Financial Assistance Other Prepaid Expenditures Inventories
Total Assets
LIABILITIES AND FUND EQUITY
Liabilities Salaries Payable Payroll Withholdings Accounts Payable Encumbrances Payable Deferred Revenue Funds Held for Others
Total Liabilities
Fund Balances Reserved Departmental Sales and Services Federal Financial Assistance Live Work Projects Technology Fees Uncollectible Accounts Receivable Inventories Unreserved Surplus
Total Fund Balances
Total Liabilities and Fund Balances

SCHEDULE "1"

$

2,643,434.18

660,515.09 447,389.26
12,841.50 541,351.38

$ ==4==30=5=,5=31=.4=1=

$

93,008.99

183,502.50

1,445,189.28

1,904,356. 79

47,759.00

19,656.50

$

3,693,473.06

$

44,050.26

4,125.59

57,379.56

40,596.42

31,698.01

422,542.12

11,666.39

$

612,058.35

$ ==4=,3=0=5=,5=31=.4=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.
- 16-

ATLANTA TECHNICAL COLLEGE SUMMARY BUDGET COMPARISON AND SURPLUS ANALYSIS REPORT (STATUTORY BASIS)
BUDGET FUND YEAR ENDED JUNE 30, 2008

SCHEDULE "2"

REVENUES
State Appropriation State General Funds
Federal Funds Other Funds
Total Revenues
CARRY-OVER FROM PRIOR YEAR
Transfer from Reserved Fund Balance
Total Funds Available
EXPENDITURES
Adult Literacy Economic Development Technical Education
Total Expenditures
Excess of Funds Available over Expenditures
FUND BALANCE JULY 1
Reserved Unreserved
ADJUSTMENTS
Prior Year Payables/Expenditures Unreserved Fund Balance (Surplus) Returned
to Georgia Department of Technical and Adult Education Year Ended June 30, 2007
Refunds to Grantors Federal Financial Assistance Returned to Georgia Department of Technical and Adult Education
Prior Year Reserved Fund Balance Included in Funds Available
FUND BALANCE JUNE 30

BUDGET

ACTUAL

VARIANCEFAVORABLE (UNFAVORABLE)

$

15,588,121.00 $

15,588,121.00 $

0.00

1,973,936.29

1,917,269.53

-56,666.76

8 059 870.30

6,823,046.50

-1,236,823.80

$

25,621,927.59 $

24,328,437.03 $

-1,293,490.56

0.00

362 463.71

$

25,621,927.59 $

24,690,900.74 $

362 463.71 -931 026.85

$

47,454.50 $

40,052.63 $

16,900.00

15,050.00

25,557,573.09

24 487 484.89

$

25,621,927.59 $

24,542,587.52 $

$

0.00 $

148,313.22 $

7,401.87 1,850.00 1,070,088.20
1 079 340.07
148 313.22

795,261.92 1,510.60

52,653.81

-1,510.60

-21,706.89 -362 463.71

$

612 058.35

SUMMARY OF FUND BALANCE
Reserved Departmental Sales and Services Federal Financial Assistance Live Work Projects Technology Fees Uncollectible Accounts Receivable Inventories
Total Reserved
Unreserved Surplus
Total Fund Balance
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.
- 17-

$

44,050.26

4,125.59

57,379.56

40,596.42

31,698.01

422 542.12

$

600,391.96

11 666.39

$

612 058.35

ATLANTA TECHNICAL COLLEGE STATEMENT OF PROGRAM REVENUES AND EXPENDITURES BY FUNDING SOURCE COMPARED TO BUDGET
(STATUTORY BASIS} BUDGET FUND YEAR ENDED JUNE 30, 2008

Adult Literacy Federal Funds Other Funds
Total Adult Literacy

Ortginal Appropriation

$

16,891.00 $

10000.00

$

26,891.00 $

Final Budget

Current Year Revenues

Funds Available Comeared to Budaet

Prior Year Carrv-Over

Total Funds Available

Variance Positive (Negative)

15,454.50 $ 32 000.00
47,454.50 $

15,225.13 $ 31125.00
46 350.13 $

0.00 $ 0.00
0.00 $

15,225.13 $ 31125.00
46350.13 $

-229.37 -875.00
-1,104.37

Economic Development Other Funds

$

0.00 $

16 900.00 $

15 050.00 $

0.00 $

15 050.00 $

-1 850.00

Technical Education State Approprtation State General Funds Federal Funds Other Funds
Total Technical Education

$

14,557,850.00 $

15,588,121.00 $

15,588,121.00 $

521,769.00

1,958,481.79

1,902,044.40

6,190,523.00

8 010 970.30

6 776 871.50

$

21,270,142.00 $

25 557,573.09 $

24 267 036.90 $

0.00 $ 0.00 362 463.71
382,463.71 $

15,588,121.00 $ 1,902,044.40 7,139,335.21
24 629 500.61 $

0.00 -56,437.39 -871 ,635.09
-928 072.48

Grand Totals All Programs

$

21,297,033.00

25,621,927.59 $

24,328,437.03 $

362,463.71 $

24,690,900.74 $ -931,026.85

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 prtnciples.
-18-

SCHEDULE "3"

Exeend~ures Coml!!!red to Budget Variance

Pos~ive

Actual

(Negative!

Actual Funds Available
Over/(Under) Expenditures

Prior Period Adjustments

Other Adjustments

Program Fund
Balances

Transfers

P~ram Fund Balances

Reserve

Surplus

Total Fund Balance

$

8,927.63 $

31,125.00

$

40,052.63 $

6,526.87 $ 675.00
7,401.67 $

6,297.50 $ 0.00
6,297.50 $

11.70 $ 0.00
11.70 $

0.00

6,309.20 $

0.00 $ 1,225.00 $ 5,084.20 $ 6,309.20

0.00

0.00

0.00

0.00

0.00

0.00

0.00

6,309.20 $

0.00 $ 1,225.00 $ 5,064.20 $ 6,309.20

$

15,050.00 $

1,650.00 $

0.00 $

42.00 $

0.00 $

42.00 $

0.00 $

0.00 $

42.00 $

42.00

$ 15,588,121.00 $ 1,852,479.33 7,046,884.56
$ 24.487,484.89 $

0.00 $ 106,002.46 984,085.74
1,070,088.20 $

0.00 $ 49,565.07 92,450.65
142,015.72 $

0.00 $ -824.25 53,424.36

0.00 $

0.00 $

-43,148.81

5,592.01

0.00

145,875.01

52,600.11

-43148.81 $ 151.467.02 $

0.00 $

0.00 $

0.00

2,900.59

0.00

142,026.24

0.00 $ 144,926.83 $

0.00 $

0.00

2,691.42

5,592.01

3,848.77

145,875.01

6,540.19 $ 151.467.02

$ 24,542,587.52 $ 1,079,340.07 $

148,313.22 $ 52,653.81 $ -43,148.81 $ 157,818.22 $

0.00 $ 146,151.83 $ 11,666.39 $ 157,818.22

Unexpendable Reserves Uncollectible Accounts Receivable Inventories

31,698.01 422,542.12
$ 612,058.35

-19-

(This page left intentionally blank)

ATLANTA TECHNICAL COLLEGE RECONCILIATION OF SALARIES AND TRAVEL
YEAR ENDED JUNE 30, 2008

SCHEDULE "4"

Totals per Annual Supplement
Accruals June 30, 2008 June 30, 2007
Compensated Absences June 30, 2008 June 30, 2007
Lag Salaries June 30, 2008 June 30, 2007
Agency Funds
Jointly-Staffed Employee Gwinnett Technical College Clark, Arlene
Unidentified Variance

SALARIES $ 12,530,995.15 $

TRAVEL 116,622.43

93,008.99 -113,556.76

849,076.29 -849,942.24

-46,024.38 82,223.03

-11,480.34

3,874.85

316.00

$ 12,549,654.93 $===1=05~,4=5=8-=09==

-21 -

SECTION II FINDINGS, QUESTIONED COSTS AND OTHER ITEMS

ATLANTA TECHNICAL COLLEGE SCHEDULE OF FINDINGS, QUESTIONED COSTS AND OTHER ITEMS
YEAR ENDED JUNE 30, 2008
FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS
No matters were reported.
FEDERAL AWARD FINDINGS AND QUESTIONED COSTS
No matters were reported.
OTHER ITEMS (NOTED FOR MANAGEMENT'S CONSIDERATION)
FINANCIAL STATEMENT PREPARATION Testing of Atlanta Technical College's financial statements revealed the following three misclassification errors: ( 1) The College incorrectly recorded the loss associated with capital asset deletions made during the year to operating revenue instead of capital contributions -Loss on Disposal ofCapital Assets; (2) the College did not properly reflect the Federal Financial Assistance reserved fund balance as Restricted Net Assets on the Statement ofNet Assets; and (3) the College reported GSFIC bond revenue totaling $298,218.00 as nonoperating gift revenue instead of Capital Gifts and Grants revenue and failed to record $2,000.00 ofGSFIC on-behalfrevenue on the financial statements. Adjustments were proposed to correct items 1 and 2 noted above. Even though these misclassifications were relatively insignificant to the financial statements, we recommend that management enhance the process utilized in reviewing their financial statements in order to minimize the chance of errors included in the financial statements.
SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Errors were noted in the expenditure amounts reported on the Schedule ofExpenditures and Federal Awards (SEFA) submitted by Atlanta Technical College to the State Accounting Office for inclusion in the State of Georgia's Single Audit Report. Federal revenue totals were submitted as expenditure amounts as opposed to the actual expenditures for each Federal program. The SEFA was corrected to reflect the correct fiscal year expenditures for all Federal activity. Management should ensure that the submitted information for the SEFA is complete and accurate to reflect all Federal assistance administered by the Technical College.