Select Committee on Public Accounts Minutes of Evidence


APPENDIX 3

INTERVENTION BOARD EXECUTIVE AGENCY: APPROPRIATION ACCOUNTS (PAC 97-98/268)

SUPPLEMENTARY NOTES SUBMITTED BY THE INTERVENTION BOARD

QUESTION 77-78 THE PUBLIC ACCOUNTS COMMITTEE ASKED TO BE INFORMED WHAT THE COST TO THE EXCHEQUER WAS AS A RESULT OF THE DELAY IN RECOVERING EXPENDITURE FROM THE EUROPEAN COMMISSION

  1. Difficulties with a number of financial reports (now resolved) resulted in delays in recovering some £19 million in reimbursements from the European Commission (C&AG Report, paragraph 14).

  2. The £19 million related to some 300 transactions which were not linked for reporting purposes within the chart of accounts for varying periods throughout the year.

  3. We have undertaken an exercise which analysed the expenditure from the time it should have been claimed to the point when the claim was actually made. Based on a flat rate of interest of 6 per cent, we calculate the cost to the Exchequer to have been £758,000.

QUESTIONS 93-97 IMPACT ON PERFORMANCE RELATED PAY

  The Public Accounts Committee asked what effect the IB's accounting failures had had on staff remuneration, particularly the payment of bonuses.

  2. All senior staff at IB are on performance-related pay. The Agency has three primary internal indicators, or targets, relating to the timeliness and accuracy of accounts, and since none of these were met for 1996-97, staff appraisal for those responsible for achieving the targets has taken account of the failures. The impact on pay will be felt in the next pay award, which will be differentiated according to performance.

  3. The Chief Executive is the only staff member whose pay is enhanced by a bonus scheme. There are no accounting criteria built into his targets, but his bonus is also varied according to the overall assessment of his performance under the annual senior Civil Service Performance Review. His performance review for 1997 reflects the agency's poor performance on accounts, and will therefore reduce the bonus available to him.

THE ROLE OF CONSULTANTS DURING THE IMPLEMENTATION OF THE INTEGRATED ACCOUNTS SYSTEM (IAS)

QUESTION 134 AND CHAIRMAN'S CLOSING REMARKS

Introduction

  1. This note responds to Committee's requests for details of the specific advice sought from the consultants employed during the development of the Agency's integrated accounts system, their contractual terms and the quality of advice provided.

  2. The attached table provides a summary of the information sought with appropriate cross references to the NAO report.

Contractual Arrangements

  3. Throughout the development of the IAS all contracts were let in accordance with recognised procurement policy, most being subject to competitive/open tender. In phases 1 and 2 most contracts were based on time and materials with certain fixed price elements which was general practice at the time. In phase 3 the main contracts were fixed price.

Key Deliverables and the Quality of Advice Provided

  4. During the Accounts Project development and subsequently, consultants have provided a range of services and deliverables covering routine application support and maintenance, technical accountancy support as well as advice on technical implementation. In addition the Oracle License has provided for fault correction and software upgrades.

  5. The following paragraphs summarise the key deliverables for each of the phases of the Accounts Project together with an overview of the quality of the advice provided.

  6. The key deliverables from the Price Waterhouse contract for phase 1 of the Accounts Project were two external assurance reports and support for user acceptance testing. The reports included specific recommendations and revised implementation plans were approved as a result. The support of acceptance testing overcame a skills shortage at IB and enable comprehensive testing to be carried out. The quality of the advice was acceptable and met contract requirements.

  7. Advice provided by Oracle consultants in phase 1 of the Accounts Project included analysis of requirements, design of system and system tested software. In general the advice provided was acceptable although due to Oracle staff's inexperience (see paragraph 19 of the report) there was need to change the team leader. In recognition of this we received free consultancy time.

  8. The key deliverables from phase 2 of the Accounts Project were provided by Oracle (system tested software and functional review) and Price Waterhouse (documentation of accounting policy). The quality of the advice and support provided was acceptable and met contractual requirements.

  9. The independent contractors who supported phase 1 of the Accounts project provided analysis and design documentation and system tested software. The quality of advice and support provided was acceptable and met contract requirements.

  10. The programme management advice provided by Price Waterhouse in the initial stages of Phase 3 included a series of reports which led to the production of a Statement of Service Requirement. These were provided in accordance with contractual requirements and to an acceptable standard.

  11. The main implementation of phase 3 was undertaken by KPMG and consisted of a technical implementation and change management consultancy. The deliverables from the technical implementation were analysis, design, system tested software and procedures. The deliverables from the change management consultancy were a communications strategy, training strategies and a review of the Finance Division organisation. The quality of the advice and support provided was acceptable and met contractual requirements. However, with our agreement the completion of some software remained outstanding, as result of which we received a financial settlement at the end of the contract. It is now clear that reconciliations necessary to manage the integrated system were underestimated by the KPMG Change Management team and ourselves.

  12. The analysis, design and delivery of system tested interface software by Sherwood and KPMG was acceptable and met contract requirements.

  13. The application support provided by the Data Sciences and IBM Global Services for phases 1, 2 and 3 covering fault reports and change requests was acceptable and met contract requirements.

  14. The Accounts Receivable study conducted by IBM required a review of processes to establish whether system or procedural faults existed. The advice provided was acceptable and met contractual requirements.

  15. The advice by KPMG in a contract commencing October 1997 (paragraphs 27-28 of the report) is still ongoing. Its deliverables consist of a reconciliation strategy, a series of reports and procedures. To date the work is acceptable and in accordance with contractual requirements.

  16. The work of the independent accountants is also ongoing and covers reconciled accounts, procedures, training and control checks. To date the work is acceptable and in accordance with contractual requirements.

  17. The support provided by Oracle under standard license agreements requires the correction of any software faults and delivery of software upgrades. Whilst these are provided in accordance with the license agreement the Agency has experienced varying levels and quality of support. In order to enhance her level of service the Agency now has regular meetings with Oracle to monitor progress on fault corrections and enhancements. Recently Oracle has set up a Public Sector Customer Satisfaction Team.

