-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) Principles of Marketing Market Segmentation & Targeting
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) 5C003 ability to do this with a written argument, which poses different theoretical perspectives, as well as your own (AC 2.1)
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) 5CO02 AC3.2) Explain how to measure the impact and value of people practice using a variety of (2) methods
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) 7CO03 1.1 Critically assess different ethical standpoints on people practice and the maintenance of high standards of ethical behaviour
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) New CIPD 5HR01- Employment Relationship Management
Original price was: £ 70.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS ADNOC APCM Advanced Category Management
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.
- In conclusion, this assessment has focused on developing an evaluation of the contractual terms and impact on power distribution in Abu Dhabi National Oil Company (ADNOC) and risk of supplier and organisation has been evaluated.
- A general contract used in ADNOC purchasing of goods has been used for achieving the aim of this assessment. Also, desk research and statistics have been used for the purpose of generating the expected findings.
- The findings indicate that the terms and conditions clearly stipulate on risks and power distribution between ADNOC and their suppliers of the gas turbines. This has been identified by application of various tools and models relevant for this assessment.