ROI TEST

ROI Test

Yes

Account Name *

Broad Sector *

Subsector *

Project Location (Unitary Authority) *

HQ Operation? *

Project Description

Minimum Wage

�10.5k-�14.9k

�15k- �19.9k

�20k- �24.9k

�25k- �29.9k

�30k- �34.9k

�35k- �39.9k

�40k- �44.9k

�45k- �49.9k

�50k- �54.9k

�55k+ (�65k av)

Total

Forecast Jobs by Salary Band *

** 2 *

Current Fin. Year

Year 1

Year 2

Year 3

Year 4

Year 5

Year 6

Year 7

Year 8

Year 9

Total

Total Project Cost Excluding Working Capital (�000s) *

** 0 *

Public Sector Support Requested (�000s) *

** 0 *

Eligible Project Costs (�000s)

** 0 *

Employees Costs (�000s)

Without Investment *

** 0 *

With Investment *

** 0 *

Net Profit (�000s)

Without Investment *

** 0 *

With Investment *

** 0 *

Depreciation (�000s)

Without Investment *

** 0 *

With Investment *

** 0 *

Amortisation (�000s)

Without Investment *

** 0 *

With Investment *

** 0 *

Total Value Added (�000s)

** $0

* Required Information,

All above shaded fields to be completed by RM on behalf of applicant. The rest of

the workbook is automated

This section checks if required information has been supplied and if that information is consistent.

Error checking

Broad Sector Selected

Broad Sector not selected - please choose a broad sector and subsector from the dropdown in row 6

Subsector Selected

Subsector not selected - please choose a subsector from the dropdown in row 8

Sector Eligibility

Subsector not selected - please choose a subsector from the dropdown box in row 8

Location Selected

Company location not selected - please choose company location from the dropdown in rows 10

HQ Operation Selected

HQ Operation not selected - please select Yes or No from the the dropdown in row 12

Value Added Increasing

There is no additional GVA being generated by this project - please check the figures you have entered

Present Values (PVs) - using 10% discount rate

PV Investment (�000s)

** $0

PV Value Added (�000s)

** $0

Net Value Added (�000s)

** $0

Economic Benefit Not Established

Adjustment Factors

Average Salary of New/Safeguarded Jobs

Average UA Earnings

[2006 ASHE UA Mean Gross Weekly excl overtime uprated to 2007]

As % of UA average

Quality Job Indicator

[if earnings >105% of UA average]

HQ Operation

** 0%

[3% uplift]

RM states whether site is a HQ operation

Quality Jobs

** 0%

[3% uplift]

Uplift if average additional earnings are 5% or more above the UA average

One Wales/MAG Sector/Strategic Priority

** 0%

[3% uplift]

Linked between project and strategic priorities

Sector Multiplier Band

** 0%

[0% / 5% / 10% uplift bands]

Ajustment varies according to size of multiplier

Local Labour Market Conditions

** 0 *

[0% / 2.5% / 5% / 10% uplift]

Adjustment depends on how the employment rate compares with the UK average

Total Uplift

** 0 *

Adjusted Value Added (�000s, years 0 - 9)

** $0.00

Support

** 0 *

** $0.00

Adjusted Net Value Added (�000s)

** $0

Economic Potential Not Established

Additional Metrics

Value Added Per � of Support

Cost Per Job (�)

Gross Grant Equivalent, %

Gross Grant Equivalent Calculation

European Commission Discount Rate

6.83

Discount Factors (years 0 - 9)

1 *

** 0.936066647945334 *

** 0.876220769395613 *

** 0.820201038468233 *

** 0.76776283672024 *

** 0.718677184985716 *

** 0.672729743504368 *

** 0.629719875975258 *

** 0.589459773448711 *

** 0.55177363423075 *

Discounted Eligible Project Costs

** 0

Discounted Public Sector Support Applied For

** 0

Lists

2003 Scottish Input-Output Multipliers

Subsector

Code

Sector

Subsector SIC 2003

Type II Output Multiplier

Mult. Uplift Band

Multiplier Uplift %

Possibly Ineligible

MAG?

MAG Uplift

MAG Sector

MAG Type

MAG Description

2006 ASHE Full-Time Gross Earnings (excl overtime)

Employment Rate (Working Age) - Year Ending Dec 2006

Agriculture

Agriculture, forestry & fishing

Agriculture, hunting and related service activities

1.75

Medium

0.05 *

Yes

FALSE

0 *

Max

** 2.33

excl overtime

in overtime

Rate

Diff

Uplift

Forestry planting

2.1

Agriculture, forestry & fishing

Forestry planting and related service activities

1.54

Medium

0.05 *

FALSE

0 *

Min

** 1.00

Yes

Weekly

$ 451.10

$ 469.80

Wales

Anglesey

Forestry harvesting

2.2

Agriculture, forestry & fishing

Forestry logging and related service activities

2.18

High

0.1 *

FALSE

0 *

Range

** 1.33

Annual

** $ 0.00

Blaenau Gwent

Sea fishing

3.1

Agriculture, forestry & fishing

Fishing and service activities incidental to fishing

1.40

Low

0 *

Yes

FALSE

0 *

Into three

** 0.44

Bridgend

Fish farming

3.2

Agriculture, forestry & fishing

Fish farming and related service activities

1.57

Medium

0.05 *

Yes

FALSE

0 *

RPI Uplift

Caerphilly

Coal extraction etc

Mining

Mining of coal and lignite; extraction of peat

1.95

High

0.1 *

Yes

TRUE

0.03 *

Core

Energy

Low

1.00

** 1.44

