-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

-50%
Placeholder

(Solution) HWO – D31VR Value and Risk Management

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution 1.0 Introduction In the execution of the contemporary projects, organizations are increasingly engaged in value and risk management. According
-50%
Placeholder

(Solution) CIPS PDV Saudi Aramco Current Approaches to Managing Prices and Costs

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution In Saudi Aramco current approach in management of prices and costs include use of their budget for getting the
-50%
Placeholder

(Solution) CIPS PDV Saudi Aramco Market Analysis; Procurement Function Produce Value for Money

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution  Brief Market Analysis Internationally, the overall revenues for Third Party Logistics (3PL) has a forecast of reaching upto US$1.21tn
-50%
Placeholder

(Solution) 5CO01 (AC3.3) Discuss processes for consulting and engaging with internal customers to understand their needs

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution (Solution) 5CO01 (AC3.3) Discuss processes for consulting and engaging with internal customers to understand their needs Consulting and engaging
-50%
Placeholder

(Solution) CIPS PSE RCU Cohort (Practitioner) Module 4 – Sourcing Essentials in Procurement & Supply

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
This assignment focus is evaluating various sourcing approaches used in Procurement and Supply Chain Management (PS&M). To achieve this aim, Royal Commission of Al-Ula (RCU) is used as the organisation of interest. By focusing on different categories of spend including technology systems, various sourcing approaches have been evaluated. The sourcing approaches in line with CIPS Module Notes include single, sole, multiple, and dual sourcing. The findings of this assignment have been informed by various tools and models used in analysis including Kraljic matrix, Mendelow matrix, business hierarchy of needs and SWOT analysis among others. The findings indicate multiple sourcing appropriate to involve many suppliers, single sourcing only one supplier with dual sourcing two suppliers only often evidencing conflicting expectations. At the end of this assignment, a supplier appraisal checklist has been provided using the Carter’s 10Cs model in the technology system sourcing category. From the findings and conclusions in this assignment, the identified limitations can be managed by using the following recommendations;
  • Transitioning from only one sourcing approach for all their spend categories and select each for all their spends
  • Ensure policies in PS&M are appropriately implemented while prioritising on their different stakeholders interest areas
  • Embrace of technologies in their sourcing process for sake of achieving modernised suppliers appraisal and eventual selection
  • Improve RCU Ariba and SAP system intended for improving exchange of data and information for supporting their sourcing approaches embrace
 
-80%
Placeholder

(Solution) CIPD 7OS05 Workplace Cultures Varying Globally

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
Solution 2.2 Workplace Cultures Varying Globally Globally, workplace cultures vary globally in areas of maintaining, renewal and shaping organisations viability.