BSS004-1 Assignment 2: Brexit Impact on UK Organizations Report

This report analyzes the impact of Brexit on UK organizations, drawing on data from a survey conducted for the CIPD and Adecco Group. It examines how Brexit is influencing recruitment plans, redundancy decisions, and workforce composition across both public and private sectors. The report investigates key questions related to hiring intentions, potential redundancies, and the representation of EU nationals in various functions. Data findings are presented with interpretations, including graphical representations to highlight trends. Furthermore, the report explores the regional impact and the extent to which redundancies might affect overall headcount. In conclusion, the report offers recommendations based on the data analysis, providing insights into the challenges and opportunities presented by Brexit for UK organizations, focusing on workforce adjustments and future growth strategies.

2500 word report plus excel file
calculation
1

Contents
INTRODUCTION...........................................................................................................................3
TASKS.............................................................................................................................................3
Understanding of information needed by government................................................................3
Questions to provide information needed....................................................................................3
Data findings................................................................................................................................4
Recommendations......................................................................................................................14
CONCLUSION..............................................................................................................................15
REFERENCES..............................................................................................................................16
2

INTRODUCTION
Human resource analysis Is one of the important method that is used to create and assist insights
into the company’s workplace, nowadays remains the contribution of every worker generating he
profit for company, reducing the cost and also the modification of risk and achieving the
strategic plans for the organisation. while data analysis is helpful for the organisation to identify
the information that is needed and it can be helpful for them too build their name in the market.
This report will analyse the data of public and private sectors both bye interpreting the data in
order to gain understanding of the info that is required by the government. It will also select
some of the question analyse enter it so the useful information can begin. This report will take
help of the spreadsheet data and design the graph to make the information more highlighted and
outcomes can be evaluated. In the end of this report will recommend on the Brexit an what are
the benefits to the United Kingdom.
TASKS
Understanding of information needed by government
The present data is all about public and private sectors that are operating their business (Styliani.,
2019). It is related to the Brexit that has impact and it will identify what are the plans and how
dare growth is impacted. by analysing the data it will provide useful information to the
government that will be helpful for them to understanding the impact of Brexit. in that
government will obtain info that how private and public companies future hiring plans are and
how changing staff will affect their sales, culture and performance.
Questions to provide information needed
Q1. Is your organisation planning to recruit employees in the next THREE months
Q3. Is your organisation planning to make any redundancies during the next THREE months
M8_new. In which of the following functions do EU nationals have a particularly large
representation in your organisation? Please tick all that apply
M7. Compared to the rest of your workforce, do EU nationals have a particularly large
representation in particular occupations or functions
CO5. Which of the following best describes the region(s) in which your organisation operates
Q3a. To what extent will these redundancies affect your overall headcount over the next three
months
3

QE1. In the past three years, has your organisation employed people from any of the following
groups? Please tick all that apply
Data findings
Q1. Is your
organisation
planning to
recruit
employees in
the next THREE
months?
Private
sector
Public
sector
Third/voluntary
sector
Private
sector SME
(2-249)
Private
sector
large (250+)
Yes 532 217 63 150 382
No 869 94 70 498 371
Don't know 159 38 11 60 99
Private sector Public sector Third/voluntary
sector Private sector
SME (2-249) Private sector
large (250+)
0
100
200
300
400
500
600
700
800
900
1000
Yes No Don't know
Interpretation- By analysing above graph it can be evaluated that 532 private sector firms said
they are planning to hire staff in next 3 months. But 869 said no. in public sector firms 217 said
yes and 94 said no for this statement. Besides, in private SME 150 firms said yes and 498 said
no. in large private sector 382 said yes and 271 said no. therefore, it can be analysed that private
firms do not want to hire staff but public companies have made plan for it. They will hire
employees in next 3 months.
4

Q3. Is your
organisation
planning to
make any
redundancie
s during the
next THREE
months?
Private
sector
Public
sector
Third/
voluntary
sector
Private
sector
SME (2-
249)
Private
sector
large
(250+)
Yes 362 60 24 110 252
No 778 231 94 419 358
Don't know 421 58 25 179 242
Private sector Public sector Third/voluntary
sector Private sector
SME (2-249) Private sector
large (250+)
0
100
200
300
400
500
600
700
800
Series1 Series2 Yes No Don't know
Interpretation- by analysing the graph it can be stated that in private sector 362 organisation
said they have plan to do redundancies in next 3 months (Mohamed, Pärn and Edwards., 2017).
But 778 said no. similarly, in public firms 60 said yes and 231 said no for this. however, in
private sector SME 110 business said yes and 419 said no. and in large sector 252 said yes and
358 said no. hence, any businesses are planning to reduce staff. It is because of impact on brexit
on their growth and profits.
5

M8_new. In
which of the
following
functions do
EU nationals
have a
particularly
large
representati
on in your
organisation
? Please tick
all that
apply.
Private
sector
Public
sector
Third/
voluntary
sector
Private
sector
SME (2-
249)
Private
sector
large
(250+)
Managers,
Directors and
senior
officials
64 5 3 17 47
Administrative
and
secretarial
occupations
46 4 3 14 32
Elementary
occupations
(e.g.
cleaners,
catering
assistants,
hotel porters,
etc.)
75 24 8 12 63
Process,
plant and
machine
operatives
79 3 2 18 61
Sales and
customer
service
occupations
71 5 3 18 53
Caring,
Leisure and
Other Service
Occupations
42 15 10 13 29
Skilled trades
occupations 56 12 4 14 42
6

