REPORT DIGEST

 

DEPARTMENT OF AGRICULTURE

 

COMPLIANCE AUDIT

For the Two Years Ended:

June 30, 2005

 

Summary of Findings:

Total this audit                        16

Total last audit                        12

Repeated from last audit           5

 

Release Date:

June 20, 2006  

 

 

State of Illinois

Office of the Auditor General

WILLIAM G. HOLLAND

AUDITOR GENERAL

 

 

To obtain a copy of the Report contact:

Office of the Auditor General

Iles Park Plaza

740 E. Ash Street

Springfield, IL 62703

(217) 782-6046 or TTY (888) 261-2887

 

This Report Digest and Full Report are also available on the worldwide web at

http://www.state.il.us/auditor

 

 

SYNOPSIS

 

¨      The Department of Agriculture made payments for efficiency initiative billings from improper line item appropriations.

¨      The Department entered into an interagency agreement with the Department of Central Management Services that had vague terms and questionable benefit to the Department, and was inadequately documented.

¨      The Department did not process contract obligation documents in a timely manner.

¨      The Department did not have written policies and procedures in place related to systems development by external developers and did not assure all systems were consistently developed, thoroughly tested, and adequately documented.

¨      The Department did not have an adequate and tested comprehensive disaster contingency plan to ensure its critical computer systems can be recovered in the event of a disaster.

¨      The Department did not maintain time sheets of time worked by employees as required by the State Officials and Employees Ethics Act. 

¨      The Department did not have an adequate segregation of duties over the cash receipts of the Illinois Colt Stakes/Championship Purse Fund.

¨      The Department did not fully implement six of ten recommendations presented in the Management Audit – Regulation of Grain Dealers and Warehouseman.

 

 

 

 

 

 

 

{Expenditures and Activity Measures are summarized on the reverse page.}

 

 

 

 


DEPARTMENT OF AGRICULTURE

COMPLIANCE EXAMINATION

For The Two Years Ended June 30, 2005

 

EXPENDITURE STATISTICS

FY 2005

FY 2004

FY 2003

·         Total Expenditures (All Funds)...................

 

$100,242,380

$108,519,323

$113,835,813

     OPERATIONS TOTAL..................................

         % of Total Expenditures........................

$74,336,187

74.2%

$73,940,175

68.1%

$75,328,068

66.2%

         Personal Services...................................

            % of Operations Expenditures...........

            Average No. of Employees...............

            Average Salary per Employee...........

$21,123,001

28.4%

479

$44,098

$21,995,122

29.8%

498

$44,167

$23,287,949

30.9%

536

$43,448

         Other Payroll Costs (FICA, Retirement)..

            % of Operations Expenditures...........

$6,098,259

8.2%

$5,288,691

7.1%

$5,671,204

7.5%

   Interfund Cash Transfers........................

 % of Operations Expenditures..............

$25,287,592

34.0%

$24,081,740

32.6%

$21,768,040

28.9%

         Contractual Services...............................

            % of Operations Expenditures...........

$4,014,354

5.4%

$4,385,745

5.9%

$4,272,535

5.7%

         Lump Sum.............................................

           % of Operations Expenditures...............

$14,848,075

20.0%

$14,887,118

20.1%

$17,011,996

22.6%

         All Other Operations Items.....................

            % of Operations Expenditures.......................

$2,964,906

4.0%

$3,301,759

4.5%

$3,316,344

4.4%

     GRANTS, PERMANENT IMPROVEMENTS, AND REFUNDS EXPENDITURES - TOTAL

         % of Total Expenditures.................................

 

 

$25,906,193

25.8%

 

 

$34,579,148

31.9%

 

 

$38,507,745

33.8%

·         Cost of Property and Equipment.................

$190,402,931

$171,843,165

$170,069,841

SELECTED ACTIVITY MEASURES (Not Examined)

FY 2005

FY 2004

FY 2003

Number of Inspections by Division

       Agricultural Products.........................................

       Animal Health (Livestock/Auction Licensees).....

      Animal Disease Laboratories (tests performed)...

Environmental Programs (Nursery Dealers)........

Meat Inspections:

·            Livestock (Head)...................................

·            Plants/Brokers.......................................

·            Compliance Reviews..............................

Warehouses (Grain Examinations)......................

Weights & Measures (Devices)..........................

 

7,566

1,574

751,269

782

 

858,726

966

5,773

947

111,521

 

10,126

2,161

921,593

565

 

814,383

863

5,151

601

129,461

 

9,068

1,118

888,451

433

 

938,872

834

6,659

761

121,317

AGENCY DIRECTOR

 

 

 

