-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) 5CO02 Concept of evidence-based practice (EBP) and Technivara use to ensure sound decision-making in people practice
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD Question 4: Using Job Evaluations for Determining Reward Decisions
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS New Saudi Aramco Driving Value Through Procurement & Supply; Managing Expenditures with Suppliers
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
In this first project in Corporate Award Program, the focus has been on role of procurement supply and management (PS&M) responsibility in achieving value for money outcomes. This is through the focus on Saudi Aramco third party logistics spend category.
Also, a review on the current approaches to management of prices and costs for the third party logistics spend category has been identified.
This is by using different data and information from contracts management, procurement, commercial-driven development, strategic sourcing and PS&M practices.
Also, different models have been used including Mendelow, Kraljic matrix, Porter’s 5 forces, STEEPLED and Suppliers Preferencing model.
The key findings obtained in this project include the view that Saudi Aramco engage multiple stakeholders for successful practice.
Also, the key findings evidence their market environment as competitive hence success in achieving value for money outcomes.
The organisation strategy of achieving value for money outcomes has similarly been identified. This is with its pros and cons enhancing or limiting a successful implementation established.
From the findings and conclusions, various recommendations have been generated which include;
- An in-depth evaluation of positioning of all stakeholders for accommodating their interests in their operations
- In third party logistics, they can involve multiple sourcing to be competitive hence value for money
- To involve different specialists for gaining awareness on improving value for money
- Review of budget in sourcing third party logistics with technology involved in sourcing process.
(Solution) New 7C003 Task three -the final portfolio
Original price was: £ 20.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 Module: Global Strategic Supply Chain Management
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
- In this assessment, the focus has been on evaluating global strategic approach for WoodPlc supply chain identified. The relevance of this is informed by assumption that supply chain is anchored on the need to influence changes in market in supply chain practices. This is while sustainable global sourcing strategies being used.
- The findings evidence strategic logistical impact of an organisation and supply chain management process has an impact on corporate performance. The different tools and techniques which have been applied inform on the best practice of the organisation operations.
- For WoodPlc organisation working in oil and gas contracting sector in UAE, reviewing of their supply chain is used by use of best practice in their practice. Also, an identification of entire risks, issues incurred and opportunities evident.
- The findings in this report evidence different challenges as affecting collaboration. This assessment recommend need for Improving collaboration, network-based practice and innovativeness to ensure they embrace sustainability in supply chain
- Today, WoodPlc has been identified as lacking appropriate continuous development strategy for all stakeholders and end-users of their operations. Improving supply chain development through an increased chances for learning
- In WoodPlc, they are encountering immense transitioning from modern supply chain and use of technologies. There is a need to manage all the supply chain relations. This is for the Conflicts management in entire supply chain relations to ensure stakeholders are involved and part of the implementation of the practice
- In this report, it has been concluded on the existing challenges in their tiers. To manage the challenges identified from the Porters 5 forces analysis, there is a need to introduce end-to-end supply chain for their overall demands which capture various tiers for including all operations. This is to guarantee a successful management of the overall supply chain and performance management issues