-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%

(Solution) CIPS Sourcing Essentials Assessment

,
Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
  • In this assessment, sourcing approaches have been identified and holistically reviewed. This is in line with RCU organisation IT spend category. This is further compared with payment services, document management category which is office suppliers and postal services.
  • For evaluating the identified spend categories, various tools have been selected which are Kraljic Analysis Tool, Mendelow’s Analysis Tool for Stakeholder analysis and the Maslow Hierarchy of needs.
  • Further, by using the SWOT analysis, the internal and external factors of the sourcing have been selected. A further analysis by use of Peter Block Grid’s has been applied to evaluate the interests of stakeholders to source appropriate position.
  • The findings indicate that RCU adopts the best sourcing approach based on their needs.
  • Finally, by using Carter’s 10Cs model, the best practice for pursuing suppliers appraisal has been provided for IT spend category.
-67%
Placeholder

(Solution) CIPS Emirates Transport Company Strategic Supply Chain Management SSCM

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
  • This assessment has focused on evaluating the supply chain map in Tyres spend category in ETC organisation.
  • The relevance of this has been to enumerate the extent in which their supply chain is characterised by strengths and weaknesses as it influence the scope of the stakeholders interaction.
  • Successful evaluation and eventual development of supply chain is core as it note on stakeholders visibility, ethical-best practice, risk management and costs reduction.
  • Strengths identified to be associated with the 2-tier supply chain entail a high-level collaboration, cost reduction and managing time appropriately.
  • ETC is found to gain from a high-level positioning in UAE Transport sector. This is with their innovation increasing since supply chain is integrated with technology use.
-67%
Placeholder

(Solution) CIPS ADNOC Sourcing Essentials (PSE)

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Executive Summary In this report, the various sourcing approaches for a selected spend category in ADNOC organisation has been
-67%
Placeholder

(Solution) CIPD Level 7 Assessment 7C001- Work and Working Lives in a Changing Business Environment

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Question 1 From the reviewed literature, there lacks a universal common definition of globalisation. Nevertheless, WTO (2023) identify globalisation
-50%
Placeholder

(Solution) MER CIPS Cost Management by Procurement and Supply Management Teams

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution As part of PS&M operations, issues linked with cost overruns, time to market, product and service differentiation, these represent
-67%
Placeholder

(Solution) CIPD Level 5 Avado PQ CIPD_5CO03_24_01 5C003

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution AC 1.1 Appraise what it means to be Nexxobyte people professional. A people professional, or an HR professional in