Associate
professional
and technical
occupations
(e.g. police
officers,
paramedics,
building and
fire
inspectors, IT
operations
technicians
etc.)
28 13 5 7 21
Professional
occupations
(e.g.
psychologists,
pharmacists,
lawyers etc.)
21 27 7 6 16
0
20
40
60
80
Series1 Series2 Series3 Series4 Series5
Interpretation- it can be evaluated from graph that in private sector in sales, customer executive
EU are more. And in manager there are 64. The public companies are having only few EU
nationalist. In private SME there are less EU people and in large private firms there are more EU
7

staff as compared to SME. Therefore, EU nationalist in private organisation is more than public
industry.
M7. Compared to
the rest of your
workforce, do EU
nationals have a
particularly large
representation in
particular
occupations or
functions?
Private
sector
Public
sector
Third/voluntary
sector
Private
sector SME
(2-249)
Private
sector large
(250+)
Yes 282 70 22 87 194
No 560 159 55 166 394
Don't know 136 27 7 20 116
Private sector
Public sector
Third/voluntary sector
Private sector SME (2-
249)
Private sector large
(250+)
0 100 200 300 400 500 600
Don't know No Yes Series2 Series1
Interpretation – it can be interpreted from graph that 282 private firms said yes there are many
EU workers working in their firm. and 560 said no. in public sector 70 said yes and 159 said no.
in private SME 87 said yes and 166 said no. moreover, in private large sector 194 said yes and
394 said no. thus, EU nationals are not so much in number in both private and public sectors.
8

CO5. Which of the
following best
describes the
region(s) in which
your organisation
operates?
Private
sector
Public
sector
Third/voluntary
sector
Private
sector SME
(2-249)
Private
sector large
(250+)
In only one UK
region 423 198 73 318 105
In multiple regions
across the UK 519 88 50 210 308
In both the UK and
internationally 619 63 21 180 439
Private sector
Public sector
Third/voluntary sector
Private sector SME (2-
249)
Private sector large
(250+)
0 100 200 300 400 500 600 700
In both the UK and internationally In multiple regions across the UK
In only one UK region Series2
Series1
Interpretation – the graph shows that 423 private companies work only in one UK region. 519
in multiple regions and 619 firms in UK and at international level. On contrary 198 public firm
function in one UK region, 88 in various other areas and 63 in UK and other countries ( Heusler.,
2020). Furthermore, in private SME 318 firms operate in 1 region, 210 in different areas and 180
in both. In large private firms 105 work in 1, 308 in multiple and 439 at global level.
9

Q3a. To what
extent will these
redundancies
affect your
overall
headcount over
the next three
months?
Private sector Public sector Third/voluntary
sector
Private sector
SME (2-249)
Private sector
large (250+)
It will affect 0.01%
to 10% 118 32 14 24 95
It will affect
10.01% to 20% 64 11 5 19 45
It will affect
20.01% to 30% 53 5 3 21 32
It will affect
30.01% to 40% 22 4 1 12 10
It will affect by
40.01% to 50% 23 2 1 13 10
It will affect
50.01% to 60% 14 1 - 6 8
It will affect
60.01% to 70% 3 1 - 1 2
It will affect
70.01% to 80% 8 - - 4 4
It will affect
80.01% to 90% 3 - - 1 2
It will affect
90.01% to 100% 7 1 - 4 3
Don't know 45 6 - 4 41
mean 33 7 5 10 23
median 22 4 3 6 10
SD 33.59137 9.357113 4.833218 7.959609 27.43407
mode 3 1 1 4 10
Interpretation- by evaluating table it can be stated that mean of private sector is 33 and median
is 22. SD is 33.5 and mode is 1. However, in public sector mean is 7 median is 4 SD is 9.3. the
10

private SME mean is 10, median is 6 SD is mode is 4. Large sector is mean is 23, median is 10
SD is 27.4 and mode is 10.
CO-3
Private sector Public sector Third/voluntary
sector
Private sector
SME (2-249)
Private sector
large (250+)
Well above
average 191 29 17 68 123
Above
average 631 100 51 247 384
Average 496 115 48 272 224
Below
average 120 22 13 66 54
Well below
average 28 7 2 14 14
Don't know 94 77 13 40 54
Net: Above
average 822 128 68 315 507
Net: Below
average 148 28 15 80 68
Mean 316 63 28 138 179
median 170 53 16 74 96
mode #N/A #N/A 13 #N/A 54
SD 274.3523 44.28812 22.20325 111.5759 167.9152
Interpretation- there are many ways that mean is private sector is 316 and median is 170. Also,
SD 274.3 the mean of public sector is 63 median is 53 and SD is 44.2. besides in private SME
mean is 138, median is 74 and SD is 111.5. the large private sector mean is 179, SD is 167.9 and
median is 167.9.
11

QE1. In the
past three
years, has
your
organisati
on
employed
people
from any
of the
following
groups?
Please tick
all that
apply.
Private
sector
Public
sector
Third/
voluntary
sector
Private
sector
SME (2-
249)
Private
sector
large
(250+)
People
aged 50-64 1024 257 112 397 627
People
aged 65
and above
467 128 62 139 328
People with
a disability
or long-
term health
condition
656 216 91 176 479
People
from a
Black,
Asian or
minority
ethnic
background
853 247 98 238 615
People
aged 19-24
with few or
no
qualification
s
883 207 77 306 577
12