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 Sourcing Essentials (PSE) Saudi Aramco
Executive Summary
This assessment focuses on evaluating the various sourcing approaches applicable in Procurement and Supply Management (PS&M) for modern organisations. The organisation of focus is Saudi Aramco in their Third Party Logistics (3PL) spend area. Evaluation of the various sourcing approaches has been informed by a review of the internal data/documentation available, models of CIPS and module contents. The key findings in this report is that the preference in Saudi Aramco in sourcing of the 3PL spend area is the multiple sourcing. The choice is identified in the key findings as being informed by immense competition in their market. Also, the sole and single sourcing approaches are also a preference in an event the supplier exist in solitary with their involvement informed by varying organisation demands. Additionally, the key findings evidence single sourcing as being preferred when despite of multiple suppliers in place, the preference is only for one. This is while the dual sourcing being adopted in an event the various methods/choices in sourcing are used and prioritised. Eventually, by embrace of supplier appraisal tool, the 3PL sourcing in Saudi Aramco has been generated. The overall outcome of the appraisal process by embrace of Carter’s 10C’s note successful organisation is guided by successful value for money outcomes and improving market growth in oil and gas sector.
Considering the key findings and conclusions made in this assessment, a set of limitations and gaps have been generated which could be managed through a set of recommendations including;
- Pursue detailed internal and external analysis process for identifying best sourcing approach
- Introduction of a more detailed sourcing appraisal process by PS&M
- Focusing on management of success in sourcing approach defining the policy and operations of Saudi Aramco in 3PL sourcing
- Inclusion of all stakeholders in their practice for successful sourcing process
- Implement capacity development strategy for PS&M detailed appreciation of importance of various sourcing approaches
(Solution) University College of Bahrain MGT505 Leadership and Change Management
(Solution) 5CO01 (AC2.2) Assess how people practices impact on organisational culture and behaviour
(Solution) 7CO03 Learning Plan Curiosity and passion for deep learning
(Solution) Oakwood International 5CO03 Task One –Professional and ethical behaviours
Task One –Professional and ethical behaviours
This task requires you to consider the significance of professional and ethical behaviours for a people practitioner and the values that underpin the people practice profession. To complete the task, you should provide a written response to each of questions below, making appropriate use of academic theory and practical examples to expand your response and illustrate key points.- With reference to typical activities and behaviours, appraise what it means to be a ‘people professional’. (AC 1.1)
- Discuss how ethical values underpin the work of a people professional, including two examples of how ethical values might be applied in a people practice context. (AC 1.2)
- Consider the importance of people professionals being able to influence others and ensure that the ‘people practice voice’ is heard in an organisation, through informed, clear and confident communication. (AC 1.3)
- For each of the situations below (a & b), provide an example of an issue that would cause you to raise the matter to a manager (or other authority) - and describe how you would do this.
- a) where you consider something to be unethical (whether or not it is illegal),
- b) where you believe something contravenes legislation. (AC 1.4)
- Discuss two theories or models relating to the human and business benefits of people at work feeling included, valued, and fairly treated, concluding your discussion with a summary of your own view of these benefits. (AC 2.1)
- Discuss two ways in which a people professional can build inclusivity into a people practice initiative at the design stage, and two ways of checking inclusivity after a people practice initiative is implemented. (AC 2.2)