Apr-06

196.5

Cardiff

Oil & gas extraction

Mining

Extraction of crude petroleum and natural gas, service activities incidental to extraction; mining of uranium and thorium ores

1.80

Medium

0.05 *

TRUE

0.03 *

Core

Energy

Medium

1.40

** 1.84

Feb-07

203.1

Carmarthenshire

Metal ores extraction

Mining

Mining of metal ores

1.00

Low

0 *

FALSE

0 *

None

High

1.80

** 2.33

Increase

** 0.033587786259542 *

Ceredigion

Other mining & quarrying

Mining

Other mining and quarrying

1.72

Medium

0.05 *

FALSE

0 *

None

Conwy

Meat processing

Manufacturing

Production, processing and preserving of meat and meat products

1.97

High

0.1 *

Yes

TRUE

0.03 *

Tier 1

Food

2007 (Uprated 2006) Earnings

Denbighshire

Fish & fruit processing

Manufacturing

Processing and preserving of fish and fish products; fruit and vegetables

1.93

High

0.1 *

Yes

TRUE

0.03 *

Tier 1

Food

** $ 0.00

Flintshire

Oils & fats processing

Manufacturing

Vegetable and animal oils and fats

1.50

Medium

0.05 *

Yes

TRUE

0.03 *

Tier 1

Food

Gwynedd

Dairy products

Manufacturing

Dairy products

1.86

High

0.1 *

Yes

TRUE

0.03 *

Tier 1

Food

Merthyr Tydfil

Grain milling & starch

Manufacturing

Grain mill products, starches and starch products

1.83

Medium

0.05 *

Yes

TRUE

0.03 *

Tier 1

Food

Monmouthshire

Animal feed stuffs

Manufacturing

Prepared animal feeds

1.58

Medium

0.05 *

Yes

TRUE

0.03 *

Tier 1

Food

Neath Port Talbot

Bread, biscuits etc

Manufacturing

Bread, rusks and biscuits; manufacture of pastry goods and cakes

1.54

Medium

0.05 *

Yes

TRUE

0.03 *

Tier 1

Food

Newport

Sugar

Manufacturing

Sugar

1.00

Low

0 *

Yes

TRUE

0.03 *

Tier 1

Food

Pembrokeshire

Confectionery

Manufacturing

Cocoa; chocolate and sugar confectionery

1.60

Medium

0.05 *

Yes

TRUE

0.03 *

Tier 1

Food

Powys

Other food products

Manufacturing

Other food products

1.68

Medium

0.05 *

Yes

TRUE

0.03 *

Tier 1

Food

Rhondda Cynon Taff

Spirits & wines, etc

18.1

Manufacturing

Spirits and wines

1.48

Medium

0.05 *

TRUE

0.03 *

Tier 1

Food

Swansea

Beer brewing

18.2

Manufacturing

Beers and ales

1.68

Medium

0.05 *

TRUE

0.03 *

Tier 1

Food

Torfaen

Soft drinks

Manufacturing

Production of mineral waters and soft drinks

1.46

Medium

0.05 *

TRUE

0.03 *

Tier 1

Food

Vale of Glamorgan

Tobacco

Manufacturing

Tobacco products

1.00

Low

0 *

FALSE

0 *

None

Wrexham

Textile fibres

Manufacturing

Preparation and spinning of textile fibres

1.56

Medium

0.05 *

FALSE

0 *

None

Wales

Textile weaving

Manufacturing

Textile weaving

1.63

Medium

0.05 *

FALSE

0 *

None

United Kingdom

Textile finishing

Manufacturing

Finishing of textiles

1.64

Medium

0.05 *

FALSE

0 *

None

Made-up textiles

Manufacturing

Made-up textile articles, except apparel

1.60

Medium

0.05 *

FALSE

0 *

None

Carpets & rugs

Manufacturing

Carpets and rugs

1.61

Medium

0.05 *

FALSE

0 *

None

Other textiles

Manufacturing

Other textiles

1.59

Medium

0.05 *

FALSE

0 *

None

Knitted goods

Manufacturing

Knitted and crocheted fabrics and articles

1.61

Medium

0.05 *

FALSE

0 *

None

2006 Mean Gross Weekly Full-Time Earnings - Workplace based - excluding overtime

Wearing apparel & fur products

Manufacturing

Wearing apparel; dressing and dying of fur

1.53

Medium

0.05 *

FALSE

0 *

None

Leather goods

Manufacturing

Tanning and dressing of leather; manufacture of luggage, handbags, saddlery and harness

1.61

Medium

0.05 *

FALSE

0 *

None

2006 Wkly

2006 Yr

2007 Yr

% of Wales

Footwear

Manufacturing

Footwear

1.53

Medium

0.05 *

FALSE

0 *

None

Anglesey

$ 453.70

** 0 *

Wood & wood products

Manufacturing

Wood and wood products, except furniture

1.76

Medium

0.05 *

TRUE

0.03 *

Tier 1

Construction

Blaenau Gwent

$ 427.30

** 0 *

Pulp, paper & paperboard

Manufacturing

Pulp, paper and paperboard

1.63

Medium

0.05 *

FALSE

0 *

None

Bridgend

$ 482.10

** 0 *

Paper & paperboard products

Manufacturing

Articles of paper and paperboard

1.52

Medium

0.05 *

FALSE

0 *

None

Caerphilly

$ 446.70

** 0 *

Printing & publishing

Manufacturing

Publishing, printing and reproduction of recorded media

1.57

Medium

0.05 *

TRUE

0.03 *

Tier 2

Creative

Cardiff

$ 484.50

