-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) 70S05 Question 1 (AC 1.4) People-Related Ethical Issues for Fitter Threads Ltd
Original price was: £ 15.00.£ 10.00Current price is: £ 10.00.
(Solution) 5OS06 (AC1.2) Explain the meanings of ‘leadership development’ and ‘management development’ making a clear distinction between these two functions
Original price was: £ 40.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) CIPD 7OS05 Major Ways People Practice Vary Globally
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD Level 7 Assessment 7C001- Work and Working Lives in a Changing Business Environment
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.