I can't seem to solve this problem. I am setting up a bonus program for our
sales people. Each sales person sells 3 products (A, B and C.) Management
wants the products to be weighted 40%, 40%, 20% in the bonus plan. The bonus
payouts kick in at a minimum of 70% sales to quota. However, there is a
stipulation that no sales person can be paid if their sales growth is
negative.
I have been asked to set a growth target for each product. My concern is the
products are not growing very fast (around 2%-4% each.) I need to determine
the minimum targets need to be for each product to satisfy the above
criteria. Is there a way the Solver tool can solve this?
Bookmarks