** 0 *

Coke, refined petroleum & nuclear fuel

Manufacturing

Coke, refined petroleum products and nuclear fuel

2.02

High

0.1 *

TRUE

0.03 *

Core

Energy

Carmarthenshire

$ 421.70

** 0 *

Industrial gases & dyes

Manufacturing

Industrial gases, dyes and pigments

1.59

Medium

0.05 *

FALSE

0 *

None

Ceredigion

$ 392.90

** 0 *

Inorganic chemicals

Manufacturing

Other inorganic basic chemicals

1.60

Medium

0.05 *

TRUE

0.03 *

Tier 2

Biotech

Conwy

$ 436.10

** 0 *

Organic chemicals

Manufacturing

Other organic basic chemicals

1.54

Medium

0.05 *

TRUE

0.03 *

Tier 2

Biotech

Denbighshire

$ 412.40

** 0 *

Fertilisers

Manufacturing

Fertilisers and nitrogen compounds

1.56

Medium

0.05 *

TRUE

0.03 *

Tier 2

Biotech

Flintshire

$ 469.70

** 0 *

Synthetic resins

Manufacturing

Plastics and synthetic rubber in primary forms

1.63

Medium

0.05 *

FALSE

0 *

None

Gwynedd

$ 468.10

** 0 *

Pesticides

Manufacturing

Pesticides and other agro-chemical products

1.62

Medium

0.05 *

TRUE

0.03 *

Tier 2

Biotech

Merthyr Tydfil

$ 391.70

** 0 *

Paints, varnishes, printing ink etc

Manufacturing

Paints, varnishes and similar coatings, printing ink and mastics

1.59

Medium

0.05 *

FALSE

0 *

None

Monmouthshire

$ 454.10

** 0 *

Pharmaceuticals

Manufacturing

Pharmaceuticals, medicinal chemicals and botanical products

1.70

Medium

0.05 *

TRUE

0.03 *

Tier 2

Biotech

Neath Port Talbot

$ 454.60

** 0 *

Soap & toilet preparations

Manufacturing

Soap and detergents, cleaning and polishing preparations, perfumes and toilet preparations

1.56

Medium

0.05 *

FALSE

0 *

None

Newport

$ 470.70

** 0 *

Other chemical products

Manufacturing

Other chemical products

1.48

Medium

0.05 *

FALSE

0 *

None

Pembrokeshire

$ 433.20

** 0 *

Man-made fibres

Manufacturing

Man-made fibres

1.63

Medium

0.05 *

Yes

FALSE

0 *

None

Powys

$ 406.00

** 0 *

Rubber products

Manufacturing

Rubber products

1.72

Medium

0.05 *

TRUE

0.03 *

Tier 1

Automotive

Rhondda Cynon Taff

$ 452.90

** 0 *

Plastic products

Manufacturing

Plastic products

1.60

Medium

0.05 *

TRUE

0.03 *

Tier 1

Construction

Swansea

$ 420.50

** 0 *

Glass & glass products

Manufacturing

Glass and glass products

1.68

Medium

0.05 *

TRUE

0.03 *

Tier 1

Construction

Torfaen

$ 435.70

** 0 *

Ceramic goods

Manufacturing

Ceramic goods

1.63

Medium

0.05 *

TRUE

0.03 *

Tier 1

Construction

Vale of Glamorgan

$ 497.50

** 0 *

Structural clay products

Manufacturing

Bricks, tiles and construction products, in baked clay

1.64

Medium

0.05 *

TRUE

0.03 *

Tier 1

Construction

Wrexham

$ 433.20

** 0 *

Cement, lime & plaster

Manufacturing

Cement, lime and plaster

1.45

Medium

0.05 *

TRUE

0.03 *

Tier 1

Construction

Wales

$ 451.10

** 0 *

Articles of concrete etc

Manufacturing

Articles of concrete, plaster and cement; shaping and finishing of stone; manufacture of other non-metallic mineral products

1.66

Medium

0.05 *

TRUE

0.03 *

Tier 1

Construction

$ 519.10

** 0 *

Iron & steel

Manufacturing

Basic iron and steel and of ferro-alloys; manufacture of tubes and other first processing of iron and steel

1.59

Medium

0.05 *

Yes

FALSE

0 *

None

Non-ferrous metals

Manufacturing

Basic precious and non-ferrous metals

1.54

Medium

0.05 *

FALSE

0 *

None

Metal castings

Manufacturing

Casting of metals

1.73

Medium

0.05 *

FALSE

0 *

None

Structural metal products

Manufacturing

Structural metal products

1.55

Medium

0.05 *

TRUE

0.03 *

Tier 1

Construction

Metal containers, etc

Manufacturing

Tanks, reservoirs and containers of metal; manufacture of central heating radiators and boilers; manufacture of steam generators

1.61

Medium

0.05 *

TRUE

0.03 *

Tier 1

Construction

National Minimum Wage rates from 1 October 2007

Metal forging, pressing etc

Manufacturing

Forging, pressing, stamping and roll forming of metal; powder metallurgy; treatment and coating of metals

1.59

Medium

0.05 *

FALSE

0 *

None

Following the Budget announcements on 21 March 2007 it is confirmed that the national minimum wage rates from 1 October 2007 are:

Cutlery, tools etc

Manufacturing

Cutlery, tools and general hardware

1.61

Medium

0.05 *

TRUE

0.03 *

Tier 1

Construction

Main rate for adults aged 22 and over - �5.52

Other metal products

Manufacturing

Other fabricated metal products

1.56

Medium

0.05 *

FALSE

0 *

None

