'.:::JA J I ' ) . I\BOO ,,; I ,S6(p ;;l.oo I-;zoo;;. -1 ' , I STAT~ OF GEORGIA' -- ,:,,.; ,;DEPARTMENT.OF AUDITS AND ACC'OUNTs ' ' ., '- \ , . . ,- -' ! .,' I < I . ( ~ ' ,-' ., " , ' , , 'I ' ' ' I. / ' SKIQAWAYi'INSTITUTE-OF OCEANOG'RAPHY ,_1 -SAVANNAH. GEORG'IA - \' (.., ' ' I . (" ' I ' '. REPORT QN REVIEW ' ' OF THE FINANCIAL STATEMENTS ' FOR THE FISCAL YEAR ENDED JUNE 30,' 2002 I " ' ' . i ' J \. \ / \ '\ Russell W. Hinton State Auditor ' ' ' ' ! \ ) SKIDAWAY INSTITUTE OF OCEANOGRAPHY -TABLE OF CONTENTS- SECTION I FINANCIAL INDEPENDENT ACCOUNTANT'S COMBINED REPORT ON REVIEW OF BASIC FINANCIAL STATEMENTS AND SUPPLEMENTARY INFORMATION REQUIRED SUPPLEMENTARY INFORMATION MANAGEMENT'S DISCUSSION AND ANALYSIS BASIC FINANCIAL STATEMENTS EXHIBITS A STATEMENT OF NET ASSETS B STATEMENT OF REVENUES, EXPENSES AND CHANGES IN NET ASSETS C STATEMENTOFCASHFLOWS D NOTES TO THE FINANCIAL STATEMENTS SUPPLEMENTARY INFORMATION SCHEDULES SCHEDULES OF REVENUES AND EXPENDITURES COMPARED TO BUDGET - (NON-GAAP BASIS) 1 RESIDENT INSTRUCTION 2 LOTTERY FOR EDUCATION 3 OTHER ORGANIZED ACTIVITIES 4 RECONCILIATION OF SALARIES AND TRAVEL Page 3 11 12 13 14 29 30 31 32 SECTIONil CURRENT YEAR FINDINGS AND QUESTIONED COSTS SCHEDULE OF FINDINGS AND QUESTIONED COSTS SECTION I FINANCIAL R11,,1-.11 \\'. H1,TO""I STATE AUC:ITOR i04l 656 2174 DEPARTMENT OF AUDITS AND ACCOUNTS '2~4 \\'J,hmg1on Street S 'Vt/. Suite:! 14 Atlanta Georg1.1 10334-84eprec1at1on Total Opcraimg Expenses FuncMnal Qa,wficanon Banm:b Acaderruc $ypport lnstJ:rutJOOal Syrmort s s s 1,533.347 03 43,600 47 76,893 92 347,432 37 319,961 82 412,442 60 399,887 26 81,96620 209,988 68 95,739 45 24,271.22 10,808 53 18.343 67 5,49211 1,033 01 960,122 80 187,426 74 87,631 45 s J}Y 872 58 s 662 718 56 s 728 798 l9 Natural Oau1ficat1on Salanes Faculty Staff ~loyee Benefits Tni.vel Ut:1htJcs Suppl,es and Other Serv>= OC'prcclatJon Tool Opennng Expenses Plant ()penbons and Ma1ntenaru;t; Functwnal C1ass1ficanon Aux,lwy Entgpnscs Unallocated Pcm:cc11t1on Total Openimg ExPCOW S 566,663 49 145,163 07 1,541 94 321,80325 S 281,967 48 s 1JIZIJ221 s 6,157 08 S 1,653,841 42 1,646,500 28 837,005 21 132,361 14 352,829 12 20,329 33 S 106 171 06 1,537,47180 106 171 06 761M11 s 10617106 s 626618693 - 25 - SUPPLEMENTARY INFORMATION - 27 - SKIDAWAY INSffil/TE OF OCEANOGRAPHY SCHEDULE OF REVENUES AND EXPENDITURES COMPARED TO BUDGET -(NON-GAAP BASIS\ RESIDENT INSTRUCTION YEAR ENDED JUNE 30 2002 SCHEDULE "1" REVENUES State Appropnabons Other Revenues Retained BUDGET ACTUAL(1) VARIANCEFAVORABLE (UNFAVORABLE) $ 368,11300 $ 368,113 00 $ 000 447 617 89 0 00 447 617 89 s 36811300 $ 815,730 89 $ _ __c44..:,7:..,.,6=..1"-7..;:8.=..9 EXPENDITURES Operating Expenses Educabon, General and Departmental Serv,ces Capltal Outlay s 195,000 00 $ 567,235 70 $ 173113 00 17311300 -372,235 70 000 $ 36811300$ 740,348 70 $ _ _ _.,;:3"'72c;.,2C-'3'-"5..:.7.=..0 Excess of Revenues over Expenditures $ 75 38219 $ _ _ _~75::,;3:::8::;2_,:1.::,9 ( 1) Actual amounts were prepared on a presa1bed basis of aa:ounbng that demonstrates compliance wrth budgetary statutes and regulabons of the State of Georgia, which ,s a comprehensive bas,s of aecx>unbng other than generally accepted aecx>untlng pr1naples See aecx>mpany,ng notes and Independent Accountant's Combined Report on Review of Bas,c Finanaal Statements and Supplementary lnformabon -29- SKIDAWAY INSTITUTE Of OCEANOGRAPHY SCHEDULE Of REVENUES ANO EXPENDITURES COMPARED TO BUDGET {NON-OAAP BASIS} LOTTERY FOR EDUCATION YEAR ENPEP JUNE 30. 2002 SCHEDULE "2" REVENUES State Appropnabons BUDGET ACTUAL (1) VARIANCE FAVORABLE (UNFAVORABLE) s 66 276 00 $ 66.215 oo s_____"'o"'oo"' EXPENDITURES Equipment Technology and Construction Trust Fund Speaal Funding lmba11Vas Excess of Revenues over Expenditures $ 46.276 00 $ 46,276 00 $ 000 20 000 00 20 000 00 000 s 6627600 $ 66,276 oo s____-=o-'o"--o $ 0 00 S _ _ _ _...,::0~0:::,0 (1) Actual amourrts were prepared on a prescnbed bas,s of accounting that demonstrates compliance with budgetary staMes and regulatrons of the State of Georgia. which is a comprehensive baSls of accounbng other than generally accepted accounting pnnaples See accompanying notes and Independent Accountant's Combined Report on Review of Bas,c Fmanaal Stalements and Supplementary lnformallon -30- SKIDAWAY INSTITUTE OF OCEANOGRAPHY SCHEDULE OF REVENUES AND EXPENDITURES COMPARED TO BURGET - /NON:GAAP BASIS! OTHER ORGANIZED ACTIVITIES YEAR ENDED JUNE 30 2002 SCHEDULE "3" BUDGET ACTUAL(1) VARIANCEFAVORABLE (UNFAVORABLE) REVENUES State Appropnat,ons Other Revenues Retained $ 1,859,122 00 $ 1,859,122 00 $ 3,343,420 00 4198 219 68 000 854 799 68 $ 6,057 34168 $ _ _~8~54-",7_99~68~ EXPENDITURES Personal SeMces Educabon, General and Departmental SeMces s Sponsored Operabons Operabng Expenses Educabon, General and Departmental Serv,ces Sponsored Operabons 2,172,426 00 $ 1,692,948 00 530,116 00 807 052 00 2 068, 195 83 $ 2,022,201 23 719,088 13 1247756 49 104 230 17 -329,253 23 -188,972 13 -440 704 49 Excess of Revenues over Expenditures $ 512021542 oo s 6,051.241 ss s___-854-=-"6~9'-=9-"68"'" s 10000 s _____100__.o_o (1) Actual amounts were prepared on a presa,bed basis of accounbng that demonstrates a,mphance With budgetary staMes and regulations of the Sta19 of Georgia, which 1s a a,mprehens,ve basis of accounbng other than generally accepted accounbng pnnaples See accompanying notes and Independent Accountant's Combined Report on Review of BaSlc Financial Statements and Supplementary lnfonnabon -31 - SKIDAWAY INSTITUTE OF OCEANOGRAPHY RECONCILIATION OF SALARIES AND TRAVEL YEAR ENDED JUNE 30. 2002 SCHEDULE "4" Totals per Annual Supplement Compensated Absences June 30, 2002 June 30, 2001 AdJustments Shared Services on Jointly Stalled Personnel Armstrong Atlantic State University Holliman, Patncaa Momson, Chnstel SALARIES $ 3,254,144 55 $ TRAVEL 132,361 14 331,260 97 -287,660 50 3,756 99 -1 160 31 $ 313001341 70 $ -.,...:.1;;;:32;,.136=1~1;;4:,. See accompanying notes and Independent Accountant's Combmed Report on Review of Basic Fmancaal Statements and Supplementary lnformebon - 32 - SECTION II CURRENT YEAR FINDINGS AND QUESTIONED COSTS SKIDAWAY INST111JTE OF OCEANOGRAPHY SCHEDULE OF F11'.'DINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 2002 FINANCIAL STATEMEJ\'T FINDINGS AND QUESTIONED COSTS ACCOUNTING CONTROLS (OVERALL) Inadequate Closmg Procedures Fmdmg Control Number FS-593-02-01 Dunng fiscal year 2002, the Board ofRegents ofthe Uruvers1ty System ofGeorgia converted uruts of the Uruvers1ty System from the College Umvers1ty Fmancial Accountmg (CUFA) legacy system lo the new GeorgiaFJRSTSystem (Fmanc1al, Information and Reportmg Systems for Tomorrow) In October of2001, Sk1daway Institute ofOceanography placed this accountmg system mto producuon The management ofSk1daway Institute ofOceanography 1s responsible for 1mplementmg procedures to establish and mamtam adequate control over the operation, utllizatlon, and mtegnty of their data processed with the Georg1aF/RST System We encountered problems v11th the financial data presented by the Institute. The Instltute's failure to establish and adhere to a final closing for the year ended June 30, 2002, created a s1tuat10n where data presented for reVJew was mcomplete. Extensive review procedures were necessary to determme the val1d1ty of the mformat1on proVJded To reduce the nsk ofreportmg incomplete mformatlon, the institute should work with the Board of Regents Central Office to develop procedures that will result m complete reporting of all financial data m a more efficient and timely manner. CASH AND CASH EQUIVALENTS Inadequate Cash Procedures Findmg Control Number FS-593-02-02 For the year under reVJew, Sladaway Institute of Oceanography failed to reconcile the bank statements for the operatmg and payroll accounts to the general ledger m a timely manner. Book errors were earned as reconc1hng items for extended penods of time. These defic1enc1es occurred because ofmanagement's failure to establish procedures to analyze and reconcile balances on the general ledger with supportmg records and mmagement's failure to ensure that reconc1liatlons were made m a timely manner. Sk1daway Institute of Oceanography should implement appropnate procedures to ensure that bank statements are reconciled to the general ledger and that required adjustments are identified and recorded ma timely manner -I- SKIDAWAY INSTITUTE OF OCEANOGRAPHY SCHEDULE OF FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 2002 FINANCIAL STATEME:t\'T FINDINGS AND QUESTIONED COSTS GENERAL LEDGER Inadequacies m Control Over Accounts Receivable Subs1d1ary Ledger Fmdmg Control Number FS-593-02-03 Our exammauon mcluded a reVJew ofthe procedures utilized by Sladaway Insutute ofOceanography m recordmg transactions to the vanous modules compnsmg the Georg1aFJRSTaccountmg system Our testmg revealed that, at June 30, 2002, the Insutute's general ledger module did not balance with the accounts receivable subs1d1ary module Tins condition was pnmanly due to errors m posting subs1d1ary records dunng the conversion from the old College Umvers1ty Fmancial Accountmg (CUFA) legacy accounung system to the new GeorgiaFIRST accounUng system and due to transactions bemg posted to the general ledger module rather than the appropnate subs1d1ary module The Institute did not proVJde a reconc1hat1on ofthe general ledger balances to the subs1d1ary records winch resulted m extensive work by the auditors to identify reconc!lmg items at June 30, 2002 Management's failure to ensure that subsidiary records are reconciled with the general ledger causes mtemal reports to management, generated from the accounts receivable subs1d1ary module, to be maccurate and nusleadmg. Tins condition can lead to erroneous dec1S1ons by the lnslltute's management and result m maccurate reporting of financial mformat1on. To ensure accurate and timely reporting of financial mformallon from subsidiary records, the lnslltute should post transactions correctly to the accounts receivable subs1d1ary ledger rather than as Journal entnes m the general ledger. The Institute should develop mtemal accountmg controls and procedures to ensure that reconc1hatJons ofthe accounts receivable subs1d1ary ledger and the general ledger are perfonned on a regular basis -2-