Excel Employee Bonus Cost Calculations
Budget: $25 – $50 USD
I need to expand an existing Excel workbook so the Total Cost per employee now includes a bonus that is driven purely by performance metrics. All calculations must start from the employee data already in the file; the only new data point you will work with is Bonuses, which are to be determined “based on performance metrics” that I will provide as a numerical score for each employee.
Here’s what I’m after:
• Build a clean, maintainable formula (or, if absolutely necessary, a short, well-commented VBA routine) that converts each employee’s performance score into a bonus value.
• Add this bonus into the overall Total Cost column so the sheet instantly updates whenever scores or salaries change.
• Keep everything contained in the one workbook and avoid external links or add-ins.
Deliverables
1. Updated Excel file with the working bonus-to-cost calculation in place.
2. A short note inside the sheet (or separate README) explaining the logic so our HR team can tweak the bonus rules later if needed.
I’ll send a copy of the workbook plus the performance data as soon as we start. Let me know how you plan to structure the formula and any edge-cases you think we should cover.
Here’s what I’m after:
• Build a clean, maintainable formula (or, if absolutely necessary, a short, well-commented VBA routine) that converts each employee’s performance score into a bonus value.
• Add this bonus into the overall Total Cost column so the sheet instantly updates whenever scores or salaries change.
• Keep everything contained in the one workbook and avoid external links or add-ins.
Deliverables
1. Updated Excel file with the working bonus-to-cost calculation in place.
2. A short note inside the sheet (or separate README) explaining the logic so our HR team can tweak the bonus rules later if needed.
I’ll send a copy of the workbook plus the performance data as soon as we start. Let me know how you plan to structure the formula and any edge-cases you think we should cover.