Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Solver question
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver does not work from Macros | Setting up and Configuration of Excel | |||
Trouble with Solver | Excel Discussion (Misc queries) | |||
Using Solver with VBA | Excel Discussion (Misc queries) | |||
Solver parameter constraint question | Excel Discussion (Misc queries) | |||
question on excel Solver | Excel Worksheet Functions |