-75%
(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.£ 10.00Current 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
- 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
(Solution) CIPS Project Evaluating the Impact of Generative Artificial Intelligence (AI) on Procurement Activities in Oman LNG
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS PDO Cohort Advanced Practitioner Sourcing Essentials PSE
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) ROSHN CIPS PIN Procurement Cycle and Sourcing Activity
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
Roshn is a national real estate developer owned by the Public Investment Fund of Saudi Arabia. Established in 2020, ROSHN’s mission is to deliver high-quality, affordable housing and develop thriving community destinations across the Kingdom.
As one of the largest real estate groups in the Middle East, ROSHN manages a portfolio of ambitious residential and mixed-use projects. With operations in major cities, ROSHN’s developments will contribute to Vision 2030 goals of increasing home ownership rates and improving quality of life for citizens.
To effectively manage its large-scale, nationwide portfolio, ROSHN relies extensively on advanced information technologies and robust cybersecurity protections to support all aspects of its business.
The scope of the organisation operations is as summarised in figure 1;
Figure 1:Summary of ROSHN Projects
Source: ROSHN (2023)
To evidence ROSHN’s success, several key investments have been made supporting their projects. The Public Investment Fund provided an initial $2 billion seed funding for Roshn's development, a historical area transforming ancient sites into vibrant destinations.
Additionally, over $3.2 billion has been committed through public-private partnerships for critical infrastructure development by 2023.
This success is informed by ROSHN’s strategic plans, which oversee approximately 25,000 square kilometers encompassing residential communities, natural assets like oasis valleys and mountains, and cultural heritage sites across Saudi Arabia (Argaam 2022).
The significant investments reflect confidence that ROSHN can successfully deliver on their mission of developing thriving regions nationwide.
(Solution) Module Title: Sourcing Essentials PSE PDO Cohort 9 (Advanced Practitioner)
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
Executive Summary
This report has focused on evaluating specific sourcing approaches which are used in different spend categories in Alaraby TV Network. This is achieved by focusing on the Information Technology (IT) as spend category for the organisation and particularly hardware sub-category. As part of fully digitising media operations in Alaraby TV Network, the organisation has been sourcing IT systems meant for enhancing their operations. As part of analysis, other spend areas including logistics, health and safety tools, communication equipment and videography and leasing for vehicles used in movement in Qatar. For the purpose of noting on various sourcing approaches, different tools in CIPS have been used including Mendelow Matrix, Kraljic tool among others.
The key findings in this report is that organisations use different sourcing approaches in their categories of spend. The choice of sourcing approaches is informed by the engaged stakeholders, the spend categories and external/internal factors. Also, the findings evidence that sourcing approaches are informed by the organisations position in their business environment. This report findings has identified these approaches as including single, sole, dual and multiple. Also, key findings in the supplier appraisal of the IT hardware sub-category, suppliers are best evaluated in line with the Cater’s 10Cs being applied. The application of the different sourcing approaches lead to Alaraby TV Network to dominate the entire Middle East region and leveraging on competitive advantage. Multiple sourcing has been identified in the findings as involving many suppliers with single sourcing involving one supplier while dual sourcing including different suppliers having demands that conflict.
From the identified gaps in this report, the following recommendations can be used to fill these gaps;
- Opting for most appropriate sourcing approach guided by spend category
- Priority on policies for PS&M to guarantee integration of all stakeholders interest
- Simplify overall procurement strategy for ensuring prioritisation of stakeholders point of view
- Using technologies in phases of procurement lifecycle including RFQ, RFP, e-Auction intended to improve how information ,flows in sourcing approaches identified
(Solution) 5C003 New (AC1.3) Consider the importance of people professionals contributing to discussions in an informed, clear and confident way to influence others
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) 5CO03 personal and ethical values application in people practice
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.