-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 Explain what diversity and inclusion mean and why they are important (AC3.4)
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) New CIPS Corporate Award Advanced Practitioner (CAAP) Project proposal
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
Today, in oil and gas sector in UAE, it is encountering immense pressures from different stakeholders for addressing tendering process in their contracts management. Nevertheless, there exist less literature which has evaluate the implication of incorporation of technologies for enhancing issues linked with accessing, delivering timelines and input. This is through developing a system which enhance one-on-one communication reducing the entire contracts evaluation cycle.
The process would have a positive implication on ADNOC and their different suppliers by managing issues associated with access, timeline of provision, communication, paper usage and input therefore reduced tendering evaluation process.
The different deliverables for the current project would include the following;
- Improved engagement of different stakeholders in tendering process of contracts process
- Increased costs savings by reducing communication barriers and also reducing the number of employees working in tendering process
- An effective data management and recording for ensuring success in evaluation and use of the data for contracts tendering process metrics
- Effective management of issues in the contracts evaluation and recommend best strategies in their mitigation during tendering process
- To effectively pursue trend analysis to understand the history of evaluations and effectively use the data in managing tendering process
(Solution) CIPS APCM ADNOC Category Planning
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS Module Sourcing Essentials (PSE) SWS (Sustainable Water Solution)
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
Executive Summary
This report evaluates and contrasts various sourcing strategies within the SWS (Sustainable Water Solution) organisation, focusing on the health and safety (HS&E) category of spend during the COVID-19 pandemic, which necessitated remote working. To assess the different sourcing strategies, tools such as the Kraljic analysis, Mendelow's stakeholder analysis, the business hierarchy of needs, and the SWOT analysis were employed. Additionally, the Peter Block Grid was used to categorise stakeholders based on their interests and positions related to the sourcing strategies.
In the supplier evaluation for the HS&E category of spend within SWS, Carter's 10Cs methodology was applied to assess different sourcing strategies. The results indicate that SWS should adopt a strategic sourcing approach to sustain its leadership in the sustainability and water management industry while maximising efficiency. The sourcing strategies include multiple sourcing (engaging with multiple suppliers), single sourcing (working with one supplier), sole sourcing (working with a monopolistic supplier), and dual sourcing (working with two suppliers who might have conflicting demands).
In conclusion, the recommendations for SWS's sourcing strategies in the HS&E category of spend are as follows:
- Determine the most suitable sourcing strategy based on the characteristics of the spend category.
- Ensure procurement policies are comprehensive and prioritize health and safety standards.
- Simplify the procurement process while considering the interests of all stakeholders.
(Solution) 7HR03 Question 3 (AC 3.2) Advantages and disadvantages of using incremental pay scales within organisations and appropriateness
Original price was: £ 15.00.£ 10.00Current price is: £ 10.00.
(Solution) Level 7 7C001 Question 3- Populations Ageing Rapidly; Challenges for People Professionals
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.