Development rate for 18 – 21 year olds - £4.60

Mech. power equipment

Manufacturing

Machinery for the production and use of mechanical power, except aircraft, vehicle and cycle engines

1.46

Medium

0.05 *

TRUE

0.03 *

Tier 1

Construction

Development rate for 16 -17 year olds - �3.40

General purpose machinery

Manufacturing

Other general purpose machinery

1.47

Medium

0.05 *

FALSE

0 *

None

Agricultural machinery

Manufacturing

Agricultural and forestry machinery

1.52

Medium

0.05 *

TRUE

0 *

None

Assuming 37 hours per week

Hourly

37hr/wk

52-wk

Machine tools

Manufacturing

Machine tools

1.48

Medium

0.05 *

FALSE

0 *

None

Adults aged 22 and over -

$5.52

** $ 204.24

** 10620.48 *

Special purpose machinery

Manufacturing

Other special purpose machinery

1.49

Medium

0.05 *

FALSE

0 *

None

Dev't rate for 18 – 21 year olds -

$4.60

** $ 170.20

** 8850.4 *

Weapons & ammunition

Manufacturing

Weapons and ammunition

1.50

Medium

0.05 *

TRUE

0.03 *

Tier 1

Defence

Dev't rate for 16 -17 year olds -

$3.40

** $ 125.80

** 6541.6 *

Domestic appliances nec

Manufacturing

Domestic appliances not elsewhere classified

1.53

Medium

0.05 *

FALSE

0 *

None

Office machinery & computers

Manufacturing

Office machinery and computers

1.55

Medium

0.05 *

TRUE

0.03 *

Core

ICT

Electric motors & generators etc

Manufacturing

Electric motors, generators and transformers; manufacture of electricity distribution and control apparatus

1.46

Medium

0.05 *

TRUE

0.03 *

Tier 1

Automotive

Insulated wire & cable

Manufacturing

Insulated wire and cable

1.51

Medium

0.05 *

TRUE

0.03 *

Tier 1

Construction

Electrical equipment nec

Manufacturing

Electrical equipment not elsewhere classified

1.37

Low

0 *

FALSE

0 *

None

Electronic components

Manufacturing

Electronic valves and tubes and other electronic components

1.50

Medium

0.05 *

TRUE

0.03 *

Core

ICT

Transmitters for TV, radio & phone

Manufacturing

Television and radio transmitters and apparatus for line for telephony and line telegraphy

1.38

Low

0 *

TRUE

0.03 *

Core

ICT

Receivers for TV & radio

Manufacturing

Television and radio receivers, sound or video recording or reproducing apparatus and associated goods

1.41

Low

0 *

TRUE

0.03 *

Core

ICT

Medical & precision instruments

Manufacturing

Medical, precision and optical instruments, watches and clocks

1.42

Low

0 *

TRUE

0.03 *

Tier 2

Health

Motor vehicles

Manufacturing

Motor vehicles, trailers and semi-trailers

1.42

Low

0 *

TRUE

0.03 *

Tier 1

Automotive

Shipbuilding & repair

Manufacturing

Building and repairing of ships and boats

1.79

Medium

0.05 *

Yes

FALSE

0 *

None

Other transport equipment

Manufacturing

Other transport equipment

1.64

Medium

0.05 *

FALSE

0 *

None

Aircraft & spacecraft

Manufacturing

Aircraft and spacecraft

1.57

Medium

0.05 *

TRUE

0.03 *

Tier 1

Aerospace

Furniture

Manufacturing

Furniture

1.68

Medium

0.05 *

FALSE

0 *

None

Jewellery & related products

Manufacturing

Jewellery and related articles; musical instruments

1.48

Medium

0.05 *

FALSE

0 *

None

Sports goods & toys

Manufacturing

Sports goods, games and toys

1.97

High

0.1 *

FALSE

0 *

None

Misc. manufacturing nec, recycling

Manufacturing

Miscellaneous manufacturing not elsewhere classified; recycling

1.52

Medium

0.05 *

TRUE

0.03 *

Core

Environmental Mgt

Electricity production & distribution

Energy and water

Production, transmission and distribution of electricity

2.33

High

0.1 *

TRUE

0.03 *

Core

Energy

Gas distribution

Energy and water

Gas; distribution of gaseous fuels through mains; steam and hot water supply

1.68

Medium

0.05 *

TRUE

0.03 *

Core

Energy

Water supply

Energy and water

Collection, purification and distribution of water

1.36

Low

0 *

TRUE

0.03 *

Core

Environmental Mgt

Construction

1.82

Medium

0.05 *

TRUE

0.03 *

Tier 1

Construction

Motor vehicle distribution & repair, etc

Distribution & catering

Sale, maintenance and repair of motor vehicles and motor cycles; retail sale of automotive fuel

1.49

Medium

0.05 *

TRUE

0.03 *

Tier 1

Retail

Wholesale distribution

Distribution & catering

Wholesale trade and commission trade, except of motor vehicles and motorcycles

1.68

Medium

0.05 *

TRUE

0.03 *

Tier 1

Retail

Retail distribution

Distribution & catering

Retail trade, except of motor vehicles and motorcycles, repair of personal and household goods

1.71

Medium

0.05 *

TRUE

0.03 *

Tier 1

Retail

Hotels, catering & pubs etc

Distribution & catering

Hotels and restaurants

1.49

Medium

0.05 *

TRUE

0.03 *

Tier 1

Leisure & Tourism

Railway transport

Transport & communication

Transport and railways

2.00

High

0.1 *

FALSE

0 *

None

Other land transport

Transport & communication