During Audit Period: Mr. Charles A. Hartke

Currently:  Mr. Charles A. Hartke

 

 

 


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


The Department received $1,096,112 in efficiency initiative billings in FY04 and FY05

The Department could not provide documentation on any guidance for the FY04 billings detailing where savings were to occur

 

 

 

The Department did not make payments from line items where the cost savings were anticipated to occur but across different funds and line items

 

 

 

 

 


$400,000 toward the procurement initiative was paid from an appropriation to be used for a multi-purpose arena

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Interagency agreement with CMS had vague terms and questionable benefit to the Department

 

 

Agreement for “strategic marketing services”

 

 

 

 


Vendor paid $76,566

 

 

 

 

 

Department unable to provide documentation to evidence the vendor’s services provided

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


For 146 (44%) of 341 contracts processed the Department filed late filing or professional and artistic affidavits in fiscal year 2005

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The Department did not have written policies related to systems development

 

 

 

 

 

 

 

 

 


Systems were not consistently developed, thoroughly tested, or adequately documented

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Department did not have an adequate and tested disaster contingency plan

 

 

 

 


Plan was not tested in fiscal year 2005

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The Department did not comply with the State Officials and Employee Ethics Act

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Segregation of duties inadequate over the cash receipts of the Illinois Colt Stakes/Championship Purse Fund

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

6 of 10 recommendations from the Management Audit were not fully implemented

 

 

 

 


Background checks not performed

 

 

 

Rules not completed

 

 

 

Board members not required to attend exit conference or receive copies of exams

 

 

 

Policy manual not created regarding violations and corrective actions

 

 

Fund capacity not reevaluated

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

FINDINGS, CONCLUSIONS, AND

RECOMMENDATIONS

 

EFFICIENCY INITIATIVE PAYMENTS

 

The Department of Agriculture made payments for efficiency initiative billings from improper line item appropriations.

 

      Public Act 93-0025, in part, outlines a program for efficiency initiatives to reorganize, restructure and reengineer the business processes of the State.  The State Finance Act details that the amount designated as savings from efficiency initiatives implemented by the Department of Central Management Services (CMS) shall be paid into the Efficiency Initiatives Revolving Fund.  “State agencies shall pay these amounts…from the line item appropriations where the cost savings are anticipated to occur.” (30 ILCS 105/6p-5)

 

The Department received three FY04 billings and two FY05 billings for savings from efficiency initiatives totaling $1,096,112.  The billings were for procurement, information technology and vehicle fleet management efficiency initiatives. 

 

The Department could not provide documentation on any guidance for the FY04 billings from CMS detailing where savings were to occur.  Additionally, Department staff could not provide evidence of savings that CMS would have provided the Department for amounts billed during FY04. 

 

Based on our review, we question whether the appropriate appropriations, as required by the State Finance Act, were used to pay for the anticipated savings.  We found that the Department made payments in FY04 for these billings not from line item appropriations where the cost savings were anticipated to have occurred but based on an attempt to spread the payments across different funds and line item appropriations.  However, without specific guidance from CMS regarding the nature and type of savings initiatives, it is unclear whether these were the appropriate lines from which to make procurement savings payments.  For the FY04 payments we found:

 

·        The Department paid $400,000 toward the procurement initiative billing from an Illinois State Fair fund lump sum line item appropriated “to satisfy obligations related to the development, use and operation of a multi-purpose outdoor theater…”

·        The Department paid $90,300 toward the information technology billing in FY04 from personal services line item appropriations.

 

The FY05 billings contained more detail and it appears the Department paid these from proper appropriations.  (Finding 1, pages 10-12)

 

We recommended that the Department only make payments for efficiency initiative billings from line item appropriations where savings would be anticipated to occur.  Further, the Department should seek an explanation from the Department of Central Management Services as to how savings levels were calculated, or otherwise arrived at, and how savings achieved or anticipated impact the Department’s budget.

 

Department officials agreed with our recommendation and indicated the exceptions were corrected in FY05. 

 

QUESTIONABLE BENEFIT AND DOCUMENTATION RELATED TO INTERAGENCY AGREEMENT

 

The Department entered into an interagency agreement with the Department of Central Management Services (CMS) that had vague terms and questionable benefit to the Department, and was inadequately documented.

 

The Department entered into an interagency agreement on September 16, 2004 with CMS whereby the Department would pay up to $100,000 retainer fees including commission and travel expenses to a vendor for “strategic marketing services” beginning July 1, 2004 and concluding June 30, 2005.  The services to be provided were to include, but were not limited to, a State credit card program and beverage-vending program.

 

