-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) Oakwood Level 5 5HR01 Employment relationship management Assessment ID / CIPD_5HR01_22_01
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) New 7C003 Task three -the final portfolio
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) New CIPS APPR Advanced Level 6 Final Assessment
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
- In conclusion, the findings in this report indicate that Woolworths is currently using Ariba and SAP systems. This study covers the annual spend of Woolworths, the portfolio of Woolworths, their Category and Risk Management.
- Based on the study, Woolworths have to reduce their annual costs, and this may be supported by automation of as many processes as possible and this will also improve their efficiency and effectiveness levels.
- Woolworths also has made significant efforts in categorising its products and managing supply and other risks by having a wide pool of suppliers.
- Further, the introduction of online shopping has greatly boosted their market reach and their competitiveness.
- Woolworths also has to consider grouping all its purchases into categories. This will greatly ease the amounts spent on buying individual items since bulk purchases allow for great discounts due to the economies of scale.
- Further, category management will ensure that the entire supply chain is managed effectively and efficiently with minimal instances of supply chain disruptions.
- Woolworths also must prioritise its stakeholders and acknowledge the role that each stakeholder plays and how this contributes significantly to the overall growth of the firm.
- Stakeholders have to be informed and involved when major decisions are to be made as this will enrich the strategies, contributions and suggestions brought forward.
- Stakeholder analysis is also key to maintain the stakeholder relations which improves not only the reputation of Woolworths but also the market share of Woolworths. This gives them a niche in their market.
(Solution) CIPD 7HR02 Contemporary Methods that Utilise Technology to Manage Individual and Team Performance
Original price was: £ 15.00.£ 10.00Current price is: £ 10.00.
(Solution) 7C002 Question 14 (AC4.2) CIPD Purpose champion better work and working lives
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.