-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) New CIPD 5C001- Organisational performance and Culture in Practice
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS PIN NUPCO Formal Commercial Negotiation Plan
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.
- For the current integrated modules assignment, a formal negotiation plan has been developed appropriate for the Procurement and Supply Management (PS&M) focusing on organisation operations.
- In this assessment, the National Unified Procurement Company (NUPCO) a leader in Saudi Arabia procurement, logistics and supply chain management for pharmaceutical, medical devices and supplies for government hospitals in Saudi Arabia (KSA).
- Further, the Ultrasound Machines procurement category has been identified in this report. By successfully reflecting on the content from driving value through procurement and supply, managing expenditures, developing contracts, sourcing essentials, negotiation in procurement and supply, relevant insights of the negotiation plan has been provided. Further, in this integrative assessment, the various tools applied include STEEPLE, Porter’s 5 Forces, SWOT analysis and Mendelow Matrix Stakeholders have been used to develop a successful negotiation strategy.
- The importance of this has been informed by the fact that NUPCO being a procurement organisation prioritise on attaining cost spending efficiencies and improvement of the healthcare services providers to government hospitals.
- This is with the skills, concessions, alternatives in the negotiation prioritised identified in this integrative assessment.
(Solution) CIPD 5HR03 appropriate ways in which benchmarking data can be gathered and measured to develop insight. (AC 2.2)
Original price was: £ 70.00.£ 10.00Current price is: £ 10.00.
(Solution) New CIPD Level 5 AVADO 50S01- Specialist Employment Law
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) Strategic Supply Chain Management for Circular Economy (CE) PART 2: Contemporary Issues in Strategic Supply Chain
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) Article: The Dangers of Recruiting for Cultural Fit
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.