-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 ADNOC APCM Advanced Category Management
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.
- In conclusion, this assessment has focused on developing an evaluation of the contractual terms and impact on power distribution in Abu Dhabi National Oil Company (ADNOC) and risk of supplier and organisation has been evaluated.
- A general contract used in ADNOC purchasing of goods has been used for achieving the aim of this assessment. Also, desk research and statistics have been used for the purpose of generating the expected findings.
- The findings indicate that the terms and conditions clearly stipulate on risks and power distribution between ADNOC and their suppliers of the gas turbines. This has been identified by application of various tools and models relevant for this assessment.
(Solution) CIPD Level 5 ICS Learn Equality, diversity and inclusion (5OS05)
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.
(Solution) 5C003 Consider the importance of people professionals contributing to discussions in an informed, clear and confident way to influence others. (AC 1.3)
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS PSE RCU Cohort (Practitioner) Module 4 – Sourcing Essentials in Procurement & Supply
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
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
(Solution) New Oakwood International 5CO01 Organisational performance and culture in practice
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.