Intervention Board

April 1998

Intervention Board—Accounts Project Contracts

ConsultantsType of contractKey deliverables NAO Report paragraph number Basis Cost
£

Accounts project phases 1 and 2
January 1990 to December 1993
Price Waterhouse (phase 1)Competitive procurement External assurance reports acceptance test support 18-19Time and materials with some fixed price elements 72,378
Oracle UK Ltd (phase 1)Single tender Analysis of requirement, Design of system and system tested software18-19Time and materials
Data sciences, Myriad and WS Atkins (phase 1) Myriad, SBS and PE International (phase 1)Competitive procurement Analysis documentation18-19Time and materials, call off contracts (framework agreement) )
)
)
)
)
)
)
)
)  4,315,076
)
)
)
)
)
)
)
)
)
Competitive procurement Design and documentation and system tested software18-19Time and materials, call off contracts (framework agreements)
Oracle UK Ltd (phase 2)
Competitive procurement extension to existing contract System tested software18-19Fixed price
Functional review report 20Time and materials
Price Waterhouse (phase 2) Extension to existing contractDocumenting Accounting policy 18-19Time and materials with some fixed price elements 911,441
IB Staff costs1,341,598

Subtotal6,640,493
Applications
support for phases
1 and 2 November 1993 to April 1996
Data sciencesOpen procurement Ongoing maintenance (fault reports/change requests) Time and materials547,597
Phase 3 January 1995 to May 1996Price Waterhouse Extension to existing contractProgramme management 21-23Fixed price and time and materials 229,618
KPMGOpen procurement Analysis, design and system tested software 21-23Fixed price—technical implementation 1,724,085
Organisation review, communications and training strategies 21-23Fixed price—change management 666,604
SherwoodOpen procurement Analysis, design and system tested interface software 21-23Time and materials 153,775
KPMG (IMD/ETD support) Open procurementAnalysis, design and system tested interface software 21-23Time and materials 242,228
CCTA Procurement support21-23Time and materials 10,649
Application support
for phase 3
(September 1995 to March 1997)
IBM Global
services
Open procurement Ongoing maintenance (Fault reports/Change requests) Time and materials433,388

Subtotal3,460,347
Additional
activities since implementation
May 1996 to
March 1997
KPMG—ConsultancySingle tender Reconciliation strategy/procedures27-28 Time and materials113,500
KPMG—Contract accountants Single tenderReconciled accounts 27-28Time and materials 94,000
Independent accountants Employment
agency
Reconciled accounts procedures, training and control checks 28Time and materials 109,075
IBM Global servicesOpen Procurement New reconciliation reports28 Time and materials190,880
IBM Global servicesOpen Procurement AR study report25Fixed price 17,600

Subtotal525,055
IAS Application support April 1997 to March 1998 IBM Global
services
Open Procurement Ongoing maintenance (fault reports/change requests) Time and materials402,000

Subtotal402,000
Oracle licence 1990-97**Includes all
Oracle systems
Open ProcurementFault corrections and upgraded software Cost negotiated annually 455,898

Subtotal455,898

Intervention Board

April 1998


 
previous page contents next page

House of Commons home page Parliament home page House of Lords home page search page enquiries

© Parliamentary copyright 1998
Prepared 16 July 1998