cra_form by liamei12345

VIEWS: 5 PAGES: 26

									                                                   HOW TO USE THIS SPREADSHEET

Any questions? Phone Treasury on 0207 270 6170
Or email: Mohammad.Huq@hmtreasury.gsi.gov.uk
Or email: Simon.Eder@hmtreasury.gsi.gov.uk


Changes from the last exercise
The most significant change since the last CRA is the timing of the exercise. In previous years the CRA dataset from COINS was
consistent with Winter Supplementary Estimates. This time the data will be consistent with outturn released at PEOWP (July) instead. For
the current financial year, we will use the latest figures available from COINS at the time of the exercise. The change to the timetable will
mean that the CRA will no longer be published in PESA but is likely to be published together with the quarterly PESA National Statistics
release in October 2011.

Otherwise measures we introduced at the last CRA to make the forms shorter and less burdensome have been carried over into this
year's exercise. These measures include removal of smaller PO Groups which fall below a certain threshold and the removal of plan years
so that the form covers a six-year period from 2005-06 to 2010-11. Furthermore, splits from the previous CRA have been used to pre-
populate the forms for 2005-06 to 2008-09, leaving only 2009-10 and 2010-11 for departments to complete.




In the CRA form:
The blue and dark blue lines are for information only
The light blue lines contain the CRA data returns
The bottom two rows of each section are checks to control if the allocated expenditure equals the information from COINS


PLEASE DO NOT:
Please do not change the colours or structure of the rows or columns of this spreadsheet, as that would prevent Treasury processing
these returns
Please do not delete or cut any sections of the CRA forms. You are welcome to copy them - see below. But the whole form must be
returned in its original state
                                  Departmental Report Table
                                 Regional Distribution Totals
                                     2005-06 2006-07 2007-08 2008-09 2009-10
