Pay Plan Math

Feeling quantitative again today, so … suppose you have an F&I Director, or a menu trainer, or somebody, and their goal is to move product index from 1.0 to 1.2 over some time period.  To keep the numbers simple, let’s say the variable comp component is \$10K.

One way to do this is to say that 1.2 pays \$10K and the current performance, 1.0, pays zero.  This makes sense, right?  Why pay for no improvement?  This only works, however, if you place a cap on it.  As the salesman, I could come back and say, fine, if the two points of product index are worth \$10K to you, what happens if I hit 1.4?  Are you willing to pay me \$20K for that?

Most people resist the idea of capped pay plans.  Mathematically, you are making a linear relationship between compensation and performance, and you should be willing to honor that relationship up and down the line.  The problem here is that the line is too steep.

So, let’s try a shallower slope.  Once again, 1.2 pays \$10K, but this time the zero point is 0.0.  That means the current performance, 1.0, still pays \$8,333 and the salesperson doesn’t go hungry unless the index actually falls all the way to 0.0.  Obviously, this plan is too weak.

The weak plan may be desirable if your sales force is really counting on some of that money, and the “variable” is not as variable as advertised.  It also protects the company on the up side.  In this example, I can achieve a 1.5 index and it only earns me an extra \$2,500 (on top of the \$10K).

Now we have examples of two pay plans, one too strong and one too weak, as in the story of The Three Bears. The key to making the pay plan just right is to observe that the zero point is arbitrary. In the papa bear case, too strong, we set the zero point at 1.0, the current performance.  In the mama bear case, we set it at an index of 0.0.

Recall that a line on a graph is determined by two points.  One point is fixed by the target and the bonus (1.2, \$10K) the other point is set by where you place the zero (z, \$0) and between them they determine the slope:

If you’re making this chart right now remember to place the independent variable, product index, on the x-axis.  All that remains is to compute the y-intercept of your line.  The point where the bonus is zero, z, is the x-intercept.  A little algebra gives the y-intercept as:

Now we are ready to start plotting.  This time, let’s split the difference and set the zero point at 0.5.  This seems to be just about right.  Comp for standing still, 1.0, is \$7,143; for 1.5, only \$14,286, and our guy doesn’t starve until 0.5.

If you have this set up in a spreadsheet, you can tweak the zero point until you have the desired amount of exposure for both parties.  Below is the chart for my “goldilocks” line, with the mama bear case for comparison.

We always give careful thought to the target, but sometimes neglect the slope of the payoff line.  Next week, we will talk about two-dimensional pay plans, combining product index and PVR.

Author: Mark Virag

Management consultant specializing in software solutions for the auto finance industry.

One thought on “Pay Plan Math”

1. wmslattery says:

Great analogy and a very viable pay structure. As a Canadian F&I Sales Performance Coach the only hold back I see is, many Stake Holders up here are too greedy to implement such a Pay Plan. They want above average performance in the F&I Office, and the ability to CAP incomes. Many dealers already CAP incomes to the point they lose talent and then complain about production. However, that said its great for me because being a Coach the potential for continuous Coaching opportunities is never ending, I find myself going back time and time again to the same dealership because of turnover.