Calculating and storing Minimum and maximum budgets based on model

Summary

Need a mechanism to store minimum and maximum budget based on the model values

Content

Hi All,

One of our client is trying to implement compensation and they use a compensation matrix based on Business Unit and Performance Rating to calculate the Budget.

I was able to create the matrix values using a model but they also require Minimum and Maximum value for Budget to be stored in the application so that they can adjust the budgets before publishing it. the Minimum and maximum budget values are again defined as an average of values for a lower performance rating.