-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) 7HR01 Question 2 (AC 2.2) how the current labour market and organisational strategy impacts the management of employment relations within the organisation
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) Level 7 7C001 The Trend Towards Greater Globalisation of International Business Activity
Original price was: £ 15.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) 5C003 Discuss (two) strategies for designing and ensuring inclusive people practices. (AC 2.2)
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS Advanced Level Advanced Practitioner Corporate Award (APDP)
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
- In summary, this assessment, has focused on evaluating the process of leading a project team for implementing a new category management.
- For achieving this, British American Tobacco (BAT) in Malaysia has been used as an organisation of interest.
- The selected category of spend is technology and particularly the procurement of high speed machines for meeting the market demand. The rationale of this is that as an international organisation, BAT organisation engages both local and international suppliers in sourcing of technology.
- Considering this high demand, there has been challenges which sustainability of their sourcing approach. Therefore, BAT has been prompted to invest in a system which is modernised for ensuring modernisation of the procurement and supply process in BAT.
- For the Procurement and Supply Management (PS&M) tasked with the responsibility of procuring the technology system tend to take part in learning and development strategies, improving the suppliers relations, increasing alternation of the suppliers relations, high-level inclusion of stakeholders and to transform technology.