-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 L3 3CO02 Principles of analytics Assessment ID / CIPD_3CO02_23_01

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Section One – Briefing paper Questions   Explain what evidenced-based practice is and how it is applied within an
-75%
Placeholder

(Solution) CIPS ROSHN Negotiation Process

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
In this integrated assessment, a focus on a formal negotiation plan has been pursued. This is through the focus of Roshn organisation which is a Saudi Arabia’s largest real estate development company owned by the Public Investment Fund for KSA, has Vision 2030 supplier sourcing management strategies. The firm’s procurement department relies on a model outlined by Bailey et al that provides a rigorous approach to preparation and analysis in order to get better bargains. Hence, the Roshn internal supplier data collection and external market research to create accurate supplier risk and sourcing plans. A variety of tools is applied, such as the Kraljic Matrix that is used to sort suppliers. The key findings note that different training activities include negotiation simulations and skills to prepare and help procurement officers for the journey. Another key finding ius that detailed planning and analytical structures accompany objectives and concession tracking. Another key finding note that supply relations are strategically classified on issues of risk and consequences as far as supply management is concerned. On a continuous basis, repetition and necessarily sequenced post negotiation reviews improve processes gradually for a successful negotiation plan. From the findings and conclusions obtained, to maximise efficiency and optimise outcomes, it is recommended:
  • Roshn standardise the Bailey et al procurement framework.
  • Regular training will develop negotiation mastery, and the Kraljic Matrix will tailor strategies per supplier importance.
  • Sourcing strategies should evolve through market reviews. Building long-term, trusting partnerships will foster competitiveness beyond transactions.
  • Clear metrics measuring initiatives' success will empower data-driven process adjustments.
  • Adopting these practices will enhance Roshn's sustainable sourcing in support of Vision 2030 goals.
-75%
Placeholder

(Solution) 7CO03 Learning Journal business acumen can deliver commercial benefits and manage resilience

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution   1. Learning Journal     My learning objectives for this period were I need to: 1. Understand the
-50%
Placeholder

(Solution) CIPD New Avado 5C003- Professional Behaviours and Valuing People

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution Meaning of people professional By application of the CIPD Profession Map, it is possible to define people professional as
-75%
Placeholder

(Solution) CIPS Advanced Level Module 2: Commercial Management in Procurement & Supply

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution Executive Summary For this assessment, a business report has been developed for evaluating global commercial strategy. This report focuses
-80%
Placeholder

(Solution) 7C002 Question 6 (AC2.2)Linking People Management Practice with Improved business performance

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
Question There has been extensive research evidence that links people management practices with improved business performance. Selecting one piece of