Other land transport; transport via pipelines

1.68

Medium

0.05 *

FALSE

0 *

None

Water transport

Transport & communication

Water transport

1.81

Medium

0.05 *

FALSE

0 *

None

Air transport

Transport & communication

Air Transport

1.75

Medium

0.05 *

TRUE

0.03 *

Tier 1

Aerospace

Ancillary transport services

Transport & communication

Supporting and auxiliary transport activities, activities of travel agencies

2.00

High

0.1 *

FALSE

0 *

None

Postal & courier services

Transport & communication

Postal and courier activities

1.72

Medium

0.05 *

FALSE

0 *

None

Telecommunications

Transport & communication

Telecommunications

1.57

Medium

0.05 *

TRUE

0.03 *

Core

ICT

Banking

100.1

Finance and business

Banking

1.65

Medium

0.05 *

TRUE

0.03 *

Tier 2

Financial Products

Other financial institutions

100.2

Finance and business

Building societies, other financial intermediation, except insurance and pension funding

1.70

Medium

0.05 *

TRUE

0.03 *

Tier 2

Financial Products

Insurance & pension funds

101

Finance and business

Insurance and pension funding, except compulsory social security

1.94

High

0.1 *

TRUE

0.03 *

Tier 2

Financial Products

Auxiliary financial services nec

102.1

Finance and business

Activities auxiliary to financial intermediation except insurance and pension funding

1.98

High

0.1 *

TRUE

0.03 *

Tier 2

Financial Products

Auxiliary to insurance

102.2

Finance and business

Activities auxiliary to insurance and pension funding

1.94

High

0.1 *

TRUE

0.03 *

Tier 2

Financial Products

Owning & dealing in real estate

103

Finance and business

Real estate activities with own property, letting of own property, except dwellings

1.90

High

0.1 *

TRUE

0.03 *

Tier 2

Financial Products

Letting of dwellings

104

Finance and business

Letting of dwellings, including imputed rent

1.32

Low

0 *

FALSE

0 *

None

Estate agent activities

105

Finance and business

Real estate activities on a fee or contract basis

1.73

Medium

0.05 *

TRUE

0.03 *

Tier 2

Financial Products

Renting of machinery

106

Finance and business

Renting of machinery and equipment without operator and of personal and household goods

1.63

Medium

0.05 *

TRUE

0.03 *

Tier 2

Financial Products

Computing services

107

Finance and business

Computer and related activities

1.61

Medium

0.05 *

TRUE

0.03 *

Core

ICT

Research & development

108

Finance and business

Research and development

1.81

Medium

0.05 *

FALSE

0.03 *

Tier 2

Biotech

Legal activities

109

Finance and business

Legal activities

1.67

Medium

0.05 *

FALSE

0 *

None

Accountancy services

110

Finance and business

Accounting, book-keeping and auditing activities; tax consultancy

1.67

Medium

0.05 *

TRUE

0.03 *

Tier 2

Financial Products

Market research

111

Finance and business

Marketing research and public opinion polling; business and management consultancy activities; management activities of holding companies

1.83

Medium

0.05 *

TRUE

0.03 *

Tier 2

Creative

Architectural activities etc

112

Finance and business

Architectural and engineering activities and related technical consultancy, technical testing and analysis

1.74

Medium

0.05 *

TRUE

0.03 *

Tier 2

Creative

Advertising

113

Finance and business

Advertising

1.71

Medium

0.05 *

TRUE

0.03 *

Tier 2

Creative

Other business services

114

Finance and business

Other business services

1.69

Medium

0.05 *

TRUE

0.03 *

Tier 2

Multiple - FP / Creative / Health / etc

Public administration

115

Public admin etc.

Public administration and defence; compulsory social security

1.67

Medium

0.05 *

FALSE

0 *

None

Education

116

Education, health and social work

Education

1.66

Medium

0.05 *

FALSE

0 *

None

Health & veterinary services

117

Education, health and social work

Human health and veterinary activities

1.57

Medium

0.05 *

TRUE

0.03 *

Tier 2

Health

Social work activities

118

Education, health and social work

Social work activities

2.12

High

0.1 *

FALSE

0 *

None

Sewage & sanitary services

119

Other services

Sewage and refuse disposal, sanitation and similar activities

1.33

Low

0 *

TRUE

0.03 *

Core

Environmental Mgt

Membership organisations nec

120

Other services

Activities of membership organisations not elsewhere classified

1.59

Medium

0.05 *

TRUE

0.03 *

Tier 1

Leisure & Tourism

Recreational services

121

Other services

Recreational, cultural and sporting activities

1.72

Medium

0.05 *

TRUE

0.03 *

Tier 1/2

Creative/Leisure & Tourism

Other service activities

122

Other services

Other service activities

1.59

Medium

0.05 *

FALSE

0 *

None

Private households with employed persons

123

Other services

Private households employing staff and undifferentiated production activities of households for own use

1.57

Medium

0.05 *

FALSE

0 *

None

Research and Development

High

0.1 *

TRUE

0.03 *

Custom

Tourism Average

Tourism

Medium

0.05 *

TRUE

0.03 *

None

Non-MAG - One Wales

Sector Selected

Ineligible?

** 0

not selected

Detailed MAG Sector Definition (see NOMIS) - update from Feb-08

Detailed MAG Sector Definition (see NOMIS) -

MAG Core - Energy

SIC 2003 division (2 digit)

SIC 2003 group (3 digit)

10 : Mining of coal and lignite; extraction of peat

401 : Production and distribution of electricity

