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 5 ICS Learn 5C001 Organisational Performance and Culture in Practice
5HR02 Payment Link
(Solution) CIPD AC 4.4: Other employment rights relating to Flexible Working
(Solution) 7C003 Assess the impact that sharing of learning has on organisational success
(Solution) CIPS APGM Requirements to initiate and prepare introduction of category management process
(Solution) Sourcing essentials (PSE) Facilities management category
- Conduct thorough market research using tools like Porter’s Five Forces and PESTLE analysis to understand the supplier landscape and market dynamics better.
- Integrate advanced eSourcing tools, including ERP systems and eAuctions, to streamline procurement processes and increase efficiency.
- Adopt dual and multiple sourcing strategies to mitigate risks, enhance competition, and ensure supply continuity for critical categories.
- Develop and maintain strong supplier relationships through continuous performance evaluations, clear communication, and strategic partnerships.
- Provide training and development opportunities focused on strategic sourcing, negotiation skills, and advanced procurement technologies.