-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) CIPD Level 7 7C001 Question 10 organisational restructuring, employees’ working patterns and stability
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) Sourcing essentials (PSE) Facilities management category
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
This report evaluates and compares four key sourcing approaches: sole, single, dual, and multiple sourcing, within ROSHN, focusing on facilities management as the primary category of spend.
Facilities management is chosen due to its critical role in maintaining ROSHN’s large-scale residential projects and ensuring operational efficiency.
Each sourcing approach is analysed for its advantages and disadvantages, and its applicability to specific procurement needs is explored using strategic tools like the Kraljic matrix and supplier preferencing models.
For instance, sole sourcing is applied to specialised maintenance services, while single sourcing is used for cleaning services due to quality control needs.
Dual sourcing is chosen for security services to mitigate risks, and multiple sourcing is recommended for office supplies within facilities management to foster competition and innovation.
A detailed supplier appraisal checklist for the facilities management category is developed using Carter’s 10 C’s model to ensure a thorough evaluation of supplier capabilities. This checklist ensures that ROSHN selects suppliers who meet stringent quality, reliability, and cost-effectiveness criteria.
The findings highlight the importance of strategic sourcing in maintaining ROSHN’s competitive advantage in the Saudi Arabian real estate market.
The following recommendations aim to optimise ROSHN’s procurement processes, ensuring efficiency, cost-effectiveness, and resilience in its supply chain:
- Conduct thorough market research using tools like Porter’s Five Forces and PESTLE analysis to understand the supplier landscape and market dynamics better.
- Integrate advanced eSourcing tools, including ERP systems and eAuctions, to streamline procurement processes and increase efficiency.
- Adopt dual and multiple sourcing strategies to mitigate risks, enhance competition, and ensure supply continuity for critical categories.
- Develop and maintain strong supplier relationships through continuous performance evaluations, clear communication, and strategic partnerships.
- Provide training and development opportunities focused on strategic sourcing, negotiation skills, and advanced procurement technologies.
(Solution) ICS Learn Level 3 3C004- Essentials of People Practice
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD Question 3- For and Against use of performance appraisals in formulating pay progression decisions
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS APCM – Advanced Practitioner Corporate Award
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.