-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) 5OS06 (AC3.3) Assess two specific business benefits that can accrue to organisations which invest in first-rate, up-to-date, evidence-led leadership and management development programmes
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) New ICS Learn 5HR03- Reward for Performance and Contribution
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD Avado 5HR01- Employment Relationship Management
Original price was: £ 40.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) 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