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) 7C003 Plan continuing professional development that involves both planned learning and reflection
(Solution) Oakwood International 5CO02 Evidence-based practice
(Solution) CIPS ADNOC APGCM tools & techniques that can be applied to map categories of direct & indirect expenditure
(Solution) New Royal Commission for AIUla (RCU) Commercial Negotiation Plan- PIN
- Establishing an Integrated Digital Procurement System within the next year to track project timelines and quality metrics, aiming for a 20% improvement in service reliability for IT consultancy services.
- Implementing a Comprehensive Supplier Training Program over the next year, with a goal of achieving at least 80% supplier participation to ensure alignment with ROSHN's operational standards and improve service quality by 25%.
- Conducting Quarterly Supplier Performance Evaluations, utilizing a performance scorecard for at least 90% of suppliers to assess compliance with agreed-upon targets, with the objective of increasing average performance metrics by 15% over the year.
- Developing an Enhanced Risk Assessment Protocol within six months to identify and mitigate key risks in the IT consultancy supply chain, targeting a 30% reduction in overall risk exposure through proactive measures.