-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

-75%
Placeholder

(Solution) CIPD AC 4.1: Major statutory rights workers have concerning pay

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution The statutory rights to employees in areas of pay has been improved to include 1 day in line with
-75%
Placeholder

(Solution) CIPS Module: Contract & Category Management in P&S (APGM)

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Question Module: Contract & Category Management in P&S Task You have been asked to prepare a business report evaluating category
Placeholder

(Solution) New 5HR01 (AC1.2) Compare forms of union and non-union employee representation

Read more
Solution (AC1.2) Compare forms of union and non-union employee representation. Short references should be added into your narrative below. Please remember
-67%
Placeholder

(Solution) CIPS Assessment 1 PDV- Managing Expenditures with Suppliers

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
  • In this assessment, by selecting a category of spend, the importance to organisation stakeholders has been provided.
  • The organisation of focus is Royal Commission for AlUla (RCU). Also, by carrying out brief market analysis, an explanation of the extent in which procurement function offer value for money outcomes has been produced.
  • The selected category of spend in RCU is the Information Technology (IT) and cybersecurity. In particular, the IT infrastructure and equipment sub-category of spend has been prioritised for evaluation.
  • In order to achieve this assessment objectives, appropriate purchasing models have been selected for application.
  • These included Mendelow Matrix Analysis, Porter’s 5 Forces, STEEPLE, SWOT analysis and more.
-67%
Placeholder

(Solution) Muscat University Sustainable Logistics and Supply Chain Management Assignment

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Table of Contents 1.0 Introduction. 3 1.1 Introduction to DSV.. 3 1.2 Corporate Structure of DSV.. 3 2.0 DSV’s
-80%
Placeholder

(Solution) CIPS Oman Cohort PSE Sourcing Essentials

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
  • This assessment has focused on identifying four sourcing approaches and explaining their application in the category of spend within XXX organisation.
  • Based on the different categories selected in sourcing approaches, IT category of spend supplier appraisal has been conducted.
  • Through a detailed evaluation, the sourcing approaches identified include multiple, single, dual, and sole.
  • For the IT category of spend, multiple sourcing has been selected as the most suitable due to the procurement nature.
  • In the Kraljic analysis tool identifying the nature of supplier relationships, IT has been classified as a leverage item.
  • The availability of different suppliers in procurement is identified as a multiple sourcing approach.
  • A single, dual or sole supplier is not suitable for IT procurement due to its technical and quality specifications required.
  • Carter’s 10Cs model has been selected for XXX IT sourcing supplier selection in the supplier selection.