Description
Solution
Table 1 Data
All department’s performance review judgements as a percentage:
Department | Quarter | Outstanding | Meets KPIs | Not Quite There | Underperforming |
Administration Department | 1 | 1 Absent (11-1=10)
2/10 x100= 20% |
1 Absent (11-1=10)
2/10 x100= 20% |
1 Absent (11-1=10)
3/10 x100= 30% |
1 Absent (11-1=10)
3/10 x100= 30% |
2 | 1 Absent (11-1=10)
1/10 x100= 10% |
1 Absent (11-1=10)
4/10 x100= 40% |
1 Absent (11-1=10)
4/10 x100= 40% |
1 Absent (11-1=10)
1/10 x100= 10% |
|
Sales Department | 1 | 100.00% | 0.00% | 0.00% | 0.OO% |
2 | 0.00% | 100.00% | 0.00% | 0.00% | |
Logistics Department | 1 | 4/10 x100=
20% |
8/10 x100=
40.00% |
6/10 x100=
30.00% |
2/10 x100=
10.00% |
2 | 5/20-2 Absent x100=
27.78% |
9/20-2 Absent x100=
50.00% |
4/20-2 Absent x 100= 22.22% | 0.00% | |
Research & Development | 1 | 3/10 x100=
30.00% |
3/10 x100=
30.00% |
1/10 x100=
10.00% |
3/10 x100=
30.00% |
2 | 1 Absent =(10-1=9)
5/9 55.55 |
1 Absent =
3/9 33.33% |
1 Absent =
1/9 11.11% |
0.00% |
Bonus Payments Calculation for ‘Outstanding’ Employees
Each eligible employee in the administrative department had their bonus payments added together during the first quarter to determine their overall bonus payment. This was the entire bonus sum that was due for that particular division and time period.
Formulae for Bonus: Salary x 0.04
Department | Employee | Salary | Bonus | Quarter |
Administration | Saffron Finch | £24,000 | £960 | Q1 |
Robin Bird | £31,500 | £1,260 | Q1 | |
Logistics | Sally Rigbye | £23,750 | £950 | Q1 |
Julie Chisnall | £19,500 | £780 | Q1 | |
Rick Lovall | £19,500 | £780 | Q1 | |
Gill Jamieson | £19,500 | £780 | Q1 | |
Research & Dev. | Ethan Brar | £32,500 | £1,300 | Q1 |
Tasha Graham | £29,500 | £1,180 | Q1 | |
Jennifer Frost | £29,500 | £1,180 | Q1 | |
Administration | Saffron Finch | £24,000 | £960 | Q2 |
Logistics | Ruth Sixsmith | £23,750 | £950 | Q2 |
Wendy Boot | £23,750 | £950 | Q2 | |
Jean Livesey | £26,000 | £1,040 | Q2 | |
Julie Chisnall | £19,500 | £780 | Q2 | |
Gill Jamieson | £19,500 | £780 | Q2 | |
Research & Dev. | Ethan Brar | £32,500 | £1,300 | Q2 |
Harrison Briggs | £32,500 | £1,300 | Q2 | |
Tasha Graham | £29,500 | £1,180 | Q2 | |
Jennifer Frost | £29,500 | £1,180 | Q2 | |
Steve Owen | £29,500 | £1,180 | Q2 | |
Total | £9,170 | Q1 Total | ||
£11,600 | Q2 Total | |||
£20,770 | Overall Total |
Summary of Bonus Payments
Quarter | Total (£) |
Quarter 1 | £9,170 |
Quarter 2 | £11,600 |
Overall Total | £20,770 |
Bonus Information Analysis
The Administration and Logistics teams earned constant awards in both Q1 and Q2, demonstrating consistent performance across departments, according to the bonus data. Particularly in the second quarter, a larger number of employees in the Logistics and Research & Development divisions received incentives. Bonuses went up from £9,170 in Q1 to £11,600 in Q2, which could be attributed to more output or better performance reviews in the second quarter.
Please click the following icon to access this assessment in full
Related Papers
(Solution) CIPD Level 7 7OS06 Wellbeing at work
(Solution) New CIPD 5HR01- Employment Relationship Management
(Solution) CIPD 5CO02 interpret analytical data using appropriate analysis tools and methods. (AC 2.1)
(Solution) CIPD PWC 3COO2- Principles of Analytics
(Solution) CIPD Level 7 methods you intend to use in collecting your data and information
(Solution) CIPS New Saudi Aramco Driving Value Through Procurement & Supply; Managing Expenditures with Suppliers
- An in-depth evaluation of positioning of all stakeholders for accommodating their interests in their operations
- In third party logistics, they can involve multiple sourcing to be competitive hence value for money
- To involve different specialists for gaining awareness on improving value for money
- Review of budget in sourcing third party logistics with technology involved in sourcing process.