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) MCIPD Chartered Member Experience Assessment Your Strengths and Development Areas CIPD
(Solution) (AC4.1) Assess suitable types of contractual arrangements dependent on specific workforce need
Solution Permanent, full-time contracts Permanent, full-time contracts for delivery drivers offer both benefits and drawbacks, making their suitability dependent on ParcelCare’s operational needs and goals. Pros Permanent, full-time contracts provide job security and consistent income for delivery drivers, enhancing employee satisfaction and loyalty. This stability can lead to higher motivation and productivity, reducing turnover rates and the associated costs of recruitment and training as evidenced by Personio (2023). Full-time contracts also facilitate better workforce planning, ensuring ParcelCare has reliable staffing to meet delivery demands. Cons However, these contracts can be less flexible and more costly for the company. Full-time employees typically require benefits such as health insurance, paid leave, and retirement plans, increasing operational expenses. Additionally, the rigidity of permanent contracts may not align with fluctuating delivery volumes, leading to inefficiencies during low-demand periods. Suitability For ParcelCare, full-time contracts can be suitable if delivery volumes are consistently high, ensuring a stable workforce. However, a mixed model that includes part-time or flexible contracts might offer the necessary flexibility to adapt to changing demands while controlling costs. Part-Time Contracts Part-time contracts offer flexibility for delivery drivers, allowing them to balance work with other commitments. Drivers benefit from a stable income, albeit at reduced hours, while ParcelCare can adjust staffing levels according to demand. A significant advantage of part-time contracts is reduced costs associated with employee benefits, as part-time workers may not qualify for full benefits packages (Abogados, 2019). However, part-time drivers may lack the same commitment or availability as full-time employees, potentially impacting reliability and consistency. Zero-Hours Contracts Zero-hours contracts provide maximum flexibility, allowing ParcelCare to scale staffing up or down based on delivery demand without a fixed commitment to provide hours (CIPD, 2023c). For drivers, these contracts offer freedom to accept or decline work, appealing to those seeking flexibility. However, they also result in income uncertainty and lack of guaranteed hours, which can be challenging for drivers seeking stability. For ParcelCare, zero-hours contracts minimise costs during low-demand periods but may lead to difficulties in maintaining a loyal and consistent workforce due to potential driver dissatisfaction. Part-time contracts are most suitable for ParcelCare’s delivery drivers. They offer a stable income and consistent work schedule, which can enhance job satisfaction and reliability while allowing ParcelCare to adjust staffing levels as needed. This balance supports both operational needs and employee stability. Please click the following icon to access this assessment in full
(Solution) 5COO3 Professionals contribute confidently to discussions
(Solution) CIPS FIDIC Contracts Advanced Practitioner Corporate Award (APCE)
- In this report, an evaluation of a contract by Oracle which is FIDIC guiding their construction projects in more than 67 countries globally has been carried out.
- It is evident from the analysis that there are varying contractual terms having an influence on the power and risk distribution between a supplier and an organisation.
- The rationale of this is that a contract is a legally enforceable agreement between different parties with specific acts or practices to be put into account.
- The core report areas of focus of focus has included the issues of price, quality, construction projects delivery timeline and health and safety have been put into account on the extent in which the risk and power are distributed between the contractor and the organisations.
- In the components identified, it is evident that irrespective of whether the buyer or supplier executes the risk or power.
- Through the application of different tools such as Mendelow stakeholders matrix, SWOT analysis and others, distinct issues and risks characterised by various challenges in the construction projects execution with their mitigation approaches and risks have been evidenced.
- As evidenced from the Kraljic analysis, it is evident that contractual terms have a strategic relevance in the context of Oracle informing on their holistic leveraging on the risks and powers of the contract.
- In situations where Oracle fails in leveraging on contract holistic risks power balance, warrant and also insurance cover is used.
(Solution) CIPD 5CO02 principles of critical thinking
(Solution) CIPS ADNOC APCM Advanced Category Management
- 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.