-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 2024 5HR02 Talent management and workforce planning Assessment ID / CIPD_5HR02_22_01
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) 5C003 New (AC3.2) Assess your strengths, weaknesses and development areas based on self-assessment and feedback from others
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD Summarise different face-to-face and blended learning and development approaches including (AC6.3)
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS ADNOC Onshore Module: Sourcing Essentials in Procurement & Supply
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
Executive Summary
For this assessment, focusing on sourcing essentials in procurement and supply, different approaches have been evaluated. Part of their evaluation include application in context of ADNOC Onshore operations. For ADNOC onshore organisation, they are involved in different categories of sourcing. To facilitate their operations onshore, ADNOC procures different products and services in multiple categories. The category of spend used in this assessment is the logging services. The sourcing approaches which have been identified for evaluation include sole, single, dual and multiple.
From the key findings of this evaluation evidence that sole sourcing exist when only one supplier is available and have zero choices to select from. This is with single sourcing being by choice and many being available. This is therefore a monopolistic market. The key findings on dual sourcing evidence that there are two available or more available but organisation make a choice for working with two. The final multiple selection findings evidenced that there are many suppliers in the market with choice of selection depending on the organisation. This is with the sourcing approach appropriate in an oligopolistic, imperfection and perfection. The findings are informed by different models including Mendelow Matrix (Peter Block), supplier preferencing matrix, and Kraljic Matrix being used in this report.
Also, part of this assessment include sourcing appraisal of the logging services category of spend. The key findings evidence that sourcing appraisal assists in coming up with a highly qualified suppliers group, reduction of risks and achieve the best value for money outcomes for the logging services sourced by ADNOC.
There are a set of limitations which have been evidenced in this report evaluation. These can be managed by implementing the following recommendations;
- For logging services, a unique sourcing approach would be used different from other sourcing approaches
- The sourcing appraisal can be expanded to include more factors
- Policies and practices need to be put in place for improving sourcing process
- An improved stakeholders relations and inclusion in sourcing approach selection need to be enhanced
- PS&M team increased awareness for various sourcing approaches and using RFP, RFQ and Product Lifecycle
(Solution) CIPS New Global Strategic Supply Chain Project
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
- The purpose of this project is to evaluate supply chain automation by leveraging Industry 4.0 technologies. The identified technologies include Artificial Intelligence (AI) and Machine Learning (ML) noted as critical for streamlining operations and obtaining value-for-money outcomes. This has been pursued by focusing on Wood Plc.
- To conclude, the generated findings of this report evidence WPC is today adopting the application of iSourcing in their procurement and supply management (PS&M).
- In the current project, through an evaluation of options for automation of the organization PS&M, the findings evidence the existence of different limitations hindering the success of their system. The issues of cost overruns, lack of collaboration, and inefficient supply chain as the organization is expanding its current operations have been noted to include limitations of their current sourcing.
- Success in the automation of their supply chain has been identified to lead to the following outcomes;
- Organisation achievement owing to automation of their supply chain, increased confidence and capability, talent management, and employee competency
- Improved stakeholders relations (a later section of stakeholders analysis) easing the change process. Through the iSourcing improvement, WPC would be in a position of harnessing technical and commercial evaluation processes.
- Increased and robust systems and policies which mitigate overall gaps in sourcing system transformation
- Today, only lower than 10% of the entire WPC resources are used to prioritize automation and IT integration successfully. Automation would improve the use of resources in their operations
- Involve their IT and finance departments to ensure within a period of 6 months they
- WPC needs to consider embracing sustainable practices as part of investing in their Industry 4.0 technologies
- Through the adoption of automation, better communication systems backed by AI and ML would be introduced to achieve 70% increased communication effectiveness.
- It is important to increase this through increasing collaboration and alignment of all their interests holistically
- Partnering with institutions for the provision of capacity development opportunities for the PS&M teams and other organizations for the success of the automation process
- Expanding their sourcing of Industry 4.0 technologies. This is to involve highly reputable global companies hence efficient operations and integration of AI
- Source of support from the government to ensure that they are facilitated in terms of policies and appropriate regulations to guide the automation process.
(Solution) CIPS Saudi Syndicate Cohort 1 (Practitioner) PIN
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
This report is concerned with exploring diverse sourcing approaches in procurement and supply management (PS&M) for implementation in the IT category in today’s business environment.
The basis for this analysis is the IT procurement strategy at ROSHN, one of Saudi Arabia’s key contributors to its Vision 2030. Data, which have been gathered from ROSHN’s internal documents have been used to achieve the aim of the report and some strategic frameworks were applied such Mendelow’s Matrix, STEEPLE and Kraljic Matrix.
The findings here indicate that ROSHN’s preferred approach is to multiple source the services to ensure a degree of flexibility and to balance the risks involved in what is fundamentally a competitive and fast changing market. Multiple sourcing is used to increase vendor options and pricing competitiveness, while sole or single sourcing is used in very limited case.
Further it indicates that where dual sourcing is employed, the diverse solutions or vendor capabilities will be required to meet the extensive project requirements that ROSHN has for smart community development. ROSHN’s application of supplier appraisal tools in the IT category will achieve value for money, quality, and meet its strategic goals.
Based on these findings, several gaps were identified that can be managed through the following recommendations:
- Internal and external analyses should be carried out in order to pinpoint the best or most effective sourcing strategies for IT.
- A broader sourcing appraisal strategy should be introduced within the procurement policies and practices.
- Improve in focus in managing effective sourcing strategies based on organisational objectives.
- Broader inclusion of stakeholders in the procurement process, in order to enhance sourcing strategy effectiveness.
- Capacity development initiatives should be implemented in the PS&M practices, especially within IT category.