REPORT DIGEST

 

DEPARTMENT OF COMMERCE AND ECONOMIC OPPORTUNITY

 

COMPLIANCE EXAMINATION

For the Two Years Ended:

June 30, 2004

 

Summary of Findings:

Total this report:                     11

Total last report:                       8

Repeated from last report:         1

 

Release Date:

April 6, 2005 

 

 

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 is also available on

the worldwide web at

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

 

 

 

 

 

 

 

SYNOPSIS

 

 

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

 

¨      Customer Information System did not meet Department needs.

 

¨      The Department had inadequate controls over fringe benefits for the personal use of a State vehicle.

 

¨      The Department had inadequate controls over employee timekeeping.

 

¨      The Department had untimely reviews of grantee audit reports.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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

 

 

 


DEPARTMENT OF COMMERCE AND ECONOMIC OPPORTUNITY

COMPLIANCE EXAMINATION

For The Two Years Ended June 30, 2004

 

EXPENDITURE STATISTICS

FY 2004

FY 2003

FY 2002

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

$944,841,593

$844,567,814

$828,325,157

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

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

$60,035,122

6.35%

$60,634,171

7.18%

$102,845,079

12.42%

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

           % of Operations Expenditures.

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

$15,841,028

26.39%

519

$18,863,188

31.11%

485

$18,837,058

18.32%

518

         Other Payroll Costs (FICA, Retirement, Group Insurance)........

           % of Operations Expenditures...

 

$4,670,990

7.78%

 

$5,104,079

8.42%

 

$5,219,216

5.07%

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

           % of Operations Expenditures...

$7,222,513

12.03%

$6,605,264

10.89%

$7,777,559

7.56%

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

           % of Operations Expenditures                

$32,300,591

53.80%

$30,061,640

49.58%

$71,011,246

69.05%

     AWARDS AND GRANTS TOTAL......

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

     DEBT SERVICE TOTAL.......................

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

     PERMANENT IMPROVEMENTS AND REFUNDS TOTAL.................................

         % of Total Expenditures                         

$871,096,013

92.20%

$13,697,063

1.45%

 

$13,395

0.00%

$769,831,098

91.15%

$12,846,481

1.52%

 

$1,256,064

0.15%

$706,596,022

85.30%

$13,617,991

1.64%

 

$5,266,065

0.64%

 

     Cost of Capital Assets.......................

$13,475,222

$12,252,661

$12,565,609

 

CASH RECEIPTS

FY 2004

FY 2003

FY 2002

From Federal Agencies....................................

Licenses and Fees............................................

Interest and Other Investment Income...............

Royalties and Loan Repayments.......................

Other..............................................................

         Total......................................................

$375,368,974

11,639,109

5,370,061

2,537,435

10,629,057

$405,544,636

$205,675,152

8,194,488

6,356,599

3,727,683

14,661,200

$238,615,122

$194,673,734

8,876,428

11,699,905

3,424,380

6,991,947

$225,666,394

 

 

AGENCY DIRECTOR

     During Examination Period:  Jack Lavin (2/4/03 through 6/30/04)

                                                Joseph Hannon, Acting (11/21/02 through 2/3/03)

                                                Pam McDonough (7/01/02 through 11/20/02)

 

     Currently:  Jack Lavin

 


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Department did not receive guidance or documentation with the billings from CMS

 

 

 

 

 

 

 

Efficiency initiative payments were made from programs funds it controls

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Efficiency initiative payments totaled $1,706,013

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Needs were not met and the system was not adequately documented after $4 million investment

 

 

 

 


Contract payments totaled $1,451,290

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Employees were not charged a total of $2,652 for their personal use of a State Vehicle

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Only 13% of the Department’s employees were required to maintain daily timesheets

 

 

 

 

 


State Officials and Employees Ethics Act Requirements

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Grants totaling $3,554,816 were reviewed late

 

 

 

FINDINGS, CONCLUSIONS, AND RECOMMENDATIONS

 

