-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) 3C004 CIPD Explain each stage of the employee life cycle and the role of the people professional in it. (AC1.1)
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD 5CO01 – Organisational performance and culture in practice Victory Training and Development Institute
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD Oakwood International 5CO01 Assessment ID / CIPD_5CO01_24_01
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS ADNOC Module: Global Strategic Supply Chain Management APGSS
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
This business report has been prepared to evaluate the global strategic approach to managing organisation supply chain. The organisation of focus is Abu Dhabi National Oil Company (ADNOC) operating in United Arab Emirates (UAE) oil and gas sector. In this highly competitive business environment, management of the supply chain is instrumental.
To achieve the intended aim of this report, the area of focus in evaluation included impact of market changes on the supply chain, sustainable global sourcing decisions, strategic logistical implications of globalisations and impact of supply chain management on corporate performance.
This has been enabled by referencing on various CIPS module notes models including SWOT, STEEPLED, Mendelow Matrix, Kraljic Matrix and Porter’s 5 Forces among others. Further, apart from the desk research available in ADNOC, secondary research has similarly been pursued.
The findings in this report evidence that market changes impact on the supply chain are influenced by the internal and external factors in the business environment.
Also, the findings indicate that sustainable global sourcing decisions impact the social, ethical and environment performance in selection of their suppliers. For ADNOC, priority is given to corporate social responsibility, responsible procurement and environment procurement. The strategical logistical implications of globalisation have been linked to inventory holdings, international logistics strategies, extending transport pipeline and multi-modal transportation.
From the findings in this business report, various gaps have been identified which can be managed through implementation of the following recommendations;
- Invest in collaboration, networking and technology for sustainable supply chain
- Improving supply chain development by providing capacity development for PS&M teams
- Holistic inclusion of stakeholders in conflicts management
- To include all tiers of supply chain for success in globalisation to manage all risks and performance challenges
(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) CIPS PDC Royal Commission for Alula Managing Risk of Poor Quality
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
In this second assessment, through a focus on Royal Commission for Alula (RCU) organisation, contract terms and conditions have been evaluated. The evaluation has focused on the effectiveness of these terms and conditions in;
- Ensuring management of risks of poor quality, extension of time, costs increase and unethical practices
- Making sure appropriate performance measures are monitored and managed