Problem
The customer uses an Excel sheet to calculate salary differences between years.
This process relies on multiple salary tables specific to job levels and states, making it complex to maintain and use.
Manual input and calculations reduce efficiency and increase the risk of errors.
Solutions
Support multiple states and job levels for accurate, year-wise salary calculations.
Automate calculations using backend logic and ensure real-time display of salary differences.
The app will allow users to easily compare salaries between years, accounting for variables like working hours percentage and extra pay.
Benefits
Error Reduction and Efficiency: Automated calculations eliminate human errors from manual Excel input and formulas.
Easier to update: salary tables in the backend, ensuring the calculator stays up to date with minimal effort.
Open Access: Users can access the tool without login.
Key Features
User Inputs
Options for selecting State (specific salary tables for German regions).
Options for Job Levels to reflect different pay scales.
Users can enter custom working hours (e.g., 50%, 80%) to adjust salary calculations accordingly.
Input any additional allowances or extra pay components
Automated Salary Calculations
Backend logic to handle complex formulas for salary comparisons.
Calculations are based on different pay scales and job levels for each state.
Automatically adjust salaries according to the percentage of working hours entered by the user
