-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) CIPD 5HR02 (AC2.2) Evaluate the techniques used to support the process of workforce planning
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS Assessment 1 PDV- Managing Expenditures with Suppliers
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
- In this assessment, by selecting a category of spend, the importance to organisation stakeholders has been provided.
- The organisation of focus is Royal Commission for AlUla (RCU). Also, by carrying out brief market analysis, an explanation of the extent in which procurement function offer value for money outcomes has been produced.
- The selected category of spend in RCU is the Information Technology (IT) and cybersecurity. In particular, the IT infrastructure and equipment sub-category of spend has been prioritised for evaluation.
- In order to achieve this assessment objectives, appropriate purchasing models have been selected for application.
- These included Mendelow Matrix Analysis, Porter’s 5 Forces, STEEPLE, SWOT analysis and more.
(Solution) CIPD Level 7 address the ethical issues connected with your research project (data storage, anonymity etc.)
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS Advanced Level Module 2: Commercial Management in Procurement & Supply
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) 7HR03 concepts of universal benefits as opposed to flexible ‘cafeteria’ style benefits and recommendations
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD Assessment ID/CIPD_5CO02_23_01 Evidence-based practice
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.