Understanding of Information Needed by Government

This report analyzes the data of public and private sectors to gain understanding of the information needed by the government. It includes data findings, recommendations, and conclusions.

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

People
aged 16-18
with few or
no
qualification
s
477 121 43 133 345
Ex-
offenders 206 69 25 44 162
Parents
returning to
the
workforce
715 206 84 184 531
People
returning to
the
workforce
after time
out of the
labour
market for
reasons
other than
having a
child, for
example
because of
other caring
responsibilit
ies or a
health
condition
500 159 63 91 409
War
veterans 269 98 21 41 228
None of the
above 130 10 7 114 16
Don't know 136 32 5 22 114
mean 526 146 57 157 369
mode #N/A #N/A #N/A #N/A #N/A
medain 489 144 63 136 377
SD 291.39
39
79.365
01 35.08403
107.62
86
196.83
08
Interpretation- this can be evaluated from table that mean of private sector is 526. Median is
489 and SD is 291.3. and in public sector mean is 146 and median is 144. The SD is 79.3 in
private SME mean is 157 and median is 136, SD is 107. In large private firm mean is 369 SD is
196.8 and median is 377.
13

It is evaluated from results that brexit will impact on private sector. This is because there
are more EU staff working in those companies at various positions. The public industry will not
be impacted as they are having less EU people. Therefore, private firms want to retain their staff.
They are not making any redundancies.
Recommendations
Brexit has huge impact on the policies of the government, procedures and legislations made by
them. it can also include the business operations (Barron, and Boutary., 2020). impact from the
Brexit memorandum. on the other side Brexit have the positive impact for the government and
businesses both. here are some of the discussion Are following
Brexit will have government of UK got you more freedom and making their own rules and
regulation within the country. it will also help time to gaining sovereignty Is seen as a will
situation of the UK as well As for those who adopt who stay in the European countries. This
sovereignty was one of the biggest benefit an achievement for the people who take advantage of
our Brexit becausr now they will be not able to required to give up some or rather kind of control
over some domestic affairs. This will also help the United Kingdom to reduce the number of
immigrants who come to UK as they will be gaining complete Control over their own borders
and immigrants will not able to enter in the United Kingdom. It will be directly impact was the
delivery government because they were able to reduce the immigration in their own country.
They will also able to improve within their housing and services need of localities and it will
create advantages how government of UK becausr not UK would be no longer to be required
contribution overall budget. United Kingdom pay huge contribution indeed budget where they
get very less spending. According to the budget of 2016 Britain spent around 13.1 billion
approximately as the membership fees of European budget but received only $4.5 billion for
their spending in the country which is very less. This is clearly helping to understand that Brexit
will be helpful in financial ways and it will be beneficial for the UK because they will able to
spend more in their own countries and take benefits.
It is evaluated from results that brexit will impact on private sector. This is because there are
more EU staff working in those companies at various positions. The public industry will not be
impacted as they are having less EU people. Therefore, private firms want to retain their staff.
They are not making any redundancies.
14

Proposed knew immigration system in the United Kingdom companies-
In order to work in the United Kingdom or continue to operate their business in the United
Kingdom it will be necessary for the all the organisation to apply for the new visa that will be
limited to the United Kingdom. They will be holding immigration sponsor licence that will be
only valid for the four years and it will be increase as well this becausr if they want to sponsor
individual for the work visa then they themselves need to have a sponsor licence. Wednesday
licences approved than organisations can apply for certificate of individual and sponsorship.
Without having the sponsorship licence companies who are working in the United Kingdom will
not able to participate and work within the UK.
CONCLUSION
As per the report has been analysed 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 has been
selected some of the question analyse enter it so the useful information can begin. This report has
been taken 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 has been recommended on
the Brexit an what are the benefits to the United Kingdom.
15

REFERENCES
Books and journals
Styliani, S., 2019. HEALTHCARE PROFESSIONALS’EXPERIENCE OF HR
MANAGEMENT DURING BREXIT-A CASE STUDY OF RECRUITMENT AND
RETENTION WITHIN THE NHS AFTER THE REFERENDUM TO LEAVE THE
EUROPEAN UNION (BREXIT).
Mohamed, M., Pärn, E. A. and Edwards, D. J., 2017. Brexit: measuring the impact upon skilled
labour in the UK construction industry. International journal of building pathology and
adaptation.
Oxford Analytica, Brexit will give the UK economy new opportunities. Emerald Expert
Briefings, (oxan-db).
Heusler, J., 2020. Brexit and Its Impact on Pharmaceutical Law: Implications for Global Pharma
Companies. Advances in Pharma Business Management and Research. p.27.
Singh, H. and Kaur, J., Brexit: The Politics of Immigration and its Impact on the Indian
Diaspora. BREXIT AND INDIA, p.168.
Barron, A. and Boutary, M., 2020. The Brexit dilemma for small business: European companies
respond. Journal of Business Strategy.
16