11 : Extraction of crude petroleum and natural gas; service activities incidental to oil and gas extraction excluding surveying

402 : Manufacture of gas; distribution of gaseous fuels through mains

12 : Mining of uranium and thorium ores

403 : Steam and hot water supply

23 : Manufacture of coke, refined petroleum products and nuclear fuel

SIC 2003 division (2 digit)

40 : Electricity, gas, steam and hot water supply

10 : Mining of coal and lignite; extraction of peat

11 : Extraction of crude petroleum and natural gas; service activities incidental to oil and gas extraction excluding surveying

12 : Mining of uranium and thorium ores

23 : Manufacture of coke, refined petroleum products and nuclear fuel

MAG Core - Envt Mgt

SIC 2003 division (2 digit)

37 : Recycling

02 : Forestry, logging and related service activities

41 : Collection, purification and distribution of water

37 : Recycling

90 : Sewage and refuse disposal, sanitation and similar activities

41 : Collection, purification and distribution of water

90 : Sewage and refuse disposal, sanitation and similar activities

MAG Core - ICT

SIC 2003 group (3 digit)

321 : Manufacture of electronic valves and tubes and other electronic components

314 : Manufacture of accumulators, primary cells and primary batteries

322 : Manufacture of television and radio transmitters and apparatus for line telephony and line telegraph

315 : Manufacture of lighting equipment and electric lamps

323 : Manufacture of television and radio receivers, sound or video recording or reproducing apparatus and associated goods

316 : Manufacture of electrical equipment not elsewhere classified

642 : Telecommunications

321 : Manufacture of electronic valves and tubes and other electronic components

SIC 2003 division (2 digit)

322 : Manufacture of television and radio transmitters and apparatus for line telephony and line telegraph

30 : Manufacture of office machinery and computers

323 : Manufacture of television and radio receivers, sound or video recording or reproducing apparatus and associated goods

72 : Computer and related activites

642 : Telecommunications

SIC 2003 division (2 digit)

30 : Manufacture of office machinery and computers

72 : Computer and related activites

MAG Tier 1 - Aerospace

SIC 2003 group (3 digit)

353 : Manufacture of aircraft and spacecraft

SIC 2003 division (2 digit)

62 : Air transport

MAG Tier 1 - Automotive

SIC 2003 class (4 digit)

SIC 2003 group (3 digit)

2511 : Manufacture of rubber tyres and tubes

602 : Other land transport

2512 : Retreading and rebuilding of rubber tyres

SIC 2003 division (2 digit)

3110 : Manufacture of electric motors, generators and transformers

34 : Manufacture of motor vehicles, trailers and semi-trailers

3410 : Manufacture of motor vehicles

50 : Sale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuel

3420 : Manufacture of bodies (coachwork) for motor vehicles: manufacture of trailers and semi-trailers

MAG Tier 1 - Construction

SIC 2003 broad industrial groups

SIC 2003 class (4 digit)

4 : Construction (SIC F)

2010 : Saw milling and planing of wood, impregnation of wood

2020 : Manufacture of veneer sheets; manufacture of plywood, laminboard, particle board, fibre board and other panels and boards

2030 : Manufacture of builders carpentry and joinery

MAG Tier 1 - Defence

2521 : Manufacture of plastic plates, sheets, tubes and profiles

SIC 2003 class (4 digit)

2523 : Manufacture of builders ware of plastic

7522 : Defence activities

2524 : Manufacture of other plastic products

SIC 2003 group (3 digit)

2611 : Manufacture of flat glass

296 : Manufacture of weapons and ammunition

2612 : Shaping and processing of flat glass

2613 : Manufacture of hollow glass

2614 : Manufacture of glass fibres

MAG Tier 1 - Food

2622 : Manufacture of ceramic sanitary fixtures

SIC 2003 class (4 digit)

2623 : Manufacture of ceramic insulators and insulating fittings

0501 : Fishing

2630 : Manufacture of ceramic tiles and flags

0502 : Operation of fish hatcheries and fish farms

2640 : Manufacture of bricks, tiles and construction products, in baked clay

1581 : Manufacture of bread; manufacture of fresh pastry goods and cakes

2651 : Manufacture of cement

1582 : Manufacture of rusks and biscuits; manufacture of preserved pastry goods and cakes

2652 : Manufacture of lime

1583 : Manufacture of sugar

2653 : Manufacture of plaster

1584 : Manufacture of cocoa, chocolate and sugar confectionery

2661 : Manufacture of concrete products for construction purposes

1585 : Manufacture of macaroni, noodles, couscous and similar farinaceous products

2662 : Manufacture of plaster products for construction purposes

1586 : Processing of tea and coffee

2663 : Manufacture of ready-mixed concrete

1587 : Manufacture of condiments and seasonings

2664 : Manufacture of mortars

1588 : Manufacture of homogenised food preparations and dietetic food

2665 : Manufacture of fibre cement

1589 : Manufacture of other food products not elsewhere classified

2666 : Manufacture of other articles of concrete, plaster and cement

1591 : Manufacture of distilled potable alcoholic beverages

2670 : Cutting, shaping and finishing of stone

1592 : Production of ethyl alcohol from fermented materials

2681 : Production of abrasive products

1593 : Manufacture of wines

2811 : Manufacture of metal structures and parts of structures

1594 : Manufacture of cider and other fruit wines

2812 : Manufacture of builders' carpentry and joinery of metal

1595 : Manufacture of other non-distilled fermented beverages

2821 : Manufacture of tanks, reservoirs and containers of metal

1596 : Manufacture of beer

2822 : Manufacture of central heating radiators and boilers