The Department paid the vendor $76,566.  The Department’s obligations under the interagency agreement mirrored CMS’s obligation to pay a monthly retainer fee to the vendor of $15,000 per month plus expenses.

 

The Department attributed two sponsorship agreements for the 2004 Illinois State Fair to the services of the vendor under the interagency agreement.  However, when auditors requested documentation to provide evidence of the vendor’s services in acquiring these sponsorships, the Department was unable to provide any documentation to that effect.   The Department provided no evidence that the vendor provided the State credit card program or beverage-vending program services as promised under the agreement.

 

Under the first sponsorship agreement the Department received a $25,000 sponsorship to be paid before May 31, 2004.  The Department entered into the agreement on August 9, 2004.  Under the second sponsorship agreement the Department is too receive $60,000 payable over five years, plus 16% of gross sales receipts.  The Department entered into this agreement on October 18, 2004 and has collected $24,000 through June 30, 2005.  (Finding 2, pages13-14)

 

We recommended the Department enter into interagency agreements that more clearly specify the terms and benefits to be received in exchange for payments made.  Also the Department should improve its documentation of contract performance.  Further the Department should reduce interagency agreements to writing before the commencement of services.

 

Department officials agreed with our recommendation and stated that any future interagency agreements would more clearly specify the terms and benefits to be received in exchange for payments made, would be reduced to writing before the commencement of services, and would improve its documentation of contract performance.

 

UNTIMELY PROCESSING OF CONTRACT OBLIGATION DOCUMENTS

 

The Department did not process contract obligation documents in a timely manner.

 

During our detailed testing of contractual obligation documents, we noted that the Department entered into 469 contracts in fiscal year 2004 and processed 13 (3%) late filing affidavits and 6 (1%) professional and artistic affidavits in fiscal year 2004. In fiscal year 2005 the Department entered into 341 contracts and processed 124 (36%) late filing affidavits and 22 (6%) professional and artistic affidavits.  The contracts ranged from 5 to 401 days late in fiscal year 2004 and from 4 to 201 days late in fiscal year 2005.  (Finding 3, page 15)

 

We recommended the Department improve its controls and procedures over contract obligation documents to minimize the use of the Late Filing Affidavits and Professional and Artistic Services Affidavits and work toward processing contract obligation documents in a timely manner.

 

Department officials agreed with our recommendation and stated it is monitoring contracts more closely to ensure timely filing.

 

WEAKNESSES IN COMPUTER SYSTEMS DEVELOPMENT METHODOLOGY

 

During the prior audit period, it was noted that the Department did not have written policies in place related to system development by external developers and did not assure all systems were consistently developed, thoroughly tested, and adequately documented.

 

During the prior audit period, the Department had contracted for $362,500 for the development of the Non-Fair Event System and the State Fair System.  It was noted that these systems were not adequately documented and were developed in a software language that was not supported by the Department.

 

During the current audit period, we determined that the Department still has not developed written policies to address the areas noted above and did not assure all systems were consistently developed, thoroughly tested, and adequately documented.  (Finding 5, pages 17-18)

 

We recommended the Department update its Systems Development Methodology to include procedures related to new system developments and modifications to existing systems by external developers. 

 

Department officials agreed with our recommendation and indicated it would update its System Development Methodology to include procedures related to all work performed by external developers.  In addition, the Bureau of Computer Services has advised all program managers that any specific Information Systems needs are to be communicated to, reviewed by, and approved by the Bureau of Computer Services.

 

DISASTER CONTINGENCY PLAN FOR COMPUTER SYSTEMS NOT ADEQUATE

 

During the prior audit period, it was noted that the Department did not have an adequate and tested comprehensive disaster contingency plan to ensure its critical computer systems can be recovered in the event of a disaster. 

 

The Department has been migrating from a mainframe to a LAN environment; however, its Crisis Management/Disaster Recovery Plan (Plan) has not been updated to reflect the change.  The Plan, last updated in January 2005, only provided a framework for developing an appropriate response to a disaster event that would impact the Department.  The Plan was not comprehensive and did not contain detailed procedures for recovering the Department’s computer operations.  

 

It was also noted that the Plan was not tested during fiscal year 2005.  (Finding 6, pages 19-20)

 

We recommended the Department update its Crisis Management/Disaster Recovery Plan to reflect the current environment and ensure it is adequate for recovering its computer operations within an acceptable timeframe.  The Department should perform routine testing at least annually to assure the Plan is adequate for recovering the Department’s current operational environment.

 

Department officials agreed with our recommendation and indicated they would update its Disaster Recovery/Business Continuity Plan to reflect the current IT environment. 

 
LACK OF ADEQUATE TIME REPORTING

 

