Take the 2-minute tour ×
Mathematics Stack Exchange is a question and answer site for people studying math at any level and professionals in related fields. It's 100% free, no registration required.

I'm trying to figure out how to make a formula to solve this problem:

Say that you get paid commission based on how much you sell. If you sell anywhere from \$0 to \$5000, you get a commission rate of 8%. If you sell anywhere from \$5000.01 to \$10,000, you get a rate of 10%. Anything above \$10,000 gets a rate of 12%.

The trick comes with how the interest is applied. For example, if you sold $15,000:

the first $5000 gets %8
the second $5000 gets %10
and the third $5000 would get %12

resulting in

(5000 * 0.08) + (5000 * 0.10) + (5000 * 0.12) = 1500

Is there a way to create a formula for this? Also, I tagged this as linear algebra as I figure the formula will be algebraic, but I don't actually know what to tag this as.

share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

$x = $ Total Sold

Profit Earned $= \min(x,5000)*0.08+\max(\min((x -5000),5000),0)*0.1+\max((x-10000),0)*0.12$

share|improve this answer
    
thanks so much! –  LordZardeck Oct 17 '12 at 19:43
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.