PAYMENTS WERE MADE FOR EFFICIENCY INITIATIVE BILLINGS FROM IMPROPER LINE ITEM APPROPRIATIONS

 

      The Department 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.  The Act further requires State agencies to pay these amounts from line item appropriations where cost savings are anticipated to occur.

 

      The Department did not receive guidance or documentation with the billings from CMS detailing from which line item appropriations savings were anticipated to occur.  The only guidance received was the amount of payments that should be taken from General Revenue Funds versus other funds for the September 2003 billings.  However, the Department questioned this breakdown with the Governor’s Office of Management and Budget (GOMB).

 

      The Department made payments for billings not from line item appropriations where the cost savings were anticipated to have occurred but according to Department staff, “given the ambiguous parameters of how the savings were to be realized, the agency felt it was most appropriate to spread the savings to be realized among the program funds over which it controls.”  The Department planned to reconcile budgeted savings to actual savings based on periodic reports to be provided by CMS; however, those periodic reports were not provided by CMS to the Department.  The Department used:

 

·        $456,000 from appropriations from the Tourism Promotion Fund (Fund #0763) to make payments for invoices relative to savings from Procurement and Information Technology Efficiency Initiatives

·        $91,000 from appropriations from the Tobacco Settlement Recovery Fund (Fund #0733) to make payments relative to the Information Technology Efficiency Initiative

·        $50,000 from an appropriation “For Expenses Relating to Compliance with the Belgium Social Security System” to make payments for the Procurement Efficiency Initiative

·        $32,685 from appropriations from the Renewable Energy Resources Trust Fund (Fund #0564) to make a payment for the Procurement Efficiency Initiative 

·        $68,938 from appropriations from the Energy Efficiency Trust Fund (Fund #0571) to make a payment for the Procurement Efficiency Initiative. 

 

      The Department paid a total of $1,706,013 for the efficiency initiative billings.  (Finding 1, pages 10-13)

 

      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 accepted our finding and recommendation and stated they will only make Efficiency Initiative Revolving Fund payments from appropriations where savings are anticipated to occur.

 

 

CUSTOMER INFORMATION SYSTEM DOES NOT MEET DEPARTMENT NEEDS

 

In the prior audit, the Department did not ensure compliance with the Application System Development Standards (Standards) and had not determined the total estimated cost of the complete Customer Information System (CIS) project. 

 

In the current examination, CIS did not meet the needs of the Department and was still not adequately documented.  Since its inception, the Department has invested approximately $4 million in CIS, and has spent over $2.2 million on contractors to develop and maintain CIS.  The following contractual expenditures were incurred during fiscal years 2003 and 2004:

 

·        In 2003, the Department spent $948,370 for 8,769 contract hours.

·        In 2004, the Department spent $502,920 for 4,567 contract hours.  (Finding 2, pages 14-15)  This finding was first reported in 2002.

 

We recommended that the Department conduct an extensive study to determine the feasibility and effectiveness of CIS, and whether the system will meet its long term needs.  A final decision regarding a solution to the CIS situation should be made as soon as possible, to reduce the time and funds invested in a system that does not meet the Department’s needs, and to ensure funds are expended in an effective manner.  We further recommended, that the Department ensure all future projects are developed in accordance with acceptable system development standards, and include total cost projections and adequate documentation.

 

      Department officials accepted our finding and recommendation and stated that the Department weighed the options of whether to complete the initial Customer Information System (CIS) design, upgrade the system or replace the system.  The Department’s Information Technology Steering Committee decided to replace and phase out CIS.  In July 2004, the requirements and processes necessary to reengineer the CIS Application to a Microsoft.NET platform were formulated.

 

NEED TO IMPROVE CONTROLS OVER FRINGE BENEFITS FOR THE PERSONAL USE OF A STATE VEHICLE

 

The Department did not have adequate policies and procedures in place to ensure employees assigned State vehicles for their personal use were charged the correct amount for fringe benefits.  Three employees that were assigned a State vehicle for their personal use were not charged for the fringe benefit during FY03 or FY04.  The three employees should have been charged a total of $2,652 for fringe benefits during FY03 and FY04.  (Finding 5, pages 20-21)

 

We recommended the Department comply with the Internal Revenue Service Publication and the Comptroller’s Bulletin 3-85 and implement controls to ensure employees complete the proper documentation and are charged the correct amount of fringe benefits on payroll warrants.

 

      Department officials accepted our finding and recommendation and stated that the Department will implement procedures to ensure compliance with Comptroller’s Payroll Bulletin 3-85 and the Internal Revenue Service Publication for fringe benefit calculations and reporting for personal use of State vehicles.  The Department is also working with the Office of the Comptroller to make any necessary fringe benefit reporting or filing adjustments for affected employees for calendar years 2003 and 2004.

 

 

NEED TO IMPROVE CONTROLS OVER EMPLOYEE TIMEKEEPING

 

The Department does not have adequate policies to require all of the Department’s employees complete daily timesheets. 

 

The Department had personnel policies in regard to timekeeping, but the Department only required “Senior Staff and Policy Making Employees” to maintain a daily timesheet which documents the time spent each day on official State business.  The remainder of the Department’s employees were not required by the Department to maintain any daily timesheet.  The Department had an average of 519 employees at June 30, 2004 and the Department only required 65 (13%) employees to prepare timesheets. 

 

The State Officials and Employees Ethics Act (5 ILCS 430/5-5) requires each State employee to periodically submit timesheets documenting the time spent each day on official State business to the nearest quarter hour. (Finding 6, page 22-23)

 

We recommended the Department comply with the timekeeping requirements of the State Officials and Employees Ethics Act by preparing and maintaining the required timesheets for all State employees.

 

      Department officials stated that the Department uses the Department of Central Management Services’ (CMS) timekeeping system to maintain accurate daily attendance and timekeeping records for all employees.  The Department was operating under the assumption that CMS’ timekeeping system was adequate in terms of compliance with the intent of the State Officials and Employees Ethics Act (the Act) for non-management employees.  The Department’s management employees have kept separate timesheets for the Act in addition to the timesheets required for CMS’ timekeeping system.  Section 5-5(a) of the Act requires the Governor to adopt and implement policies for all State employees of the executive branch under his jurisdiction.  The Department has notified the Governor’s Office of this finding and will continue to work with them to determine an appropriate course of action to comply with the intent of the Act.

 

UNTIMELY REVIEWS OF GRANTEE AUDIT REPORTS

 

The Department did not review audit reports for Technology and Industrial Program grants in a timely manner.  During detail testing, we noted the following:

 

·        Two of ten (20%) grantees’ audit reports, totaling $3,554,816, were reviewed late.  One review was 9 days late; the other audit report had not been reviewed at all.

·        One of ten (10%) grantees, totaling $316,589, submitted its audit report to the Department 238 days late.  The submitted audit report consisted of a photocopy of the 2002 balance sheet, which does not meet the requirements set forth by the grant agreement.  This inadequacy went unnoticed by the Department.  (Finding 10, page 30)

 

We recommended the Department comply with the Department’s Audit Management and Resolution Procedures to ensure audit reports are reviewed timely.  We further recommended the Department ensure that all deliverables received from grantees complies with the grant agreement requirements.

 

      Department officials accepted our finding and recommendation and stated that the Department agrees the audits identified in the finding were not reviewed in a timely manner due to staffing shortfalls.  Additional staff have been added to this unit to address the audit review backlog.

 

OTHER FINDINGS

 

      The remaining findings were less significant and are reportedly being given attention by the Department.  We will review the Department’s progress toward implementation of our recommendations in our next compliance examination.   

 

      Mr. Scott Harry, Chief Financial Officer of the Department of Commerce and Economic Opportunity provided the Department's responses.

  

 

AUDITORS’ OPINION

 

      We conducted a compliance examination of the Department of Commerce and Economic Opportunity as required by the Illinois State Auditing Act.  We have not audited any financial statements of the Department for the purpose of expressing an opinion because the Department does not, nor is it required to, prepare financial statements. 

 

 

 

 

 

___________________________________

WILLIAM G. HOLLAND, Auditor General

 

WGH:TLD:pp

 

AUDITORS ASSIGNED

 

      This examination was performed by the Office of the Auditor General’s staff.

 

DIGEST FOOTNOTES

 

#1    CUSTOMER INFORMATION SYSTEM DOES NOT MEET DEPARTMENT NEEDS – Previous Department Response

 

2002:     The Department partially agrees with this recommendation.  The Department believes it met the criteria for a quality assurance team and for adequate documentation.  The Department is in the process of preparing an updated long-range cost estimate and analysis for the Customer Information System project.