-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) CIPD L5 Assessment ID / CIPD_5CO03_23_015CO03 Professional behaviours and valuing people

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Task one – Questions   Appraise what it means to be a people professional. (AC 1.1) Short references should
-50%
Placeholder

(Solution) New CIPD AVADO 5HR01- Employment Relationship Management

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution 5HR01- Employment Relationship Management   Table of Contents Briefing Paper. 2 1.1 Employee involvement and participation. 2 Differences of
-75%
Placeholder

(Solution) CIPD ICS Learn Level 5 5HR01 EMPLOYMENT RELATIONSHIP MANAGEMENT

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution Employee involvement and participation Employee involvement is defined as a set of initiatives which offer opportunities for employees to
-75%
Placeholder

(Solution) CIPD New Level 7 7LD03- Designing Learning to Improve Performance

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution Table of Contents 1.0 Contextual Information Related to Organisation and Environment 2 1.1 Background. 2 1.2 Internal Factors. 2
-50%
Placeholder

(Solution) Royal Commission for AIUla (RCU) PDV- Driving Value Through Procurement and Supply; Managing Expenditures with Suppliers

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
In modern-day commercial organizations, the procurement department and the supply management department are both essential components. Procurement entails purchasing of goods and services required for the daily operations of an organization. It involves sourcing goods and services from external suppliers. Strategic procurement is vital for a firm’s success because it helps firms to obtain the required goods and services in the required at the right time and amount hence preventing surpluses that may result in waste. This paper provides an assessment of the Royal Commission for AIUla (RCU) procurement of Information Technology software as an area of spend. Similarly, this paper offers an assessment of the role of RCU partners in the procurement process. Different models  that are relevant to procurement and supply management have been analyzed in the context of procuring IT software as the area of spend. This paper has recommended that RCU should establish relevant processes for the execution of procurement processes to effectively manage the resource and hence get value for money  
-80%
Placeholder

(Solution) CIPS Oman LNG LLC Strategic Supply Chain Management

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
Solution Executive Summary In this report, a supply chain map for a category of spend in Oman LNG LLC organisation