Are you asking about how other people determine a commission rate or rates?
That's a little beyond the scope here. There was discussion here from one
person who had the commission rates escalate to a maximum amount based on
total sales - more bonus for more sales.

I can show you how to use Excel to calculate using the two methods you've
mentioned.

1st method
Column A has total sales, Column B will show commission

A B
1 $$$$$ =A1 * .05

Be sure to type the = symbol at the start of the formula in B1.

2nd method A = sales, B = expenses, C = commission

A B C
1 $$$$ $$$$ =(A1-B1)* .05


"k-leo" wrote:

hi,how do we calculate?...i have 2 methods,
1) amount of sales * 5% , say if the decided commision is 5%
2) (amount of sales - expenses of the month) * 5%
any other method will be highly appreciated,but a simple one.
please help someone.