Results 1 to 3 of 3
  1. #1

    Excel sales commission plan

    I would like to know how one can create a graduated sales commission plan in Excel. Any templates available that could be altered would be very helpful. Thanks in advance for any input.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Salt Lake City, Utah, USA
    Thanked 6 Times in 6 Posts

    Re: Excel sales commission plan

    It's relatively easy, depending on how your grad scale works. Set up the schedule and use =vlookup() to find and calculate the graduated scale.

    I don't have a graduated commission schedule readily available. Instead, attached is an example of a well-known US inverse graduated scale; the 2000 year of tax US personal income tax schedule. The attached has all the personal schedules, but only "married filing jointly" is set up for calculation. (Guess what I'm working on today?) The calc doesn't work for incomes below $6,450, God bless anyone to whom this omission applies.

    You could easily mess with this to come up with a sliding scale commission schedule. If you have something specific in mind, post it and we'll beat it into submission.
    Attached Files Attached Files
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Jacksonville,NC, USA
    Thanked 0 Times in 0 Posts

    Re: Excel sales commission plan

    If you aren't the one!!! This worked better the anything I've tried for the Federal Tax. Thank you so very much...You gave me a great deal to work with and I look forward to the saved me.
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts