Compensation Plan Variable Pay set different budget in different worksheet

[AprilKam]

Hi,

I have launched Variable Pay worksheets based on a template, but need to assign different budget percentages (or potentially fixed amounts) to individual worksheets representing different departments, overriding the single percentage set at the template level. I am desperately finding solution for this and unable to. 

I have tried to change budget calculation to direct amount mode based on group. Nothing seems to work. Also, I am not able to edit the worksheet directly via managed worksheet tab. 

Would greatly appreciate if you have any solution on this. 

BR,

April

[xavierlegarrec]

Hi @AprilKam 

As far as I know we don't have a way to meet all of these requirement right now (set budget by worksheet with employees not impacting it when moving), Florin's proposed solution is the only one.

I would be curious to understand or see what your Variable Pay template looks like:

• Do you have a business section and individual that are automatically calculated based on assignments ?
• Or do you have only an individual section and if so how do you use it ? do you calculate payouts at all ? 

Leading practice Variable Pay budgets only apply on the individual component of the calculation. For example if for an employee the max calculated business goals payout is 3000 and the max individual goals payout is 2000 then we can set the budget for that worksheet to be the sum of all max individual component target for all employees on the worksheet (so 2000 in our example + other amounts from other employees). By combining this with guidelines we can ensure that managers can still bump team members' bonuses while sticking to budget.

There was a post about budgets in Variable Pay not long ago with a link in it to all the different types of budgets we can have in VarPay that can be of interest to you:

https://community.sap.com/t5/human-capital-management-q-a/variable-pay-budget-calculation/qaq-p/1401...

All the best,
Xavier

[AprilKam]

@xavierlegarrec, Thanks for the reply. As what I see in the Variable Pay Template, we are able to set rules or configuration to set a basic budget % for all the worksheet that we create. E.g. if we were to set 10%, the system will calculate team annual + 10% as the budget. 

However, what we want to achieve is to pre-set budget for each worksheet. (similiar concept to budget assignment in Compensation template). E.g. worksheet 1, 10%, and worksheet 2 is 15%. 

I guess I will reach out to implemention or solution team if this can be done. Hopefully I am able to update any solution here in the future. 🙂 Thank you for the help. 

[xavierlegarrec]

@AprilKam  it is not possible to do this at this time in Variable Pay. Feel free to have your customer add an enhancement request for this. 

[FlorinZ]

Hi April,

The only option to have a fixed budget based on worksheets is by using cascading budgets. However, this is a legacy feature, so it is not necessarily recommended and comes with some limitations:

https://userapps.support.sap.com/sap/support/knowledge/en/2084543

[AprilKam]

Hi FlorinZ, thanks for the reply. The link you sent is for compensation, however, my issue is for variable pay template. hence, bonus assignment is not spported.

[FlorinZ]

yes, missed the VP part. Correct, in variable pay we don't have cascading budgets. only workaround i see, depending on the number of planners, would be to have a budget lookupt table % based on planner ID, and you calculate outside the system, after creating the forms the % needed as budget based on the total of the employees in the form and you update the lookup table after. Considering there will be no change in the number of employees in he forms, like movements or removing employees..

[AprilKam]

Looking at it, I will have about 22 - 25 worksheets to be created, there will be movements of employees. Hence I guess, putting amount will be the best. Do you have any guide how i should be creating the budget lookup table based on amount?

[FlorinZ]

the lookup table would be based on % of annual salary or total prorated target, you would need to calculate outside what would be the % needed in that lookup table for all the employees under one manager to give you in the end the value that you need (the lookup table will have as inputs the userID of the planner so when adding up in the end annual salary * % for all employee under one manager will give you to total that you need)). Howeer this will not work whe nyou have movements of employees or you will need to adjust the % always to reflect the same amount after one user is removed or moved to another form during the process.

[AprilKam]

If this is not feasible as I will be moving employees, is there any other solutions?