< Previous page ^ Table of Contents Next page >

Appendix III

Notes by John Bray:

1. The spreadsheet does not form part of the University's accounts. It was reconciled to the University accounts at 31 July 2000 and agreed by the Finance Division Management Accountants as at that date. Information available in the early days of CUFS did not facilitate reconciliations and none have been attempted since although regular checks of expenditure against allocations have been a feature of the exercise.

2. At the request of the Steering Committee, the cost of Year 1 Oracle licences paid in advance (£188,714) was not included in the spreadsheet.

3. KPMG Project Management instructed that interest earned could be used as income. Interest due since Feb-01 has only recently been posted [as at preparation July 2001].

4. A check of expenditure against allocations can be seen as follows:
Overall Project Cost per s'sheet 9,192,601
LESS Transitional costs 328,849
 
8,863,752
Year 1 Oracle licences 188,714
Oracle invoices awaited (max.) 105,000
 
  9,157,466
 
Allocations
(£4,720K+£3,245K+£444K)
8,409,000
Grant for Year 1 Oracle licences 188,714
FD at 31/7/00 (Phase III Cons'y.) 198,289
Interest earned to Feb-01 363,912
 
  9,159,915
 

Further Notes:

1. We have details of ex-gratia payments only for the Departments within a single School (Physical Sciences) of which there were 42, 24 of £500 and 18 of £300 totalling £17,400. Presumably we can extrapolate this across the University

2. £511k was allocated for extra recurrent resources in departments, of which £471k [as at preparation July 2001] has been claimed.

3. Additional recurrent resources in the Finance and Management Information Services Division cannot be immediate determined. £585k is given for CUFS additional costs as an increase in expenditure item on 'Reconciliation of Changes on the Chest Out-Turn'.

CAPSA project costs. All figures include (net) VAT.

Budget headings Project
delivery
(to 25 Aug 2000)
Post go-live
support
Project
total to
31 Dec 2000
Project exp.
Jan-01 to
Jul-01
Transitional
Support 2000-01
(Non-recurrent)
Project
total to
Jul-01

Licences
Functional and reporting 1,151,987  1,151,987   1,151,987
Tutor 77,559  77,559  77,559
Noetix 28,243  28,243  28,243
 1,257,789 1,257,789  1,257,789
Oracle Training 476,625 476,625  476,625
Project infrastructure
Training rooms 44,950  44,950  44,950
Project offices 6,560 6,560   6,560
Desk top environment 75,403  75,403   75,403
Communications 4,624  4,624  4,624
 131537 131,537  131,537
Central server
Server and UPS 576,298 576,298   576,298
Machine room 73,655 73,655  73,655
General equipment 6,525 6,525   6,525
 656478 656,478  656,478
Staff Costs
'Solutions' consultants
Costs to 30/09/991,376,140 1,376,140  1,376,140
 
From 1/10/99:-
Oracle staff 930,087 930,087   930,087
KPMG staff 1,672,511 1,672,511  1,672,511
Other agencies62,930 62,930   62,930
4,041,668 4,041,668  4,041,668
'Change & Comms.' Consultants
From 1/10/99:-
KPMG staff609,933 609,933   609,933
Other agencies 37,039  37,039  37,039
 646972 646,972  646,972
Internal Staff 173,055 173,055  173,055
Post go-live support
Oracle staff  238,258238,25813,575193,897445,730
KPMG staff 540,482540,48268,85422,103631,439
Other agencies 154,450154,450152,293112,849419,592
  933,190933,190234,722328,8491,496,761
TOTAL STAFF COSTS4,861,695933,1905,794,885
234,722
328,8496,358,456
Project overheads
Stationery and printing 32,1406,15238,292979 39,271
Telephones40,467 40,4673,754 44,221
Consultants accommodation 36,02435836,382647 37,029
General 85,072102,701187,7733,422 191,195
 193,703109,211302,9148,8020311,716
 
Total7,577,8271,042,4018,620,228243,524328,8499,192,601
Cross-cast check0


< Previous page ^ Table of Contents Next page >

Cambridge University Reporter, 2 November
Copyright © 2011 The Chancellor, Masters and Scholars of the University of Cambridge.