Math Help Needed for my job
In all my years here, I don't think I have ever seen anyone ask a work question, but I am so frustrated right now and there are so many people on this forum that are WAY smarter than me.
I am trying to develop an index that will allow me to evaluate share growth for a large amount of sales people. I want to compare the share growth of our brands at a sales rep level versus the share growth of the same products nationally. In other words, is the sales rep I'm evaluating growing their share as fast as the national growth. To add a wrinkle to the equation, I want to also factor in share opportunity. For instance, it is much easier to grow 1 share pt when your share is 20% vs. growing 1 share pt when your share is 60%. I have absolutely no problem with the formula when both the sales rep and the national share growth are positive. Where I run into trouble is when the share growth for either the rep or national is negative. Here is an example of both being positive and the calculation: Rep share this year 20%, Rep share last year 18% National share this year 10%, National share last year 9% My formula is ((20%-18%)/82%)/((10%-9%)/91%) =2.219 telling me the rep is growing their share 2.2 times faster than national. Time for a nice bonus! In the above the 82% represents the max the share can grow for the rep (100%-18%) and the 91% is the max the national share can grow (100%-9%) What do I do if either one or both of the share changes are negative. My formula above does not work. For instance, if the rep share increased from 18% to 20% and the National share decreased from 9% to 8%. The result is a negative number even though the rep is really doing well. Any thoughts would be appreciated. |
Quote:
|
Stephen - You are preaching to the choir. I have tried to convince the organization I work for (Fortune 50 company) that comparing this year to last year is not the way to go. However, it is like talking to a wall. I still live in the "Thats the way it has always been done" environment
So that leaves me no choice but to do my best with what I have. I'm trying my best to at least make this fair and equitable for everyone no matter how developed your share is. In the past, a rep who had a 60% share at their customer and gained.9 share points while Nationally the same products had a 20% share and gained 1 share pt was rated below average. Its much easier to grow 1 share pt in a market that is underdeveloped vs. .9 share points in an overdeveloped one. Hopefully that helps explain why I used the word frustrating in my original post. Also, thank you for all of your thoughts. |
Quote:
The problem with the "Thats the way it has always been done" mentality is that it does not provide a path for kaizen (continuous improvement) nor does it allow the data to provide insight as to WHAT must be done and WHY. What's really hard is when you have hard data with full statistical analysis and p-values that tell you what the truth is and the degree of statistical confidence, and if it goes against management wants to believe, its like spitting into the wind. Its like telling them: these are facts of the universe: f=ma and the execs are saying, "No, we don't like that, we we want f≠ma". :no: Deming was right; the reason most businesses (corporations) fail is not because how hard "the people who work" work, but because of the incompetence of the executive management. Best of luck! |
|
Quote:
|
I feel your pain. One sure way to have a really bad year was to have an exceptional year the previous year.
|
Quote:
Ding, ding, ding! Especially if it was a one-off project. “You need to find another project then.” |
Quote:
|
|
All times are GMT -4. The time now is 09:10 AM. |
Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
©Copyright 2009-2023 AudioAficionado.org.Privately owned, All Rights Reserved.