SCOTLAND                                   0.0        0.0       0.0      0.0      0.0
WALES                                      0.0        0.0       0.0      0.0      0.0
NORTHERN IRELAND                           0.0        0.0       0.0      0.0      0.0
ENGLAND_North East                         0.0        0.0       0.0      0.0      0.0
ENGLAND_North West                         0.0        0.0       0.0      0.0      0.0
ENGLAND_Yorkshire and the Humber           0.0        0.0       0.0      0.0      0.0
ENGLAND_East Midlands                      0.0        0.0       0.0      0.0      0.0
ENGLAND_West Midlands                      0.0        0.0       0.0      0.0      0.0
ENGLAND_East                               0.0        0.0       0.0      0.0      0.0
ENGLAND_London                             0.0        0.0       0.0      0.0      0.0
ENGLAND_South East                         0.0        0.0       0.0      0.0      0.0
ENGLAND_South West                         0.0        0.0       0.0      0.0      0.0
OUTSIDE UK                                 0.0        0.0       0.0      0.0      0.0
Grand Total ( £'s Million)                 0.0        0.0       0.0      0.0      0.0
                                     Regional Distribution Percentages
SCOTLAND                              #DIV/0!    #DIV/0!   #DIV/0!  #DIV/0!  #DIV/0!
WALES                                 #DIV/0!    #DIV/0!   #DIV/0!  #DIV/0!  #DIV/0!
NORTHERN IRELAND                      #DIV/0!    #DIV/0!   #DIV/0!  #DIV/0!  #DIV/0!
ENGLAND_North East                    #DIV/0!    #DIV/0!   #DIV/0!  #DIV/0!  #DIV/0!
ENGLAND_North West                    #DIV/0!    #DIV/0!   #DIV/0!  #DIV/0!  #DIV/0!
ENGLAND_Yorkshire and the Humber      #DIV/0!    #DIV/0!   #DIV/0!  #DIV/0!  #DIV/0!
ENGLAND_East Midlands                 #DIV/0!    #DIV/0!   #DIV/0!  #DIV/0!  #DIV/0!
ENGLAND_West Midlands                 #DIV/0!    #DIV/0!   #DIV/0!  #DIV/0!  #DIV/0!
ENGLAND_East                          #DIV/0!    #DIV/0!   #DIV/0!  #DIV/0!  #DIV/0!
ENGLAND_London                        #DIV/0!    #DIV/0!   #DIV/0!  #DIV/0!  #DIV/0!
ENGLAND_South East                    #DIV/0!    #DIV/0!   #DIV/0!  #DIV/0!  #DIV/0!
ENGLAND_South West                    #DIV/0!    #DIV/0!   #DIV/0!  #DIV/0!  #DIV/0!
OUTSIDE UK                            #DIV/0!    #DIV/0!   #DIV/0!  #DIV/0!  #DIV/0!
Grand Total (percent)                 #DIV/0!    #DIV/0!   #DIV/0!  #DIV/0!  #DIV/0!
2010-11
     0.0
     0.0
     0.0
     0.0
     0.0
     0.0
     0.0
     0.0
     0.0
     0.0
     0.0
     0.0
     0.0
     0.0

 #DIV/0!
 #DIV/0!
 #DIV/0!
 #DIV/0!
 #DIV/0!
 #DIV/0!
 #DIV/0!
 #DIV/0!
 #DIV/0!
 #DIV/0!
 #DIV/0!
 #DIV/0!
 #DIV/0!
 #DIV/0!
PO Group key details (to create subtotals for CRA
form when in Excel)                                 PO Group        PO Group Alias
P00 S123456 A-CUR CG Information                    P00 S123456     P00 S123456 PO Group A
P00 S123456 A-CUR CG Information Total
P00 S123456 A-CUR CG CRA Return                     P00   S123456   P00   S123456   PO   Group   A
P00 S123456 A-CUR CG CRA Return                     P00   S123456   P00   S123456   PO   Group   A
P00 S123456 A-CUR CG CRA Return                     P00   S123456   P00   S123456   PO   Group   A
P00 S123456 A-CUR CG CRA Return                     P00   S123456   P00   S123456   PO   Group   A
P00 S123456 A-CUR CG CRA Return                     P00   S123456   P00   S123456   PO   Group   A
P00 S123456 A-CUR CG CRA Return                     P00   S123456   P00   S123456   PO   Group   A
P00 S123456 A-CUR CG CRA Return                     P00   S123456   P00   S123456   PO   Group   A
P00 S123456 A-CUR CG CRA Return                     P00   S123456   P00   S123456   PO   Group   A
P00 S123456 A-CUR CG CRA Return                     P00   S123456   P00   S123456   PO   Group   A
P00 S123456 A-CUR CG CRA Return                     P00   S123456   P00   S123456   PO   Group   A
P00 S123456 A-CUR CG CRA Return                     P00   S123456   P00   S123456   PO   Group   A
P00 S123456 A-CUR CG CRA Return                     P00   S123456   P00   S123456   PO   Group   A
P00 S123456 A-CUR CG CRA Return                     P00   S123456   P00   S123456   PO   Group   A
P00 S123456 A-CUR CG CRA Return Total



P00 S654321 A-CAP CG Information                    P00 S654321     P00 S654321 PO Group B
P00 S654321 A-CAP CG Information Total
P00 S654321 A-CAP CG CRA Return                     P00   S654321   P00   S654321   PO   Group   B
P00 S654321 A-CAP CG CRA Return                     P00   S654321   P00   S654321   PO   Group   B
P00 S654321 A-CAP CG CRA Return                     P00   S654321   P00   S654321   PO   Group   B
P00 S654321 A-CAP CG CRA Return                     P00   S654321   P00   S654321   PO   Group   B
P00 S654321 A-CAP CG CRA Return                     P00   S654321   P00   S654321   PO   Group   B
P00 S654321 A-CAP CG CRA Return                     P00   S654321   P00   S654321   PO   Group   B
P00 S654321 A-CAP CG CRA Return                     P00   S654321   P00   S654321   PO   Group   B
P00 S654321 A-CAP CG CRA Return                     P00   S654321   P00   S654321   PO   Group   B
P00 S654321 A-CAP CG CRA Return                     P00   S654321   P00   S654321   PO   Group   B
P00 S654321 A-CAP CG CRA Return                     P00   S654321   P00   S654321   PO   Group   B
P00 S654321 A-CAP CG CRA Return                     P00   S654321   P00   S654321   PO   Group   B
P00 S654321 A-CAP CG CRA Return                     P00   S654321   P00   S654321   PO   Group   B
P00 S654321 A-CAP CG CRA Return                     P00   S654321   P00   S654321   PO   Group   B
P00 S654321 A-CAP CG CRA Return Total
CAP or
CUR    Function                                                              Sub-Function
A-CUR                                                        4.1 General economic, commercial and labour affairs
        4. Economic affairs - of which: enterprise and economic development

A-CUR   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CUR   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CUR   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CUR   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CUR   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CUR   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CUR   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CUR   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CUR   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CUR   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CUR   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CUR   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CUR   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs




A-CAP                                                        4.1 General economic, commercial and labour affairs
        4. Economic affairs - of which: enterprise and economic development

A-CAP   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CAP   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CAP   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CAP   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CAP   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CAP   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CAP   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CAP   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CAP   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CAP   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CAP   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CAP   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
A-CAP   4.   Economic   affairs   -   of   which:   enterprise   and         4.1 General economic,
                                                                       economic development          commercial   and   labour   affairs
                                   <                            National Statistics


                                   2005-06       2006-07       2007-08        2008-09
UK                                        50.0          50.0           50.0            50.0
                                         50.0          50.0           50.0            50.0
SCOTLAND
WALES
NORTHERN IRELAND
ENGLAND_North East
ENGLAND_North West
ENGLAND_Yorkshire and the Humber
ENGLAND_East Midlands
ENGLAND_West Midlands
ENGLAND_East
ENGLAND_London
ENGLAND_South East
ENGLAND_South West
OUTSIDE UK
                                          0.0           0.0            0.0           0.0
Return minus Information                -50.0         -50.0          -50.0         -50.0

UK                                        20.0          20.0           20.0            20.0
                                         20.0          20.0           20.0            20.0
SCOTLAND
WALES
NORTHERN IRELAND
ENGLAND_North East
ENGLAND_North West
ENGLAND_Yorkshire and the Humber
ENGLAND_East Midlands
ENGLAND_West Midlands
ENGLAND_East
ENGLAND_London
ENGLAND_South East
ENGLAND_South West
OUTSIDE UK
                                          0.0           0.0            0.0           0.0
Return minus Information                -20.0         -20.0          -20.0         -20.0
tistics                           >
                                      For your larger subprogrammes, please give us a full
                                      description of your sources and methods in producing these
          2009-10       2010-11       regional allocations, for each year
                 50.0          50.0
                50.0          50.0
                                      2005-06
                                      2006-07
                                      2007-08
                                      2008-09
                                      2009-10
                                      2010-11
                                      2011-12
                                      2012-13
                                      2013-14




                 0.0           0.0
               -50.0         -50.0

                 20.0          20.0
                20.0          20.0
                                      2005-06
                                      2006-07
                                      2007-08
                                      2008-09
                                      2009-10
                                      2010-11
                                      2011-12
                                      2012-13
                                      2013-14




                 0.0           0.0
               -20.0         -20.0
                                                                           Transfers &
   Dept Code Dept Name PO Group          PO Group Alias          ID/Non-ID Non transfers
4. Economic affairs - of which: enterprise and economic development
 4.1 General economic, commercial and labour affairs
    Dept00     Department X P00 S123456 P00 S123456 PO Group A Identifiable   Transfers
    Dept00     Department X P00 S654321 P00 S654321 PO Group B Identifiable   Non-transfers
                                 If services collective: are they
If not transfers, are services   regionally or non-regionally
collective or to individuals ?   delivered?                         2005-06 2006-07


                                                                        50.0    50.0
Collective                       Regional                               20.0    20.0
                                 SUM:                                  70.0    70.0
                                 Total Identifiable                    70.0    70.0
                                 Total Non-Identifiable                  0.0     0.0
2007-08 2008-09 2009-10 2010-11


    50.0    50.0    50.0    50.0
    20.0    20.0    20.0    20.0
   70.0    70.0    70.0    70.0
   70.0    70.0    70.0    70.0
     0.0     0.0     0.0     0.0
Version Organisation Organisation Alias   Variables
Variables Alias
Reporting   CPID   Segment
Segment Alias   Segment Parent
Segment Parent Alias   Analysis   Dept Group
Accounts CAP/CUR Budget CAP/CUR ESA   NAC   PESA Transfer
SIGNAGE Pension AA   Budget Boundary Category COFOG   PESA
PESA Delivery PESA Services Sector Territory Non_ID_Exceptions Activity   SBI
2005-06 outturn 2006-07 outturn 2007-08 outturn 2008-09 outturn 2009-10 outturn
2010-11 estimated outturn
Population by country and region
                                                                                                                               Thousands
                                       mid-2003       mid-2004      mid-2005       mid-2006      mid-2007      mid-2008         mid-2009
North East                                  2,541          2,542         2,550          2,556         2,564        2,575            2,584
North West                                  6,800          6,820         6,840          6,853         6,864        6,876            6,898
Yorkshire and Humberside                    5,028          5,064         5,108          5,142         5,177        5,213            5,258
East Midlands                               4,254          4,291         4,328          4,364         4,400        4,433            4,451
West Midlands                               5,312          5,327         5,351          5,367         5,382        5,411            5,431
East                                        5,475          5,511         5,563          5,607         5,661        5,729            5,767
London                                      7,364          7,389         7,456          7,512         7,557        7,620            7,754
South East                                  8,087          8,125         8,185          8,238         8,309        8,380            8,436
South West                                  5,005          5,042         5,087          5,124         5,178        5,209            5,231

England                                     49,866         50,111        50,466        50,763         51,092        51,446         51,810
Scotland                                     5,057          5,078         5,095         5,117          5,138         5,169          5,194
Wales                                        2,931          2,946         2,954         2,966          2,980         2,993          2,999
Northern Ireland                             1,703          1,710         1,724         1,742          1,761         1,775          1,789
United Kingdom                              59,557         59,846        60,238        60,587         60,971        61,383         61,792

These mid year numbers are then directly applied to the relevant financial year (eg mid-2003 to financial data for 2003-04).

Sources: mid-2003 to mid-2009 estimates were supplied by the Population Estimates Unit.
Population projections mid-2010 for Scotland, Wales and Northern Ireland are 2008 based and are from the ONS available online at
Projections for the English regions are 2008-based subnational population projections from the ONS, available online at
http://www.statistics.gov.uk/statbase/product.asp?vlnk=997



Population percentages

                                     mid-2003     mid-2004            mid-2005      mid-2006       mid-2007      mid-2008       mid-2009
North East                                0.04267     0.04248          0.04233       0.04218        0.04206       0.04195        0.04182
North West                                0.11418     0.11395          0.11355       0.11311        0.11258       0.11202        0.11163
Yorkshire and Humberside                  0.08441     0.08462          0.08479       0.08488        0.08491       0.08493        0.08509
East Midlands                             0.07143     0.07171          0.07184       0.07203        0.07216       0.07222        0.07204
West Midlands                             0.08919     0.08901          0.08883       0.08858        0.08827       0.08815        0.08789
East                                      0.09192     0.09209          0.09235       0.09254        0.09285       0.09333        0.09332
London                                    0.12365     0.12347          0.12378       0.12399        0.12394       0.12414        0.12548
South East                                0.13578     0.13577          0.13587       0.13596        0.13627       0.13652        0.13652
South West                                0.08404     0.08424          0.08444       0.08457        0.08492       0.08486        0.08466
Scotland                                  0.08492     0.08486          0.08458       0.08445        0.08428       0.08421        0.08406
Wales                                     0.04922     0.04923          0.04903       0.04895        0.04888       0.04876        0.04854
Northern Ireland                          0.02859     0.02858          0.02863       0.02875        0.02888       0.02892        0.02895
United Kingdom                                  1           1                1             1              1             1              1



Population no NI                     mid-2003        mid-2004         mid-2005      mid-2006       mid-2007      mid-2008       mid-2009

North East                                 0.04393       0.04373        0.04357       0.04343       0.04331        0.04320        0.04307
North West                                 0.11754       0.11730        0.11689       0.11646       0.11593        0.11535        0.11496
Yorkshire and Humberside                   0.08690       0.08711        0.08729       0.08739       0.08744        0.08745        0.08763
East Midlands                              0.07353       0.07382        0.07396       0.07416       0.07431        0.07437        0.07418
West Midlands                              0.09181       0.09163        0.09144       0.09120       0.09089        0.09078        0.09051
East                                       0.09463       0.09479        0.09507       0.09528       0.09561        0.09611        0.09611
London                                     0.12729       0.12710        0.12742       0.12766       0.12763        0.12784        0.12922
South East                                 0.13978       0.13976        0.13987       0.13999       0.14032        0.14059        0.14059
South West                                 0.08651       0.08672        0.08693       0.08708       0.08745        0.08739        0.08718
Scotland                                   0.08742       0.08735        0.08707       0.08695       0.08678        0.08672        0.08656
Wales                                      0.05066       0.05068        0.05048       0.05040       0.05033        0.05021        0.04999
Northern Ireland
United Kingdom     1   1   1   1   1   1   1
                mid-2010
                    2,591
                    6,919
                    5,306
                    4,501
                    5,460
                    5,827
                    7,799
                    8,498
                    5,297

                      52,198
                       5,211
                       3,011
                       1,802
                      62,222

4).