The Department did not maintain adequate time sheets of time worked by employees as required by the State Officials and Employees Ethics Act (Act).

 

The Department did not maintain a positive timekeeping system for its employees documenting time spent on official state business in quarterly hour increments.  The Department had also not updated its personnel policy to comply with the Act. 

 

The Act (5 ILCS 430/5-5(c)) requires the Department to develop a personnel policy for all employees to document their time.  The Act requires all employees to complete a time sheet documenting hours worked each day on official state business to the nearest quarter hour.  (Finding 7, page 21)

 

We recommended the Department update its personnel policies and continue implementing the requirement to complete timesheets documenting hours worked each day on official State business to the nearest quarter hour for all employees.

 

 

Department officials agreed with our recommendations and indicated it had implemented the recommendations as of June 1, 2005.

 

INADEQUATE SEGREGATION OF DUTIES OVER CASH RECEIPTS OF THE ILLINOIS COLT STAKES/CHAMPIONSHIP PURSE FUND

 

The Department did not have an adequate segregation of duties over the cash receipts of the Illinois Colt Stakes/Championship Purse Fund.

 

The person responsible for preparation of the deposit slips for the Purse Fund also delivered the deposits to the bank, received the monthly bank statements, performed the monthly bank reconciliations, and prepared the locally held funds quarterly report of receipts and disbursements submitted to the Comptroller.  Management personnel did not perform a supervisory review of the Purse Fund deposits, reconciliations or reports.  The amount of deposits during fiscal years 2004 and 2005 within the Purse Fund was $1,883,000 and $1,811,000, respectively.

 

Good internal control procedures require that either duties be adequately segregated or management oversight controls be strengthened to compensate for instances where an adequate segregation cannot be achieved.  (Finding 10, page 25)

 

We recommended the Department allocate the resources necessary to either implement compensating management controls or segregate duties over the fiscal operations of the Purse Fund.

 

Department officials agreed with our recommendation and stated it is developing policies and procedures for cash receipts that provide segregation of duties. 

 
STATUS OF RECOMMENDATIONS IN MANAGEMENT AUDIT OF THE REGULATION OF GRAIN DEALERS AND WAREHOUSEMAN

 

The Department did not fully implement six of ten recommendations presented in the Management Audit – Regulation of Grain Dealers and Warehouseman and the Administration of the Grain Insurance Fund (Management Audit) conducted by the Office of the Auditor General.  The audit was released in December 2003 pursuant to the Legislative Audit Commission Resolution Number 125. 

 

During the current examination period we noted the following:

 

¨       The Department did not perform background checks and has no formal written policy and procedure regarding the tracking of individuals whose licenses have been terminated or revoked. 

 

¨       The Department, in conjunction with other interested parties, has been attempting to finalize promulgated rules for the new examination process as outlined in Public Act 93-225 but have not been able to complete them at this time. 

 

¨       The Department’s current policy also does not require at least one board member at the exit conference, nor are Board members required to receive copies of exams. 

 

¨       The Department’s current policy also does not establish guidelines for notification of successor agreements and   the Department has not created a policy manual regarding violations and corrective actions.

 

¨       The Department has not performed a re-evaluation of the Fund’s capacity to pay claims.  (Finding 15, pages 30-35)

 

 

We recommended the Department:

 

¨       Allocate the resources necessary to conduct background checks of all license applicants including its officers, directors, partners and managers and track the information on the database established by the Department.

¨       Continue in its efforts to complete the examination guidelines and include in those guidelines:

·        Guidelines for notification of successor agreements and closeout examinations;

·        Requirements to provide copies of examination reports to licensee board members, directors, and owner of licensees;

·        Promulgate rules to implement the examination process delineated in Public Act 93-225;

·        Guidelines for taking and tracking corrective action;

¨       Evaluate the Grain Insurance Fund’s current capacity to pay claims and continue to periodically review the Fund’s capacity to pay claims in the future.

 

Department officials agreed with our recommendation and stated it has taken steps to address the auditors’ recommendations. 

 

OTHER FINDINGS

 

The remaining findings are reportedly being given attention by the Department.  We will review progress toward implementing our recommendations in our next examination.

 

Mr. Laura Lanterman, Chief Fiscal Officer, provided the responses to our findings and recommendations. 

 

 

 

_______________________________________

WILLIAM G. HOLLAND, Auditor General

 

 

WGH:JAF:pp

 

 

 

SPECIAL ASSISTANT AUDITORS

 

McGladrey & Pullen LLP were our special assistant auditors for this State compliance examination.