1597 : Manufacture of malt

2861 : Manufacture of cutlery

1598 : Manufacture of mineral waters and soft drinks

2862 : Manufacture of tools

SIC 2003 group (3 digit)

2863 : Manufacture of locks and hinges

151 : Production, processing and preserving of meat and meat products

2873 : Manufacture of wire products

152 : Processing and preserving of fish and fish products

2912 : Manufacture of pumps and compressors

153 : Processing and preserving of fruit and vegetables

2913 : Manufacture of taps and valves

154 : Manufacture of vegetable and animal oils and fats

2941 : Manufacture of portable hand held power tools

155 : Manufacture of dairy products

3130 : Manufacture of insulated wire and cable

156 : Manufacture of grain mill products, starches and starch products

SIC 2003 division (2 digit)

157 : Manufacture of prepared animal feeds

45 : Construction

SIC 2003 division (2 digit)

01 : Agriculture, hunting and related service activities

MAG Tier 1 - Defence

MAG Tier 1 - Leisure & Tourism

SIC 2003 class (4 digit)

7522 : Defence activities

6330 : Activities of travel agencies and tour operators; tourist assistance activities not elsewhere classified

SIC 2003 group (3 digit)

9304 : Physical well-being activities

296 : Manufacture of weapons and ammunition

SIC 2003 division (2 digit)

55 : Hotels and restaurants

92 : Recreational, cultural and sporting activities

MAG Tier 1 - Food

MAG Tier 1 - Retail

SIC 2003 class (4 digit)

SIC 2003 division (2 digit)

1440 : Production of salt

51 : Wholesale trade and commission trade, except of motor vehicles and motorcycles

1512 : Production and preserving of poultry meat

52 : Retail trade, except of motor vehicles and motorcycles; repair of personal and household goods

1513 : Production of meat and poultry meat products

2953 : Manufacture of machinery for food, beverage and tobacco processing

SIC 2003 group (3 digit)

MAG Tier 2 - Biotech

152 : Processing and preserving of fish and fish products

SIC 2003 class (4 digit)

153 : Processing and preserving of fruit and vegetables

2414 : Manufacture of other organic chemicals

154 : Manufacture of vegetable and animal oils and fats

2415 : Manufacture of fertilisers and nitrogen compounds

155 : Manufacture of dairy products

7310 : Research and experimental development on natural sciences and engineering

156 : Manufacture of grain mill products, starches and starch products

SIC 2003 group (3 digit)

157 : Manufacture of prepared animal feeds

242 : Manufacture of pesticides and other agro-chemical products

158 : Manufacture of other food products

244 : Manufacture of pharmaceuticals, medicinal chemicals and botanical products

159 : Manufacture of beverages

MAG Tier 2 - Creative

MAG Tier 1 - Leisure & Tourism

SIC 2003 class (4 digit)

7414 : Business and management consultancy activities

3512 : Building and repairing of pleasure and sporting boats

7481 : Photographic activities

6330 : Activities of travel agencies and tour operators; tourist assistance activities not elsewhere classified

9211 : Motion picture and video production

7020 : Letting of own property

9212 : Motion picture and video distribution

7487 : Other business activities not elsewhere classified

9213 : Motion picture projection

9232 : Operation of arts facilities

9220 : Radio and television activities

9233 : Fair and amusement park activities

9231 : Artistic and literary creation and interpretation

9234 : Other entertainment activities not elsewhere classified

SIC 2003 group (3 digit)

9240 : News agency activities

742 : Architectural and engineering activities and related technical consultancy

9251 : Library and archive activities

744 : Advertising

9252 : Museum activities and preservation of historical sites and buildings

9253 : Botanical and zoological gardens and nature reserve activities

9261 : Operation of sports arenas and stadiums

MAG Tier 2 - Financial Products

9262 : Other sporting activities

SIC 2003 group (3 digit)

9271 : Gambling and betting activities

741 : Legal, accounting, book-keeping and auditing activities; tax consultancy; market research and public opinion polling; business and managesment consultancy; holdings

9272 : Other recreational activities not elsewhere classified

SIC 2003 division (2 digit)

9304 : Physical well-being activities

65 : Financial intermediation, except insurance and pension funding

SIC 2003 division (2 digit)

66 : Insurance and pension funding, except compulsory social security

55 : Hotels and restaurants

67 : Activities auxiliary to financial intermediation

MAG Tier 1 - Retail

MAG Tier 2 - Health

SIC 2003 class (4 digit)

SIC 2003 group (3 digit)

5010 : Sale of motor vehicles

331 : Manufacture of medical and surgical equipment and orthopaedic appliances

5030 : Sale of motor vehicle parts and accessories

332 : Manufacture of instruments and appliances for measuring, checking, testing, navigating and other purposes, except industrial process control equipment

5040 : Sale, maintenance and repair of motorcycles and related parts and accessories

334 : Manufacture of optical instruments and photographic equipment

5050 : Retail sale of automotive fuel

851 : Human health activities

SIC 2003 division (2 digit)

852 : Veterinary activities

51 : Wholesale trade and commission trade, except of motor vehicles and motorcycles

52 : Retail trade, except of motor vehicles and motorcycles; repair of personal and household goods

MAG Tier 2 - Biotech

SIC 2003 class (4 digit)

2414 : Manufacture of other organic chemicals

2415 : Manufacture of fertilisers and nitrogen compounds

7310 : Research and experimental development on natural sciences and engineering

SIC 2003 group (3 digit)

242 : Manufacture of pesticides and other agro-chemical products

244 : Manufacture of pharmaceuticals, medicinal chemicals and botanical products

