Neep Help ! With Employee salary calculation spread sheet ! Very Hard!

Need Help!

Monthly salary = basic salary (minimum wages X working hour in a month) + commission product 1 + commission product 2......

e.g MONTHLY salary = 3000 + (50 X 30)+1000+3000

For each product

Commission
Price of a product || Percentage of commissioin
$0-$10000 =10%
$10001-$20000 =20%
$20001-$30000 =22%
$30001-$50000 =25%
$50001 or $above =30%

1. If salary + commission does not add up to =$4000 ;the remaning amount would add upto $4000 (forget this part if u dont get it)
e.g 3000 + 300 = $3300 ;$700 pay from the employer $4000

3. Eash product calculation is separate
2. If the price of a product is $20000 the commission would be : (First $10000 of 10%)+ Second $10000 of 20% = Commission $3000



Is there a formula?

lmplhk,

Pls provide sample sheet, I'll be providing you sheet as per your requirement,

Many thanks
Rishi Saw