ble online at




                          %
                    mid-2010
                     0.04164
                     0.11120
                     0.08527
                     0.07234
                     0.08775
                     0.09365
                     0.12534
                     0.13657
                     0.08512
                     0.08375
                     0.04838
                     0.02896
                           1

                %
                    mid-2010

                     0.04288
                     0.11452
                     0.08781
                     0.07450
                     0.09037
                     0.09645
                     0.12908
                     0.14064
                     0.08766
                     0.08625
                     0.04983
1
GOVERNMENT OFFICE (NUTS1) REGIONS IN THE UK

Below is a list of counties included in each government office (NUTS1) region. Unitary counties are
generally under their ‘parent’ county, rather than shown separately.

A map showing details of the coverage of the 12 NUTS1 regions is available at:
http://www.statistics.gov.uk/geography/downloads/uk_gor_cty.pdf

Full details of the composition of each region in terms of counties, unitary authorities and metropolitan
and London Boroughs is available at:
http://www.statistics.gov.uk/geography/downloads/presadminannexb.pdf
           Scotland

           Wales

           Northern Ireland

           North East:
            · Northumberland
            · Tyne & Wear
            · Durham
            · Tees Valley
           North West:
            · Cumbria
            · Lancashire
            · Merseyside
            · Greater Manchester
            · Cheshire
           Yorkshire and the Humber:
             · North Yorkshire
             · West Yorkshire
             · South Yorkshire
             · East Riding & North Lincolnshire (The Humber)
           East   Midlands:
             ·    Derbyshire
             ·    Nottinghamshire
             ·    Leicestershire & Rutland
             ·    Lincolnshire
             ·    Northamptonshire
           West   Midlands
            ·     Herefordshire
            ·     Worcestershire
            ·     Shropshire
            ·     Staffordshire
            ·     West Midlands
            ·     Warwickshire
           East:
             · Cambridgeshire
             · Norfolk
             · Suffolk
             · Bedfordshire
             · Hertfordshire
             · Essex
London:
  · Greater London
South East:
  · Berkshire
  · Buckinghamshire
  · Oxfordshire
  · Hampshire & Isle of Wight
  · Surrey
  · West Sussex
  · East Sussex
  · Kent
South West:
  · Gloucestershire
  · Bristol/Bath area
  · Somerset
  · Wiltshire
  · Dorset
  · Devon
  · Cornwall & Isles of Scilly

								
To top