I am about to start modeling our Sales Commission Payments process, but I am wondering whether to build it as a stand alone model or add the functionality within our existing Operating Costs Model.
The Calculation for the actuals (which is the part of the process that currently exists) will work of a set of lists which are not currently within the existing model, but once we have done phase 1 to build the payment calculation, we will then look at using that calculation to feed back into the operating cost model to help us budget better for the Sales Commission, so we'd then want to tie up the employee and the cost centre to the employee and the cost centre within the existing model.
What would be the most efficient way to build this?
Thanks
Kate