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
Terms and conditions help the organisation ensure relevant performance measures are monitored and managed
(Solution) CIPS ROSHN Module: Sourcing Essentials: PSE
Executive Summary
The goal of this evaluation was to compare and contrast various methods of sourcing. Various sourcing strategies have been assessed by centering on the ROSHN organization's Health and Safety Equipment (HS&E) expenditure category. Among these methods were sole, dual, multiple, and single sourcing. Various expenditure categories, including transportation, information technology, logistics, and employee uniforms, have been used to compare and contrast this. Tools such as the Mendelow Matrix analysis (for stakeholders), the Kraljic Analysis (for hazards), SWOT, and PESTLE (to determine if the market is oligopolistic or monopolistic) have been employed to carry out the analysis. The key findings evidence that ROSHN's sourcing strategies assist them successfully initiate projects which would lead to an increased house ownership in Saudi Arabia (KSA) as part of achieving their vision 2030. Further, the main findings evidence the multiple sourcing as involving many suppliers in an oligopolistic market, single one supplier with sole only one supplier available with dual involving two suppliers. Another key finding is that through the application of
been found by using the 10Cs model proposed by Carter, which focuses on technical and financial ratios among other things a strategic appraisal has been achieved. Managing the IT consultancy category is possible, according to ROSHN's study, because they've invested in the specified sourcing methods. With their varied and distinct applications in sourcing, each of the examined sourcing approaches has its own set of pros and cons.
From the findings and conclusions generated, various recommendations can be suggested which include;
• Formulate a plan for utilising various sourcing strategies according to their respective expenditure categories
• Make plans and procedures to include technology into their sourcing strategies.
• Simplify sourcing strategies while considering the needs of all parties involved.
• Enhance communication procedures as a means to measure the success of sourcing strategies.