-75%
Awaiting product image
Click to enlarge

(Solution) CIPD Avado SECTION 2 1.4 Data Analysis

New User Gifts

First Order Deal get Ksh 200 Off.

KaribuCustomer

Original price was: £ 40.00.Current price is: £ 10.00.

Payment Methods:

Description

Solution

SECTION 2

1.4 Data Analysis

To calculate the percentage turnover for each department, I used the formula:

Turnover Percentage= (Total Employees/Leavers​) ×100

2020

  • Administration: 4/22×100=18.2%
  • Maintenance: 5/9×100=55.6%
  • Marketing: 0/4×100=0%
  • Production: 70/231×100=30.3%
  • People Team: 1/6×100=16.7%
  • Research & Design: 1/4×100=25%
  • Sales: 19/42×100=45.2%
  • Packing & Dispatch: 21/36×100=58.3%
  • Finance: 2/5×100=40%

2021

  • Administration: 8/20×100=40%
  • Maintenance: 3/8×100=37.5%
  • Marketing: 0/4×100=0%
  • Production: 3/2198×100=16.2%
  • People Team: 0/6×100=0%
  • Research & Design: 0/3×100=0%
  • Sales: 3/35×100=8.6%
  • Packing & Despatch: 6/15×100=40%
  • Finance: 0/4×100=0%

2022

  • Administration: 9/20×100=45%
  • Maintenance: 3/8×100=37.5%
  • Marketing: 1/4×100=25%
  • Production: 3/8178×100=21.3%
  • People Team: 3/6×100=50%
  • Research & Design: 0/4×100=0%
  • Sales: 0/40×100=0%
  • Packing & Despatch: 8/16×100=50%
  • Finance: 0/4×100=0%

2023

  • Administration: 2/18×100=11.1%
  • Maintenance: 1/7×100=14.3%
  • Marketing: 0/4×100=0%
  • Production: 29/181×100=16%
  • People Team: 2/5×100=40%
  • Research & Design: 1/4×100=25%
  • Sales: 2/45×100=4.4%
  • Packing & Despatch: 3/15×100=20%
  • Finance: 0/3×100=0%

To calculate the overall turnover rate for the entire organization each year, we sum the total number of leavers and total employees, then apply the turnover formula:

Overall Turnover Percentage= (Total Employees/Total Leavers​) ×100

2020:

  • Total employees = 359
  • Total leavers = 123
  • Turnover: 123359×100=34.3%

2021:

  • Total employees = 285
  • Total leavers = 52
  • Turnover: 52285×100=18.2%

2022:

  • Total employees = 275
  • Total leavers = 62
  • Turnover: 62275×100=22.5%

2023:

  • Total employees = 282
  • Total leavers = 40
  • Turnover: 40282×100=14.2%

Data Presentation

  1. Bar Graph-The following is the Bar Graph presenting the year-wise Turnover percentages of each department (2020-2023). It has a graphical display of the turnover rates by department making it less time consuming to determine departments with high or little turnover in the previous years.

Please click the following icon to access this assessment in full

 

Related Papers

-67%
Placeholder

(Solution) 7C002 Question 1 (AC1.1)

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Question ‘Fostering employee wellbeing is good for people and the organisation’. CIPD (2022) Drawing upon published research, produce a business
-75%
Placeholder

(Solution) 5C003 when and how you would react to both unethical and illegal matters (one of each) (AC 1.4)

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution 1.3 Raising unethical and Illegal Matters  Reacting to Unethical Matters: When encountering unethical behavior, such as a manager taking
-67%
Placeholder

(Solution) CIPD Assessment ID / CIPD_3CO04_23_01 3CO04 Essentials of people practice

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Task One – Written Advice Questions   Explain each stage of the employee life cycle and the role of
-50%
Placeholder

(Solution) CIPD Level 7 7HR02 Question 1 (AC 1.1) Analyse one external and one internal factor that is shaping the organisation’s resourcing and talent strategy

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution Question 1 (AC 1.1) Analyse one external and one internal factor that is shaping the organisation’s resourcing and talent
-67%
Placeholder

(Solution) 5OS04 Question 1 (AC 1.1) major ways in which UK and Japanese workplace cultures differ from each other

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Q 1: (AC 1.1) From Geert Hofstede’s cultural mapping research, major differences of UK and Japanese workplace cultures include
-67%
Placeholder

(Solution) CIPS Category Plan Implementation, Challenges Faced and Solutions

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
  • In this report, a category plan for Oracle in office materials category of spend has been developed.
  • Category planning has been noted to be a practice where category plans are established aligned with clients business objectives strategically to maximise value, risk reduction, and supply of goods and/or services effective management.
  • Therefore, the Oracle category plan is in tandem with retail and business portfolio objectives to advance clients' needs. The process is applicable in enhancing value maximisation, reducing risks, and goods and services supply management.
  • The applied data inform this assessment findings obtained using techniques such as Kraljic Matrix, Market Structure, PORTER’s 5, and SWOT analysis.
  • Further, existing data focusing on insights of market competition and TCO is successfully analysed.
  • Eventually, a successful category plan implementation has been developed, identifying challenges and approaches for mitigating the difficulties identified.