Hello,
I have a salary schedule used for budgeting. Currently, the employee salary information comes from a payroll roster. A schedule to break out monthly budget for the year was created that calculates monthly salary based on an hourly rate as well as budgeted Start date and End date by calculating available paid work days for each month. However, I am not able to incorporate a scenario when a salary change is scheduled at budgeted month. I have attached a sample schedule but budget entries for a salary change on column S is not included in the current formula. My attempt to incorporate the salary change based on column S (New Rate) and column T (Effective date of new rate) that factors column N (Termination date) was unsuccessful. I would appreciate your expert advise in configuring the proper formula that allows this scenario.
Thank you,
Josie
I have a salary schedule used for budgeting. Currently, the employee salary information comes from a payroll roster. A schedule to break out monthly budget for the year was created that calculates monthly salary based on an hourly rate as well as budgeted Start date and End date by calculating available paid work days for each month. However, I am not able to incorporate a scenario when a salary change is scheduled at budgeted month. I have attached a sample schedule but budget entries for a salary change on column S is not included in the current formula. My attempt to incorporate the salary change based on column S (New Rate) and column T (Effective date of new rate) that factors column N (Termination date) was unsuccessful. I would appreciate your expert advise in configuring the proper formula that allows this scenario.
Thank you,
Josie