MAG Tier 2 - Creative

SIC 2003 class (4 digit)

2211 : Publishing of books

2212 : Publishing of newspapers

2213 : Publishing of journals and periodicals

2214 : Publishing of sound recordings

2215 : Other publishing

2223 : Bookbinding

2224 : Pre-press activities

2231 : Reproduction of sound recording

2232 : Reproduction of video recording

2233 : Reproduction of computer media

7414 : Business and management consultancy activities

7481 : Photographic activities

7487 : Other business activities not elsewhere classified

9211 : Motion picture and video production

9212 : Motion picture and video distribution

9213 : Motion picture projection

9220 : Radio and television activities

9231 : Artistic and literary creation and interpretation

SIC 2003 group (3 digit)

742 : Architectural and engineering activities and related technical consultancy

744 : Advertising

MAG Tier 2 - Financial Products

SIC 2003 class (4 digit)

7011 : Development and selling of real estate

7012 : Buying and selling of own real estate

7031 : Real estate agencies

7032 : Management of real estate on a fee or contract basis

7110 : Renting of automobiles

7121 : Renting of other land transport equipment

7122 : Renting of water transport equipment

7123 : Renting of air transport equipment

7131 : Renting of agricultural machinery and equipment

7132 : Renting of construction and civil engineering machinery and equipment

7133 : Renting of office machinery and equipment including computers

7134 : Renting of other machinery and equipment not elsewhere classified

7140 : Renting of personal and household goods not elsewhere classified

7450 : Labour recruitment and provision of personnel

7460 : Investigation and security activities

7485 : Secretarial and translation services

7486 : Call centre activities

7487 : Other business activities not elsewhere classified

8042 : Adult and other education not elsewhere classified

SIC 2003 group (3 digit)

741 : Legal, accounting, book-keeping and auditing activities; tax consultancy; market research and public opinion polling; business and managesment consultancy; holdings

SIC 2003 division (2 digit)

65 : Financial intermediation, except insurance and pension funding

66 : Insurance and pension funding, except compulsory social security

67 : Activities auxiliary to financial intermediation

MAG Tier 2 - Health

SIC 2003 group (3 digit)

331 : Manufacture of medical and surgical equipment and orthopaedic appliances

332 : Manufacture of instruments and appliances for measuring, checking, testing, navigating and other purposes, except industrial process control equipment

334 : Manufacture of optical instruments and photographic equipment

851 : Human health activities

Subsector Lookup

Agriculture forestry and fishing

Mining

Manufacturing

Energy and water

Construction

Distribution and catering

Transport and communication

Finance and business

Public admin etc.

Education health and social work

Other services

Tourism

Research and Development

Agriculture

Coal extraction etc

Meat processing

Electricity production & distribution

Construction

Motor vehicle distribution & repair, etc

Railway transport

Banking

Public administration

Education

Sewage & sanitary services

Tourism Average

Research and Development

Forestry planting

Oil & gas extraction

Fish & fruit processing

Gas distribution

Wholesale distribution

Other land transport

Other financial institutions

Health & veterinary services

Membership organisations nec

Hotels, catering & pubs etc

Forestry harvesting

Metal ores extraction

Oils & fats processing

Water supply

Retail distribution

Water transport

Insurance & pension funds

Social work activities

Recreational services

Sea fishing

Other mining & quarrying

Dairy products

Hotels, catering & pubs etc

Air transport

Auxiliary financial services nec

Other service activities

Fish farming

Grain milling & starch

Ancillary transport services

Auxiliary to insurance

Private households with employed persons

Animal feed stuffs

Postal & courier services

Owning & dealing in real estate

Bread, biscuits etc

Telecommunications

Letting of dwellings

Sugar

Estate agent activities

Confectionery

Renting of machinery

Other food products

Computing services

Spirits & wines, etc

Research & development

Beer brewing

Legal activities

Soft drinks

Accountancy services

Tobacco

Market research

Textile fibres

Architectural activities etc

Textile weaving

Advertising

Textile finishing

Other business services

Made-up textiles

Carpets & rugs

Other textiles

Knitted goods

Wearing apparel & fur products

Leather goods

Footwear

Wood & wood products

Pulp, paper & paperboard

Paper & paperboard products

Printing & publishing

Coke, refined petroleum & nuclear fuel

Industrial gases & dyes

Inorganic chemicals

Organic chemicals

Fertilisers

Synthetic resins

Pesticides

Paints, varnishes, printing ink etc

Pharmaceuticals

Soap & toilet preparations

Other chemical products

Man-made fibres

Rubber products

Plastic products

Glass & glass products

Ceramic goods

Structural clay products

Cement, lime & plaster

Articles of concrete etc

Iron & steel

Non-ferrous metals

Metal castings

Structural metal products

Metal containers, etc

Metal forging, pressing etc

Cutlery, tools etc

Other metal products

Mech. power equipment

General purpose machinery

Agricultural machinery

Machine tools

Special purpose machinery

Weapons & ammunition

Domestic appliances nec

Office machinery & computers

Electric motors & generators etc

Insulated wire & cable

Electrical equipment nec

Electronic components

Transmitters for TV, radio & phone

Receivers for TV & radio

Medical & precision instruments

Motor vehicles

Shipbuilding & repair

Other transport equipment

Aircraft & spacecraft

Furniture

Jewellery & related products

Sports goods & toys

Misc. manufacturing nec, recycling

Spreadsheet's Author: oweni
Last Updated with Excel 97

* This cell's format is not supported.

** This cell's data may not be accurate.

Created with xlhtml 0.5.1