-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) ROSHN CIPS PIN Risk Profile
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD New Level 5 5CO03 Professional behaviours and valuing people Assessment ID / CIPD_5CO03_23_01
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) 7C003 Assess own approaches to decision-making on complex issues, taking ownership to remedy mistakes
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS ADNOC Onshore Module: Sourcing Essentials in Procurement & Supply
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
Executive Summary
For this assessment, focusing on sourcing essentials in procurement and supply, different approaches have been evaluated. Part of their evaluation include application in context of ADNOC Onshore operations. For ADNOC onshore organisation, they are involved in different categories of sourcing. To facilitate their operations onshore, ADNOC procures different products and services in multiple categories. The category of spend used in this assessment is the logging services. The sourcing approaches which have been identified for evaluation include sole, single, dual and multiple.
From the key findings of this evaluation evidence that sole sourcing exist when only one supplier is available and have zero choices to select from. This is with single sourcing being by choice and many being available. This is therefore a monopolistic market. The key findings on dual sourcing evidence that there are two available or more available but organisation make a choice for working with two. The final multiple selection findings evidenced that there are many suppliers in the market with choice of selection depending on the organisation. This is with the sourcing approach appropriate in an oligopolistic, imperfection and perfection. The findings are informed by different models including Mendelow Matrix (Peter Block), supplier preferencing matrix, and Kraljic Matrix being used in this report.
Also, part of this assessment include sourcing appraisal of the logging services category of spend. The key findings evidence that sourcing appraisal assists in coming up with a highly qualified suppliers group, reduction of risks and achieve the best value for money outcomes for the logging services sourced by ADNOC.
There are a set of limitations which have been evidenced in this report evaluation. These can be managed by implementing the following recommendations;
- For logging services, a unique sourcing approach would be used different from other sourcing approaches
- The sourcing appraisal can be expanded to include more factors
- Policies and practices need to be put in place for improving sourcing process
- An improved stakeholders relations and inclusion in sourcing approach selection need to be enhanced
- PS&M team increased awareness for various sourcing approaches and using RFP, RFQ and Product Lifecycle
(Solution) 5OS04 Question 10 (AC 4.2) personal attributes and competencies your companies should consider when selecting staff to work at the new parent company’s headquarters in Japan
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.